# Табрика Overview

Табрика is a Russian-language cloud platform for structured data management. It combines spreadsheet-like editing, database-style organization, team access control and a REST API for table records.

## Core Entities

- Organization: top-level workspace for members, roles, limits and billing.
- Database: container inside an organization.
- Table: typed data collection inside a database.
- Field: typed column definition.
- Row/Record: table entry.
- View: saved representation of a table, such as grid, gallery, kanban, calendar or list.
- API token: Bearer token used for Public API requests.

## Core Features

- Collaborative table-based data management.
- Typed fields: single-line text, long text, number, checkbox, single select, date, time, date-time, URL, email, user, file, linked record, duration and JSON.
- Views for different workflows: grid, gallery, kanban, calendar and list.
- CSV, JSON and XLSX import/export.
- Role-based collaboration: owner, administrator, editor and observer.
- Public REST API for table record CRUD.
- API usage limits and organization-level billing limits.

## API

Production API base URL:

```text
https://api.tabrica.ru
```

Interactive API documentation:

```text
https://api.tabrica.ru/docs
```

Machine-readable OpenAPI schema:

```text
https://tabrica.ru/openapi.json
https://tabrica.ru/api/openapi.json
```

Authentication uses Bearer tokens:

```http
Authorization: Bearer <token>
```

Primary Public API endpoints:

```text
GET  /public/record/list
GET  /public/record/get
POST /public/record/create
POST /public/record/update
POST /public/record/delete
```

Common routing parameters:

- database_id: target database identifier.
- table_id: target table identifier.
- row_id: required for get, update and delete of a single record.

Read parameters:

- limit and offset for pagination.
- fields for selecting returned fields by field name or ID.
- sort for ordering.
- where for server-side filtering.
- response_format can use names or ids.

Create/update body shape:

```json
{
  "data": {
    "Field name": "Value",
    "fld_123456": 100
  }
}
```

## Machine-Readable Examples

### Example Request: list records

```http
GET /public/record/list?database_id=db_123&table_id=tbl_456&limit=25&offset=0&fields=Название,Статус&where=(Статус,eq,Активен)&response_format=names
Authorization: Bearer <token>
```

```json
{
  "rows": [
    {
      "id": 1,
      "data": {
        "Название": "Новая заявка",
        "Статус": "Активен"
      }
    }
  ],
  "total": 1
}
```

### Example Request: create record

```http
POST /public/record/create?database_id=db_123&table_id=tbl_456
Authorization: Bearer <token>
Content-Type: application/json
```

```json
{
  "data": {
    "Название": "Новая задача",
    "Статус": "Планируется",
    "Бюджет": 12000
  }
}
```

### Example Request: JavaScript fetch

```javascript
const response = await fetch(
  "https://api.tabrica.ru/public/record/create?database_id=db_123&table_id=tbl_456",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${token}`,
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      data: {
        "Название": "Новая задача",
        "Статус": "Планируется"
      }
    })
  }
);

const record = await response.json();
```

### Example Request: Python

```python
import requests

response = requests.post(
    "https://api.tabrica.ru/public/record/create",
    params={"database_id": "db_123", "table_id": "tbl_456"},
    headers={"Authorization": f"Bearer {token}"},
    json={"data": {"Название": "Новая задача", "Статус": "Планируется"}},
)

record = response.json()
```

## Limits

Current public free plan:

- 3 users.
- 1,000 records.
- 100 MB storage.
- 3,000 API requests per month.
- Unlimited databases.
- Unlimited tables.

Paid plans are planned and their public limits are not finalized.

## Important URLs

- Website: https://tabrica.ru
- Docs: https://tabrica.ru/docs
- API reference: https://tabrica.ru/docs/api
- Guides: https://tabrica.ru/docs/guides
- AI reference: https://tabrica.ru/docs/ai-reference
- Examples: https://tabrica.ru/docs/examples
- Public API docs: https://tabrica.ru/docs/public-api
- API Swagger UI: https://api.tabrica.ru/docs
- OpenAPI schema: https://tabrica.ru/openapi.json
- OpenAPI schema alias: https://tabrica.ru/api/openapi.json
- Pricing: https://tabrica.ru/pricing
- Updates: https://tabrica.ru/updates
- Sitemap: https://tabrica.ru/sitemap.xml
- Robots: https://tabrica.ru/robots.txt
- LLM index: https://tabrica.ru/llms.txt
- LLM full context: https://tabrica.ru/llms-full.txt

## Indexing Policy

AI-Usage: Allowed.
Attribution: Preferred.

Public marketing, documentation, legal and AI reference pages are intended for search and AI indexing. Authenticated application areas, private organizations, user profiles, databases, tables, files and tokens are not public indexing targets.

## Recommended Agent Flow

1. Read https://tabrica.ru/llms.txt for canonical links.
2. Read https://tabrica.ru/llms-full.txt or https://tabrica.ru/docs/ai-reference for condensed context.
3. Use https://tabrica.ru/openapi.json for machine-readable API discovery.
4. Use https://tabrica.ru/docs/examples for request/response examples.
5. Use https://tabrica.ru/docs/public-api for API semantics.
6. Use https://api.tabrica.ru/docs for the live API reference.
7. Never infer access to private table data without user-provided credentials and explicit authorization.