# NocoDB — how to use (mcp.ai)

Connect your NocoDB account and use 28 tools for databases straight from your AI agent. Connect with your own API key. Free & open source Airtable alternative. NocoDB turns any database into a smart spreadsheet with REST APIs.

## Option A — via MCP (recommended)
Remote MCP endpoint (HTTP, streamable): `https://api.mcp.ai/p_nocodb?ms=1787296020000`
Add it as a custom/remote MCP connector in your client (Claude, Cursor, VS Code…), then authenticate when prompted. Once connected, ask the agent to use the server's tools (e.g. `nocodb_auth_me`).

## Option B — via direct REST API
Base URL: `https://api.mcp.ai/api/nocodb`
Auth: `Authorization: Bearer sk_live_…` — create a workspace API key at https://mcp.ai/settings/api-keys
Discover endpoints: `GET https://api.mcp.ai/api/nocodb/_endpoints`

### Endpoints
- `POST https://api.mcp.ai/api/nocodb/auth/me` — Tool to get authenticated user information including email, name, roles, and profile details. Use when you need to verify user authentication or retrieve the current user's profile information.
- `POST https://api.mcp.ai/api/nocodb/auth/password/forgot` — Tool to initiate password reset process by sending a reset email to the user. Use when a user has forgotten their password and needs to receive a password reset link via email.
  - body: { email: string }
- `POST https://api.mcp.ai/api/nocodb/auth/signout` — Tool to sign out the authenticated user and clear their refresh token from the database and cookie. Use when you need to invalidate a user's authentication session and log them out of the NocoDB appli
- `POST https://api.mcp.ai/api/nocodb/db/table/sort/get` — Tool to retrieve sort configuration by ID from NocoDB. Use when you need to get details about how data is ordered in a specific view.
  - body: { sort_id: string }
- `POST https://api.mcp.ai/api/nocodb/db/view/column/update` — Tool to update a column configuration in a view. Use when you need to change column visibility, order, or width in a specific view.
  - body: { show?: boolean, order?: integer, width?: string, viewId: string, columnId: string }
- `POST https://api.mcp.ai/api/nocodb/db/view/delete` — Tool to delete a view from a NocoDB table. Use when you need to permanently remove a view. This action cannot be undone.
  - body: { viewId: string }
- `POST https://api.mcp.ai/api/nocodb/db/view/row/delete` — Tool to delete a specific row from a table view in NocoDB. Use when you need to remove a single record from a view.
  - body: { orgs?: string, rowId: string, baseName: string, viewName: string, tableName: string }
- `POST https://api.mcp.ai/api/nocodb/integration/store` — Tool to store configuration for a NocoDB integration. Use when you need to save or update integration settings like API keys, models, or other configuration parameters.
  - body: { config: object, integrationId: string }
- `POST https://api.mcp.ai/api/nocodb/integrations/info` — Tool to retrieve metadata for a specific NocoDB integration by type and subtype. Use when you need to get integration configuration schema, display information, or available capabilities for an integr
  - body: { type: string, subType: string }
- `POST https://api.mcp.ai/api/nocodb/integrations/list` — Tool to retrieve all available integrations in NocoDB. Use when you need to list all integrations including AI, authentication, sync, and workflow-node types.
- `POST https://api.mcp.ai/api/nocodb/list/workspaces` — Tool to list all workspaces accessible to the authenticated user. Use when you need to discover workspace_id before base operations, primarily relevant for NocoDB Cloud or multi-workspace deployments.
- `POST https://api.mcp.ai/api/nocodb/notification/delete` — Tool to delete a notification for the authenticated user. Use when you need to remove a notification. This performs a soft-delete operation.
  - body: { notificationId: string }
- `POST https://api.mcp.ai/api/nocodb/notification/list` — Tool to retrieve paginated notification records for the authenticated user. Use when you need to list notifications with optional filtering by read status and pagination support. Only returns notifica
  - body: { limit?: integer, isRead?: boolean, offset?: integer }
