Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| NOCODB_BASE_URL | Yes | The base URL of your NocoDB instance | |
| NOCODB_API_TOKEN | Yes | Your NocoDB API token (can be obtained from profile settings) | |
| NOCODB_DEFAULT_BASE | No | Optional default base ID to use |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_bases | List all available NocoDB bases/projects |
| get_base_info | Get detailed information about a specific base/project |
| list_tables | List all tables in a base |
| get_table_info | Get detailed information about a table including its schema |
| create_table | Create a new table in a base with specified columns. Supports various column types including SingleSelect (with options), PhoneNumber, QrCode, and Barcode. |
| delete_table | Delete a table from the database |
| add_column | 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_column | Delete a column from a table |
| insert_record | Insert a single record into a table |
| bulk_insert | Insert multiple records into a table |
| get_record | Get a single record by ID |
| list_records | List records from a table with optional filtering, sorting, and pagination |
| update_record | Update a single record |
| delete_record | Delete a single record |
| search_records | Search for records containing a query string |
| list_views | List all views for a table |
| create_view | Create a new view for a table |
| get_view_data | Get records from a specific view |
| query | Execute an advanced query with filtering, sorting, and field selection |
| aggregate | Perform aggregation operations on a column |
| group_by | Group records by a column and get counts |
| upload_attachment | Upload a file attachment to NocoDB storage |
| upload_attachment_by_url | Upload files to NocoDB storage from URLs |
| attach_file_to_record | Attach an uploaded file to a record |
| get_attachment_info | Get information about file attachments in a record |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |