Nocodb

You can connect to a NocoDB instance through this MCP server to perform bases, tables, records, views, and file attachments from AI agents. It provides a programmable interface to manage NocoDB data, enabling automated workflows across your teams.

How to use

Start by running one of the MCP server configurations below, then connect your MCP client to it. You can perform database operations (list bases, get base info), manage tables and columns, run CRUD on records, execute advanced queries, manage views, bulk insert records, and handle file attachments. Use the available tools to construct sequences that fetch, transform, and persist data in NocoDB.

How to install

Prerequisites you need before starting:

• Node.js installed on your machine (recommended LTS version) - npm comes with Node.js

Install the MCP server using one of the provided commands and start it in your environment.

Configuration examples and usage notes

{
  "mcpServers": {
    "nocodb": {
      "command": "npx",
      "args": ["@andrewlwn77/nocodb-mcp"],
      "env": {
        "NOCODB_BASE_URL": "http://localhost:8080",
        "NOCODB_API_TOKEN": "your_api_token_here"
      }
    }
  }
}

Additional best practices

• Use views to access subsets of data efficiently. - Use bulk_insert for large data loads. - Request only the fields you need to minimize payload. - Implement pagination (limit/offset) for large datasets.

Security and reliability notes

Protect your API token and base URL. Rotate tokens regularly and scope permissions to the minimum needed for each client or workflow. Monitor for rate limits and handle errors gracefully in your client.

Available tools

list_bases

List all available NocoDB bases/projects.

get_base_info

Fetch detailed information about a specific base.

list_tables

List all tables in a base.

get_table_info

Get the schema and columns for a table.

create_table

Create a new table with a custom schema.

delete_table

Remove a table from a base.

add_column

Add a new column to an existing table.

delete_column

Delete a column from a table.

insert_record

Insert a single record into a table.

bulk_insert

Insert multiple records at once.

get_record

Retrieve a specific record by ID.

list_records

List records with filtering and pagination.

update_record

Update an existing record.

delete_record

Delete a record.

search_records

Full-text search across records.

query

Advanced filtering with multiple conditions.

aggregate

Perform aggregate calculations (sum, count, avg, min, max).

group_by

Group records by a column.

list_views

List all views for a table.

create_view

Create a new view.

get_view_data

Get records from a specific view.

upload_attachment

Upload a local file to NocoDB storage.

upload_attachment_by_url

Upload files from URLs.

attach_file_to_record

Upload and attach a file to a record.

get_attachment_info

Get attachment information from a record.