# ZangTable

## Docs

- [Authentication](https://docs.zangtable.com/authentication.md): How to use Project API Tokens safely.
- [Concepts](https://docs.zangtable.com/concepts.md): The data model behind projects, tables, tokens, records, and exports.
- [Errors and best practices](https://docs.zangtable.com/errors-best-practices.md): Common failures and production-safe integration guidance.
- [Filters and validation](https://docs.zangtable.com/filters.md): How list filters, bulk where clauses, and common validation rules work.
- [Exports](https://docs.zangtable.com/guides/exports.md): Generate and download table, database, and schema artifacts.
- [Query and indexes](https://docs.zangtable.com/guides/query-and-indexes.md): Use read-only SQL and table indexes.
- [Records](https://docs.zangtable.com/guides/records.md): Read and write rows in your tables.
- [Tables and columns](https://docs.zangtable.com/guides/tables-and-columns.md): Design tables and evolve schema safely.
- [ZangTable Public API](https://docs.zangtable.com/index.md): Project-scoped SQLite database API for server-side applications.
- [Operation grouping](https://docs.zangtable.com/operation-groups.md): Group related API calls in API journey tooling.
- [Quickstart](https://docs.zangtable.com/quickstart.md): Make your first ZangTable API calls from a server-side integration.
- [POST /projects/{project}/auth/tokens](https://docs.zangtable.com/reference/auth/create-project-api-token.md): Creates a new Project API Token for the project.
- [DELETE /projects/{project}/auth/tokens/{token_id}](https://docs.zangtable.com/reference/auth/delete-token.md): Revokes a token by id.
- [GET /projects/{project}/auth/me](https://docs.zangtable.com/reference/auth/get-current-auth.md): Returns the authenticated Project API Token summary.
- [GET /projects/{project}/auth/tokens](https://docs.zangtable.com/reference/auth/list-tokens.md): Lists Project API Tokens for the project.
- [POST /projects/{project}/auth/tokens/test](https://docs.zangtable.com/reference/auth/test-token.md): Tests Project API Token access against a table.
- [PATCH /projects/{project}/column/{table}](https://docs.zangtable.com/reference/columns/bulk-update-columns.md): Applies multiple column patches.
- [POST /projects/{project}/column/{table}](https://docs.zangtable.com/reference/columns/create-column.md): Adds a non-primary column to an existing table.
- [DELETE /projects/{project}/column/{table}/{column_id_or_name}](https://docs.zangtable.com/reference/columns/delete-column.md): Drops a non-primary column.
- [GET /projects/{project}/column/{table}/{column_id_or_name}](https://docs.zangtable.com/reference/columns/get-column.md): Returns one column.
- [GET /projects/{project}/column/{table}](https://docs.zangtable.com/reference/columns/list-columns.md): Lists columns for a table.
- [PATCH /projects/{project}/column/{table}/{column_id_or_name}](https://docs.zangtable.com/reference/columns/update-column.md): Renames or changes editable column metadata.
- [POST /projects/{project}/export/database](https://docs.zangtable.com/reference/exports/create-database-export.md): Creates a database export for selected tables.
- [POST /projects/{project}/export/schema](https://docs.zangtable.com/reference/exports/create-schema-export.md): Creates a schema export.
- [POST /projects/{project}/export/table/{table}](https://docs.zangtable.com/reference/exports/create-table-export.md): Creates a table export manifest and artifact.
- [DELETE /projects/{project}/exports/not-found](https://docs.zangtable.com/reference/exports/delete-missing-export-records.md): Deletes project export manifest rows whose status is `not_found`.
- [GET /projects/{project}/export/download/{export_id}](https://docs.zangtable.com/reference/exports/download-export.md): Downloads an export artifact.
- [GET /projects/{project}/exports](https://docs.zangtable.com/reference/exports/list-exports.md): Lists project-scoped export manifests.
- [Reference overview](https://docs.zangtable.com/reference/overview.md): Public ZangTable endpoints grouped by product area.
- [POST /projects/{project}/indexes/{table}](https://docs.zangtable.com/reference/query/create-index.md): Creates an index on one or more existing columns.
- [DELETE /projects/{project}/indexes/{table}/{index}](https://docs.zangtable.com/reference/query/delete-index.md): Drops a managed index.
- [GET /projects/{project}/indexes/{table}](https://docs.zangtable.com/reference/query/list-indexes.md): Lists managed indexes for a table.
- [POST /projects/{project}/query](https://docs.zangtable.com/reference/query/query-records.md): Runs one read-only SQL statement.
- [DELETE /projects/{project}/records/{table}](https://docs.zangtable.com/reference/records/bulk-delete-records.md): Bulk-deletes rows matching a where clause.
- [PATCH /projects/{project}/records/{table}](https://docs.zangtable.com/reference/records/bulk-update-records.md): Bulk-updates rows matching a where clause.
- [POST /projects/{project}/records/{table}](https://docs.zangtable.com/reference/records/create-record.md): Inserts one row or an array of rows.
- [DELETE /projects/{project}/records/{table}/{id}](https://docs.zangtable.com/reference/records/delete-record.md): Deletes one row by primary key.
- [GET /projects/{project}/records/{table}/{id}](https://docs.zangtable.com/reference/records/get-record.md): Returns one row by the table’s single-column primary key.
- [GET /projects/{project}/records/{table}](https://docs.zangtable.com/reference/records/list-records.md): Lists rows in a table.
- [PATCH /projects/{project}/records/{table}/{id}](https://docs.zangtable.com/reference/records/update-record.md): Updates one row by primary key and returns the fresh row.
- [DELETE /projects/{project}](https://docs.zangtable.com/reference/service/delete-project.md): Deletes a project database after explicit slug confirmation.
- [GET /projects/{project}](https://docs.zangtable.com/reference/service/get-project.md): Returns project metadata and counts.
- [PATCH /projects/{project}](https://docs.zangtable.com/reference/service/update-project.md): Updates the project display name.
- [POST /projects/{project}/table](https://docs.zangtable.com/reference/tables/create-table.md): Creates a table and its initial columns.
- [DELETE /projects/{project}/table/{table_id_or_name}](https://docs.zangtable.com/reference/tables/delete-table.md): Deletes a table and its saved metadata.
- [GET /projects/{project}/table/{table_id_or_name}](https://docs.zangtable.com/reference/tables/get-table.md): Returns one table and its columns.
- [GET /projects/{project}/table](https://docs.zangtable.com/reference/tables/list-tables.md): Lists tables in a project.
- [PATCH /projects/{project}/table/{table_id_or_name}](https://docs.zangtable.com/reference/tables/update-table.md): Updates table metadata.
- [Response envelope](https://docs.zangtable.com/response-envelope.md): The shared success and error response shape.