# NocoDB

> NocoDB is a no-code database platform that turns any PostgreSQL or MySQL database into a collaborative spreadsheet-like interface, enabling teams to build and manage data without writing code.

NocoDB is a no-code database platform that allows teams to collaborate and build processes with the ease of a familiar spreadsheet interface. It connects to existing PostgreSQL or MySQL databases—or provides its own hosted database—and exposes data through multiple interactive views including Grid, Kanban, Gallery, Form, Calendar, Timeline, and Map. Designed for both technical and non-technical users, NocoDB scales to millions of rows and provides high API throughput without requiring enterprise-level contracts.

- **Multiple View Types**: *Switch between Grid, Kanban, Gallery, Form, Calendar, Timeline, List, and Map views to visualize data in the format that best fits your workflow.*
- **External Database Connectivity**: *Connect directly to PostgreSQL, MySQL, SQL Server, and other external databases to use NocoDB as a no-code front-end for your existing data.*
- **Rich Field Types**: *Access 30+ field types including text, number, date/time, select, attachment, formula, links, lookup, rollup, and more.*
- **Automation & Webhooks**: *Build visual workflows with triggers, conditions, and actions; set up event-driven webhooks on record create, update, and delete events.*
- **Scripts & Dashboards**: *Write JavaScript-based automation scripts with full API access, and build visual dashboards with bar, line, pie, and donut chart widgets.*
- **NocoAI**: *Use AI-assisted generators for bases, tables, fields, views, filters, formulas, and select options—all from natural language prompts.*
- **NocoDocs**: *Built-in document editor with rich text formatting, comments, AI assistant, and granular permissions living alongside your data.*
- **NocoSync**: *Sync data from GitHub, GitLab, Bitbucket, and Linear directly into your NocoDB bases.*
- **REST API & MCP Server**: *Access all data programmatically via REST APIs with Swagger documentation, or connect NocoDB to AI agents via the Model Context Protocol (MCP) server.*
- **Role-Based Access Control**: *Fine-grained permissions at workspace, base, table, field, and record levels, with SSO, SCIM, and 2FA available on higher-tier plans.*
- **Import & Migration**: *Import data from Airtable, CSV, Excel, and JSON, or connect directly to external databases for seamless migration.*
- **Self-Hosting**: *Deploy NocoDB on your own infrastructure via Docker for full data sovereignty; fair-source code is publicly available on GitHub.*

## Features
- Grid, Kanban, Gallery, Form, Calendar, Timeline, List, and Map views
- Connect external PostgreSQL and MySQL databases
- 30+ field types including formula, lookup, rollup, and attachments
- Visual workflow builder with triggers, actions, conditions, and loops
- JavaScript-based scripting with full API access
- Event-driven webhooks with conditional triggers and custom payloads
- NocoAI: AI-assisted base, field, view, filter, and formula generation
- NocoDocs: built-in document editor with rich text and AI assistant
- NocoSync: sync from GitHub, GitLab, Bitbucket, and Linear
- REST API with Swagger/OpenAPI documentation and code snippets
- MCP Server for AI agent integration
- Role-based access control at workspace, base, table, field, and record levels
- SSO (SAML), SCIM, and 2FA on higher-tier plans
- Import from Airtable, CSV, Excel, and JSON
- ERD diagram view for schema visualization
- Dashboards with bar, line, pie, and donut chart widgets
- Extensions: Bulk Update, Data Exporter, Dedupe, Org Chart, Page Designer, URL Preview
- Row and cell conditional coloring
- Password-protected shared views
- Mobile-responsive interface

## Integrations
PostgreSQL, MySQL, SQL Server, Airtable, GitHub, GitLab, Bitbucket, Linear, Google Calendar, Slack, Gmail, Outlook, Twilio, HubSpot, Stripe, Google Pay, Apple Pay

## Platforms
LINUX, WEB, API, CLI

## Pricing
Freemium — Free tier available with paid upgrades

## Links
- Website: https://nocodb.com
- Documentation: https://docs.nocodb.com/
- Repository: https://github.com/nocodb/nocodb
- EveryDev.ai: https://www.everydev.ai/tools/nocodb