Logo
Deploy Now

Stars

63877

Forks

4903

Watchers

389

Developer links

NocoDB

Any existing relational database becomes a collaborative, Airtable-style smart spreadsheet under NocoDB. It connects to PostgreSQL, MySQL, MariaDB, SQL Server, or SQLite, introspects the schema - tables, relationships, indexes - and renders it as interactive Grid, Gallery, Kanban, Calendar, and Form views without migrating a single row. Your business data stays in your database; NocoDB keeps only its own metadata (view configs, permissions, webhooks) in a separate store. Every connected table automatically gets REST APIs with Swagger documentation, effectively turning legacy databases into modern backends. The spreadsheet layer adds 20+ field types including formulas, lookups, rollups, links, attachments, and currency, plus sorting, filtering, grouping, and multi-field editing. Views can be locked or shared publicly with password protection, role-based access control scopes permissions per user, and webhooks plus CSV, Excel, and Airtable import round out integration. An ERD view visualizes the schema. Built with Node.js and Vue, deployed via Docker, handling millions of rows.

NocoDB
NocoDB
NocoDB

Benefits

  • No Migration, No Lock-In
  • Point NocoDB at the database you already run - even a production replica - and business teams get a spreadsheet UI immediately. Leaving is trivial because the data was always just SQL.
  • Unlimited Records and API Calls
  • Airtable caps Pro bases around 50K records and throttles the API at 5 requests per second. NocoDB's limits are your hardware; customers routinely work with millions of rows.
  • Instant Admin Panels and Backends
  • Auto-generated REST APIs with Swagger docs turn any legacy table into a modern backend, and the UI doubles as an admin panel without writing CRUD code.
  • Spreadsheet Access, Database Power
  • Non-technical staff edit data in a familiar grid while the underlying store keeps real column types, indexes, and relationships that BI and application code depend on.

Features

  • Five View Types
  • Grid, Gallery, Form, Kanban, and Calendar views over the same tables, with per-view filters, sorting, grouping, and hidden fields.
  • Rich Field Types
  • Formulas, lookups, rollups, links between tables, attachments, currency, user fields, and validation rules layered onto native SQL columns.
  • Auto-Generated APIs
  • REST endpoints with Swagger documentation for every table the moment a database is connected.
  • Access Control and Sharing
  • Fine-grained role-based permissions, collaborative or locked views, and public or password-protected shared bases.
  • Import, Export, and Webhooks
  • Migrate from Airtable, CSV, or Excel, export back out freely, and trigger webhooks on record events for automation.
  • Schema Tools
  • ERD visualization of table relationships and multi-field editing to restructure tables in one pass.