What is NocoDB?
NocoDB puts a spreadsheet interface, forms, kanban boards, dashboards and workflows on top of a database, with a REST API and an MCP server for each project. It can run on SQLite or Postgres and connect to external Postgres and MySQL databases.
Its AI features come in two kinds. NocoAI is an assistant inside the app that builds tables, fields, views, dashboards and workflows from plain English, answers questions about your records and updates them in bulk. The MCP server works the other way round, letting Claude, ChatGPT, Cursor, Codex and other MCP clients read and edit your data; since release 2026.09.0 it exposes 149 tools on NocoDB Cloud and licensed self-hosted installs.
On 9 January 2026 NocoDB moved from the AGPL-3.0 to the Sustainable Use License, a fair-code licence that permits internal business and personal use but not offering NocoDB to others as a commercial service. The free self-hosted Community edition gets the MCP record tools but not NocoAI.
Is NocoDB worth it?
NocoDB's pitch to AI builders is that your agent can work on a real database through a familiar spreadsheet. Its MCP server grew from 11 tools to 149 in release 2026.09.0, covering records, tables, views, workflows, dashboards and permissions, and every call goes through the same permission checks as the REST API. NocoAI, the built-in assistant, can create up to 20 related tables in one step and asks for approval before it deletes anything or changes permissions. With 65,549 GitHub stars and release 2026.10.1 on 29 October 2026, the project is busy.
The free self-hosted edition gets far less of that. Community has no NocoAI, and its MCP server offers only the record tools, connected by URL and token rather than OAuth. To use AI on your own server you need the Business plan at $24 per seat a month (billed annually) and your own key for OpenAI, Anthropic, Google or a compatible API. On NocoDB Cloud, NocoAI starts at Plus and draws on monthly credits whose amounts the pricing page does not state.
The licence is the bigger question. The January 2026 move to the Sustainable Use License, the same fair-code licence n8n uses, means NocoDB is no longer open source by the OSI definition: running it inside your company is fine, but reselling it as a hosted service needs a commercial licence. NocoBase, its closest rival, also uses a restricted licence.
Security deserves attention before you put it on the internet. On 2 November 2026 the project published seven advisories at once, three rated high: SQL injection through the formula parser, route role restrictions that were not enforced, and server-side JavaScript execution through webhook templates. A NocoDB instance holds your data, database credentials and, on paid plans, your AI provider keys.
Where it earns its place
An operations lead at a 30-person logistics firm
Let staff ask Claude about shipment records without giving it raw database access
Self-host Community and connect Claude through an MCP connection URL and token scoped to one project. The record tools let it query and update rows under the token's permissions, at no licence cost.
A solo consultant building client trackers
Describe a CRM in a sentence and get the tables, links and views
On NocoDB Cloud Plus at $12 per seat a month (annual), NocoAI generates the project and suggests fields and filters. Credits are included monthly; the amount is not published.
A data team at a regulated company
Add AI-filled fields to an internal Postgres database while keeping data in-house
Self-hosted Business connects one AI provider of your choice, including any compatible API, with your own key and billing. Air-gapped installation is an Enterprise add-on.
Before you commit
- Setup
- One docker run with SQLite, or the auto-upstall script, which installs Postgres, Redis and Traefik with SSL. The docs suggest 2 vCPU and 2 GB RAM minimum, 4 vCPU and 8 GB for production. Prebuilt binaries are no longer published.
- Integrations
- REST API and MCP server per project; MCP guides for Claude, ChatGPT, Codex, Cursor, Windsurf, GitHub Copilot and Antigravity; external Postgres and MySQL connections; AI providers OpenAI, Anthropic, Google or any compatible API on paid plans.
- Data and privacy
- Self-hosted data stays on your server; the instance stores database credentials and, on paid plans, AI provider keys. Cloud NocoAI runs on monthly credits, and the docs we read do not name the model providers behind it. Licence: Sustainable Use License.
- Cost at scale
- Self-hosted Business costs $24 per seat a month annually and Scale $45, listed with a three-seat minimum; a 20-seat team on Business pays $5,760 a year. Cloud adds record, storage and API-call caps per plan.
- Limits
- Cloud Free allows 1,000 records and 1,000 API calls a month; Plus 50,000 records. Community is limited to 2 workflows per base and 2 interfaces per workspace, and its MCP server has record tools only.
What’s good
- MCP server with 149 tools lets AI clients build and edit, not just read
- NocoAI asks for approval before destructive or permission changes
- Community edition has unlimited records, seats and storage
- One-command install sets up Postgres, Redis, Traefik and SSL
What’s not
- No longer open source: Sustainable Use License since January 2026
- No NocoAI on the free self-hosted edition; bring-your-own-key AI starts at $24 per seat
- Seven security advisories on 2 November 2026, three of them high severity
- Pricing page contradicts itself on Plus prices and Scale seat minimums
Best for
Internal teams that want a self-hosted, spreadsheet-style database their AI assistants can query and edit, and who accept a fair-code licence.
NocoDB alternatives
NocoDB: common questions
- Is NocoDB worth it?
- A capable Airtable replacement that AI agents can now drive, let down by a licence change, a cluster of serious security fixes and AI that the free self-hosted edition does not get. We rate it 3.6 out of 5.
- How much does NocoDB cost?
- Self-hosted Community free (2 workflows per base, 2 interfaces per workspace, no NocoAI); self-hosted Business $24/seat/month annual ($30 monthly), Scale $45/seat/month annual ($54 monthly), Enterprise custom. Cloud Free for 3 editors and 1,000 records; Plus $12/seat/month annual ($15 monthly).
- What are the downsides of NocoDB?
- No longer open source: Sustainable Use License since January 2026; no NocoAI on the free self-hosted edition; bring-your-own-key AI starts at $24 per seat; seven security advisories on 2 November 2026, three of them high severity; pricing page contradicts itself on Plus prices and Scale seat minimums.
- Who is NocoDB best for?
- Internal teams that want a self-hosted, spreadsheet-style database their AI assistants can query and edit, and who accept a fair-code licence.
- How much does NocoDB cost for a team or in production?
- Self-hosted Business costs $24 per seat a month annually and Scale $45, listed with a three-seat minimum; a 20-seat team on Business pays $5,760 a year. Cloud adds record, storage and API-call caps per plan.
- Is NocoDB safe for company data?
- Self-hosted data stays on your server; the instance stores database credentials and, on paid plans, AI provider keys. Cloud NocoAI runs on monthly credits, and the docs we read do not name the model providers behind it. Licence: Sustainable Use License.
- What are the best NocoDB alternatives?
- The closest alternatives we have reviewed are NocoBase and n8n.
Answers checked Nov 16, 2026.