NocoDB

---
name: NocoDB
description: Query, create, and manage NocoDB tables, records, and views — an open-source Airtable alternative via MCP
version: 1.0.0
author: chvor
type: tool
category: data
icon: table
tags:
  - nocodb
  - database
  - spreadsheet
  - airtable
  - no-code
  - mcp
  - tables
  - records
  - views
mcp:
  command: npx
  args: ["-y", "nocodb-mcp-server"]
  transport: stdio
  env:
    NOCODB_URL: "{{env.NOCODB_URL}}"
    NOCODB_BASE_ID: "{{env.NOCODB_BASE_ID}}"
    NOCODB_API_TOKEN: "{{credentials.nocodb}}"
requires:
  credentials:
    - nocodb
  env:
    - NOCODB_URL
    - NOCODB_BASE_ID
---
You have access to NocoDB database tools via MCP.

## Key NocoDB Concepts

- **Bases** — Top-level containers (like a database). Each base has its own tables and views.
- **Tables** — Structured data with typed columns (text, number, date, attachment, link, etc.)
- **Records** — Rows in a table, each with field values matching the table schema
- **Views** — Saved filters/sorts/groupings on a table (grid, gallery, kanban, form, calendar)

## Available MCP Tools

### Records
- **get_records** — List records from a table with optional filters and sorting
- **create_record** — Create a single record with field values
- **bulk_create_records** — Create multiple records at once
- **update_record** — Update fields on an existing record
- **delete_record** — Delete a record by ID

### Schema
- **add_column** — Add a new column to a table with a specified type
- **delete_column** — R