NocoDB
FreeTurn any database (MySQL, Postgres, SQLite) into a smart spreadsheet UI. The open-source Airtable alternative that works with your existing data infrastructure.
How to install NocoDB as a PWA
Frequently asked questions about NocoDB
What makes NocoDB different from Baserow or Airtable?
NocoDB connects to your existing relational database — it does not own the data. You point it at a Postgres instance and it reflects every table as a NocoDB view, including data that other apps are writing to. Baserow and Airtable own their data in their own Postgres/proprietary store. This makes NocoDB the right choice when you need a no-code UI on top of a production app database, and Baserow the right choice when you are building a brand-new database from scratch.
Is NocoDB free?
NocoDB's AGPL-3.0 core is free to self-host with no row or user limits. Self-hosting on Docker takes about 5 minutes on any $5 VPS. The hosted nocodb.com cloud has a free tier with limits and paid tiers starting around $10/user/month. Enterprise plans add SSO, audit logs and dedicated support. The AGPL license means SaaS resellers must open-source their modifications, which is a common reason large companies pick enterprise licensing.
How does NocoDB compare to Retool or Appsmith?
Retool and Appsmith are internal-tool builders — you compose UIs from drag-drop widgets and write SQL/JS. NocoDB is a database-first UI: it gives you tables, views and forms without writing any UI code. For 'I need a spreadsheet on top of my Postgres', NocoDB is faster. For 'I need a custom admin dashboard with charts and approval workflows', Retool or Appsmith are stronger. Many teams use both: NocoDB for data ops, Retool for custom dashboards.
Can NocoDB run offline?
The PWA shell installs offline but NocoDB depends on a live database connection for all operations. For offline-tolerant scenarios, host NocoDB on a local server alongside the database — useful in retail, field-ops and air-gapped industrial environments where everything sits on a LAN.
Is NocoDB safe for production database access?
NocoDB respects database-level permissions when you connect with a least-privilege user. For production, use a read-only or schema-scoped Postgres role for read-heavy dashboards, and a write role only for tables that should be edited via NocoDB. The enterprise edition adds row-level and column-level access controls. Always run NocoDB behind a VPN or SSO for any non-public deployment.
Where NocoDB is heading (12-24 months)
- →Tighter AI integration (natural-language query to SQL) is on the public roadmap.
- →First-class real-time sync (currently polling-based) would make multi-user editing feel as live as Airtable.
- →Native mobile apps remain a gap — the PWA is acceptable but not at Airtable mobile parity.
Related questions
ChatGPT, Perplexity and Gemini usually suggest these next.
- How do I connect NocoDB to a production Postgres database safely?
- Does NocoDB support row-level permissions?
- Can NocoDB generate a public form for collecting submissions?
- How does NocoDB perform on tables with 1M+ rows?
- How do I migrate from Airtable to NocoDB?
More in Productivity
End-to-end encrypted office suite — docs, spreadsheets, kanban, code pads. No account needed for guest use. Hosted in France, GDPR-native. The privacy-first Google Docs alternative.
Open-source office suite with pixel-perfect DOCX/XLSX/PPTX compatibility. Self-hostable or cloud. The best free replacement for Google Docs when you need perfect Microsoft format support.
Open-source spreadsheet-database hybrid — like Airtable but self-hostable and free. Build relational tables with formulas, linked records, and custom views without monthly fees.
Local-first Notion alternative that stores notes as plain Markdown files directly on your disk. No cloud sync required. Your notes are yours forever — open in any editor.
AI-powered workspace for tasks, mind maps, and real-time collaboration. Installs as a PWA with full offline support. Combines the best of Notion, Trello, and a task manager.
Open-source project management for agile teams. Scrum, Kanban, and issues — free forever, self-hostable. The Jira/Trello alternative that respects your data.