List all available NocoDB bases/projects

Get detailed information about a specific base/project

List all tables in a base

Get detailed information about a table including its schema

Create a new table in a base with specified columns. Supports various column types including SingleSelect (with options), PhoneNumber, QrCode, and Barcode.

Delete a table from the database

Add a new column to an existing table. For SingleSelect: provide options in meta. For QrCode/Barcode: provide reference column ID. PhoneNumber uses standard text storage.

Delete a column from a table

Insert a single record into a table

Insert multiple records into a table

Get a single record by ID

List records from a table with optional filtering, sorting, and pagination

Update a single record

Delete a single record

Search for records containing a query string

List all views for a table

Create a new view for a table

Get records from a specific view

Execute an advanced query with filtering, sorting, and field selection

Perform aggregation operations on a column

Group records by a column and get counts

Upload a file attachment to NocoDB storage

Upload files to NocoDB storage from URLs

Attach an uploaded file to a record

Get information about file attachments in a record