- `POST https://api.mcp.ai/api/nocodb/notification/poll` — Tool to poll for notifications using long-polling mechanism. Use when you need to check for new notifications for the authenticated user. The connection is maintained for up to 30 seconds; if no notif
- `POST https://api.mcp.ai/api/nocodb/plugin/status` — Tool to check if a NocoDB plugin is active or not. Use when you need to verify the operational status of a specific plugin by its identifier.
  - body: { pluginId: string }
- `POST https://api.mcp.ai/api/nocodb/public/grouped/data/list` — Tool to retrieve grouped data from a publicly shared NocoDB view. Use when you need to access grouped records from a public shared view without authentication.
  - body: { sort?: string, limit?: integer, where?: string, offset?: integer, columnId: string, sharedViewUuid: string }
- `POST https://api.mcp.ai/api/nocodb/storage/upload/by/url` — Tool to upload attachments from remote URLs to NocoDB storage. Use when you need to import files from external URLs or migrate attachments from other platforms like Airtable. The server fetches files 
  - body: { path?: string, attachments: object[] }
- `POST https://api.mcp.ai/api/nocodb/table/read` — Tool to retrieve complete schema information for a specific table. Use when you need to understand table structure, field definitions, or available views.
  - body: { base_id: string, table_id: string }
- `POST https://api.mcp.ai/api/nocodb/user/profile/update` — Tool to update authenticated user's profile information including display name, first name, and last name. Use when you need to modify the current user's profile details in NocoDB.
  - body: { lastname?: string, firstname?: string, display_name?: string }
- `POST https://api.mcp.ai/api/nocodb/utils/aggregated/meta/info` — Tool to get aggregated meta information such as tableCount, dbViewCount, viewCount and other statistics about the NocoDB instance. Use when you need an overview of the system's data structure and usag
- `POST https://api.mcp.ai/api/nocodb/utils/app/health` — Tool to get the NocoDB application health status. Use when you need to check if the application is running and responsive, typically for load balancers or monitoring systems.
- `POST https://api.mcp.ai/api/nocodb/utils/app/info` — Tool to get comprehensive NocoDB application information including authentication settings, version, limits, and deployment configuration. Use when you need to discover application capabilities, featu
- `POST https://api.mcp.ai/api/nocodb/utils/cloud/features` — Tool to get NocoDB Cloud features. Use when you need to retrieve available cloud-specific features and capabilities, including their availability status and highlight information.
- `POST https://api.mcp.ai/api/nocodb/utils/command/palette` — Tool to get dynamic command palette suggestions based on scope. Use when you need to retrieve available commands and actions for the NocoDB interface.
  - body: { query?: string, scope?: string }
- `POST https://api.mcp.ai/api/nocodb/utils/error/report` — Tool to report errors to NocoDB's error tracking system. Use when you need to submit error reports including error type, message, stack trace, and timestamp for monitoring and debugging purposes.
  - body: { error: string, stack?: string, message: string, timestamp?: string }
- `POST https://api.mcp.ai/api/nocodb/utils/feed` — Tool to get NocoDB product feed from social media sources including GitHub, YouTube, Twitter, and Cloud. Use when you need to retrieve social media updates and content from NocoDB's various channels. 
  - body: { page?: integer, type?: string, per_page?: integer }
- `POST https://api.mcp.ai/api/nocodb/utils/url/to/config` — Tool to convert JDBC URL or database connection URL to connection configuration object. Use when you need to parse and extract database connection parameters from a URL string for configuration purpos
  - body: { url: string }
- `POST https://api.mcp.ai/api/nocodb/workspace/base/list` — Tool to list all bases in a NocoDB workspace. Use when you need to retrieve bases associated with a specific workspace. Supports pagination via page and pageSize parameters.
  - body: { page?: integer, pageSize?: integer, workspaceId: string }

## Example prompts
- "What can I do in NocoDB?"
- "Show me a summary of my NocoDB account"

## More
- Page: https://mcp.ai/nocodb
- Agent spec (llms.txt): https://mcp.ai/nocodb/llms.txt
- Postman collection: https://mcp.ai/nocodb/postman.json