NocoDB MCP Server
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 |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_basesB | List all available NocoDB bases/projects |
| get_base_infoB | Get detailed information about a specific base/project |
| list_tablesC | List all tables in a base |
| get_table_infoC | Get detailed information about a table including its schema |
| create_tableC | Create a new table in a base with specified columns. Supports various column types including SingleSelect (with options), PhoneNumber, QrCode, and Barcode. |
| delete_tableC | Delete a table from the database |
| add_columnB | 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_columnC | Delete a column from a table |
| insert_recordC | Insert a single record into a table |
| bulk_insertC | Insert multiple records into a table |
| get_recordC | Get a single record by ID |
| list_recordsC | List records from a table with optional filtering, sorting, and pagination |
| update_recordC | Update a single record |
| delete_recordC | Delete a single record |
| search_recordsC | Search for records containing a query string |
| list_viewsC | List all views for a table |
| create_viewC | Create a new view for a table |
| get_view_dataC | Get records from a specific view |
| queryC | Execute an advanced query with filtering, sorting, and field selection |
| aggregateC | Perform aggregation operations on a column |
| group_byC | Group records by a column and get counts |
| upload_attachmentC | Upload a file attachment to NocoDB storage |
| upload_attachment_by_urlC | Upload files to NocoDB storage from URLs |
| attach_file_to_recordC | Attach an uploaded file to a record |
| get_attachment_infoC | 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 | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/andrewlwn77/nocodb-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server