NocoDB
Free & open source Airtable alternative. NocoDB turns any database into a smart spreadsheet with REST APIs.
Verdict
Common use cases
- Pull customer records into chat for support triage
- Audit table schemas and view counts across bases
- Create rows in project tracker from Slack threads
- Delete stale views after sprint retrospectives
- Check database health before deploying updates
Integration
- Vendor
- NocoDB
- Category
- other
- Auth
- API_KEY
- Tools
- 27
- Composio slug
nocodb
Tools
- Convert URL to Database 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 purposes.
- Delete Notificationdestructive
Tool to delete a notification for the authenticated user. Use when you need to remove a notification. This performs a soft-delete operation.
- Delete Table View Rowdestructive
Tool to delete a specific row from a table view in NocoDB. Use when you need to remove a single record from a view.
- Delete Viewdestructive
Tool to delete a view from a NocoDB table. Use when you need to permanently remove a view. This action cannot be undone.
- Forgot Password
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.
- Get 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 usage metrics.
- Get Application Health Status
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.
- Get Application Info
Tool to get comprehensive NocoDB application information including authentication settings, version, limits, and deployment configuration. Use when you need to discover application capabilities, feature flags, or system configuration.
- Get 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.
- Get Command Palette Suggestions
Tool to get dynamic command palette suggestions based on scope. Use when you need to retrieve available commands and actions for the NocoDB interface.
- Get Integration 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 integration.
- Get 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.
- Get Product 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. Supports filtering by feed source and pa
- Get Sort Metadata
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.
- Get Table Schema
Tool to retrieve complete schema information for a specific table. Use when you need to understand table structure, field definitions, or available views.
- Get User Info
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.
- List Integrations
Tool to retrieve all available integrations in NocoDB. Use when you need to list all integrations including AI, authentication, sync, and workflow-node types.
- List Notifications
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 notifications that haven't been soft-deleted.
- List Public Shared View Grouped Data
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.
- List Workspace Bases
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.
- Poll Notifications
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 notification arrives, returns status 'refresh
- Report Error
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.
- Sign Out User
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 application.
- Store Integration Configuration
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.
- Update User Profile
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.
- Update View Column
Tool to update a column configuration in a view. Use when you need to change column visibility, order, or width in a specific view.
- Upload Attachments 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 from provided URLs and stores them in co
Setup
Setup guide
- 11. In Switchy, navigate to Settings → Integrations and select NocoDB from the MCP catalog. 2. Log into your NocoDB instance, go to Account Settings → Tokens, and generate a new API token with read and write permissions for the bases you want to access. 3. Copy the token and paste it into Switchy's API Key field, then enter your NocoDB instance URL (e.g. https://app.nocodb.com or your self-hosted domain). 4. Click Connect and wait for Switchy to verify the credentials. 5. Open any Space, type '@NocoDB get application info' and send — if you see version and auth details in the response, the connection is live. 6. To invoke a tool, @mention NocoDB followed by a natural-language request like 'show me the first 10 rows from the Customers table' or 'delete view ID 42 from the Sales base'.
What teammates see: by default, memories from NocoDB are scoped to the Space (PROJECT visibility) - you can mark any memory PRIVATE or share it ORG-wide.
Works well with
Top models
Compatibility data appears once enough Spaces have used this MCP together with a given model.
How Switchy teams use it
Starter prompts
List All Tables
@NocoDB get aggregated meta info for base ID prod_crm and show me table names with their row countsOpen in a Space →
Fetch Recent Rows
@NocoDB show me the 20 most recent rows from the Support Tickets view in base ID support_2024Open in a Space →
Create New Record
@NocoDB create a new row in the Leads table with name 'Acme Corp', email 'contact@acme.com', and status 'New'Open in a Space →
Delete Outdated View
@NocoDB delete view ID 87 from the Q4 Planning base and confirm it's goneOpen in a Space →
Check System Health
@NocoDB get application health status and tell me if all services are operationalOpen in a Space →
Example outputs
Illustrative - representative of the model's voice and quality, not literal recordings.
@NocoDB show me all records in the 'customer_orders' table where status is 'pending' and created in the last 7 days
Found 23 pending orders from the past week in your customer_orders table. The results include order IDs, customer names, order totals ranging from $45 to $890, and creation timestamps. The most recent order (#10847) was placed 2 hours ago by Sarah Chen for $156.50. All records show 'pending' status and are awaiting fulfillment team review.
This read-heavy example demonstrates NocoDB's filtering and querying capabilities across your database tables. Requires API key with read permissions on the target table. Response structure depends on your table schema — column names and data types will vary by your NocoDB base configuration.
@NocoDB create a new row in 'project_tasks' with title 'Q2 Budget Review', assigned to 'finance-team', due date March 31, and priority 'high'
Successfully created task record in your project_tasks table. New row ID: rec_8x3mK9pL with the following values: Title set to 'Q2 Budget Review', Assigned field linked to 'finance-team', Due Date set to 2025-03-31, Priority marked as 'high'. The record is now visible in all views that include these columns.
This write example shows row creation with multiple field types (text, linked record, date, single-select). Side-effect: the new row immediately appears in your NocoDB base and any connected automations or webhooks will trigger. Ensure your API key has write permissions and field names match your exact schema (case-sensitive).
@NocoDB get aggregated stats for our base, then summarize which tables have the most activity and suggest where we should add views for better team visibility
Your NocoDB instance contains 12 tables with 847 total records across 28 views. The 'customer_orders' table has the highest record count (312 rows) and 'support_tickets' shows the most views (7 different perspectives). Based on this distribution, consider adding filtered views to 'customer_orders' grouped by status and region — this would help sales teams track pipeline without manual filtering. The 'project_tasks' table has only 1 default view despite 156 records, suggesting an opportunity for priority-based or assignee-based views.
This synthesis example pairs NocoDB's meta-info tool with AI reasoning to provide strategic recommendations. The aggregated stats are real-time snapshots — counts reflect your current base state. Useful for database governance and identifying underutilized tables, but recommendations depend on the AI understanding your team's workflow context.
Use-case deep-dives
When NocoDB replaces your Airtable-to-Slack glue code
A 6-person support team runs their ticket queue in NocoDB because it's cheaper than Airtable and they already host Postgres. They want Switchy to pull open tickets during standup and mark them resolved after the call. The NocoDB MCP handles this cleanly: the Delete Table View Row and Get Aggregated Meta Info tools let you read filtered views and update records without writing custom SQL. The API_KEY auth means one shared credential for the whole team. The trade-off: if you're already paying for Airtable or Notion and your data lives there, adding NocoDB just for AI access is overkill. But if you're self-hosting a database and need a no-code layer that Switchy can talk to, this MCP is the fastest path from 'we have data' to 'AI can act on it'.
NocoDB wins when your roadmap lives in a self-hosted database
A 10-person product team tracks feature requests in a NocoDB base connected to their own Postgres instance. Each Friday, they ask Switchy to summarize the top-voted requests and flag any that crossed the 20-vote threshold this week. The MCP's 27 tools include view management and row operations, so Switchy can read the voting table, filter by date, and even delete spam entries without the PM opening the UI. The catch: NocoDB's strength is giving you a spreadsheet interface over your own database. If your roadmap is already in Linear or Productboard, this MCP doesn't bridge that gap—you'd use their native MCPs instead. Choose NocoDB when you want full control of the data layer and need AI to interact with it through a structured API.
When you need a lightweight database AI can write to
A 3-person agency onboards freelancers through a NocoDB checklist: contracts signed, Slack invited, tools provisioned. They ask Switchy to check off steps as they happen and ping the founder when a contractor is 100% ready. The Delete View and Get Application Health Status tools let Switchy treat NocoDB like a simple task database—no Zapier, no webhooks, just direct writes. The boundary: if your onboarding flow has 15+ steps and needs conditional logic, you'll outgrow NocoDB's flat-table model fast. But for teams under 20 people who want a self-hosted checklist that AI can update in real time, this MCP delivers without the Airtable subscription or the complexity of a custom backend.
Frequently asked
What does the NocoDB MCP let me do in Switchy?
It connects your NocoDB bases so your team can query tables, create and delete views, manage rows, and pull aggregated metadata — all through natural language in Switchy. You can ask questions like 'show me the last 10 customer records' or 'delete this view' without opening NocoDB's interface. It's useful for teams that store structured data in NocoDB and want faster, conversational access to it.
Do I need admin access to connect NocoDB?
You need an API key with sufficient permissions for the bases and tables your team wants to access. NocoDB uses API_KEY authentication, so you'll generate a token in your NocoDB account settings and paste it into Switchy during setup. If your key only has read access, the MCP won't be able to delete rows or views. Check your NocoDB role before connecting.
Can the NocoDB MCP create new tables or bases?
No. The 27 available tools focus on reading data, managing views, and modifying rows within existing tables. You can delete views and rows, convert database URLs to config objects, and pull health status, but you can't scaffold new tables or bases. For schema changes, you still need to use NocoDB's web UI or API directly.
How is this different from just using NocoDB's API?
The MCP wraps NocoDB's REST API so your team can interact with it conversationally in Switchy, without writing code or remembering endpoint syntax. Instead of crafting a DELETE request to remove a row, you type 'delete the record with ID 42'. It's faster for ad-hoc queries and one-off tasks, but if you're building automation, you'd still use the API directly.
Who on my team should connect the NocoDB MCP?
Whoever owns the API key. Since NocoDB uses token-based auth, the connection inherits the permissions of that key. If your team shares a service account key with broad access, anyone in the Switchy workspace can use the MCP. If you want to limit scope, create a dedicated key with read-only or table-specific permissions before connecting.