TokenFly

NocoDB

开源的无代码数据库平台，将 MySQL、PostgreSQL 等数据库转换为智能电子表格界面，被称为 Airtable 的开源替代方案

Developer services
https://www.nocodb.com/
Visit Website

In-depth Report

  • NocoDB is an open source no-code database platform, known as the "open source alternative to Airtable." It can convert relational databases such as MySQL, PostgreSQL, SQL Server, SQLite, etc. into an intuitive intelligent spreadsheet interface, allowing users to build and manage database applications without programming. With over 62,800 GitHub stars, Docker has been downloaded over 20 million times, and is trusted by over 35,000 organizations. Version 2025.08.0 was released in August 2025, adding important features such as real-time collaboration, dashboard chart widgets, and button-triggered scripts.

  • NocoDB is maintained by an active open source community and is officially positioned as "an open source alternative to Airtable." The company's official name is NocoDB, Inc. (© 2025). The GitHub repository has 62,800+ stars, 4,700+ branches, 328 contributors, and a health score of 65 (including 100 points for activity). Community links include Discord, official forums, Twitter, and Reddit. In August 2025, the team switched the license from AGPL 3.0 to a Fair-code-based Sustainable Use License to protect the long-term sustainability of the project.

  • NocoDB provides comprehensive code-free database management capabilities. The core view types include Grid View (data organization, sorting, filtering), Kanban View (workflow management), Gallery View (card visualization), Form View (simplifying data entry), Calendar View (calendar display) and Canvas View (real-time collaboration). Automation features support webhooks, workflows, and script triggering. Major updates in version 2025.08.0 include: real-time collaboration (Canvas Grid real-time synchronization without page refresh), four new dashboard widgets (bar chart, line chart, iFrame, Markdown text), button-triggered scripts (buttons run custom scripts directly), user management API (supports CRUD operations for workspace and base member management), and full-screen mode and Authorization Bearer token format support. In terms of integration capabilities, it supports connecting to MySQL, PostgreSQL, SQL Server, SQLite, CockroachDB and other databases, supports importing data from Airtable, CSV, Excel, and automatically generates RESTful API and Data APIs v3 (v2 will be deprecated soon). Paid plans also support Meta APIs v3.

  • NocoDB offers four pricing tiers, with a 20% discount on annual plans. Free plan $0, supports 3 users, 1,000 records, 1GB storage. Plus plan $12/seat/month with unlimited user seats, 50,000 records, 20GB storage, AI capabilities, 75,000 workflow runs/month. Business plan $24/seat/month with 300,000 records, 100GB storage, 10 external database connections, SAML SSO, SCIM integration. Enterprise plan starts at $1,000/month and includes unlimited logging and storage, 1TB of storage, on-premises deployment, and white label functionality. All paid plans only cost the first 9 people, after which users add for free.

  • Common feedback from GitHub and the technical community: open source, free and self-hosted, complete data control in the hands of the user, simple installation and deployment (one-click startup of Docker), intuitive and easy-to-use interface, support for millions of rows of data scale, and strong multi-database connection capabilities. Chinese communities (CSDN, Tencent Cloud, Zhihu) have widely reported on its Docker deployment tutorials and features. Negative feedback mainly focuses on the fact that advanced functions (audit logs, etc.) have been removed from the open source version, the learning curve is steep (complex functions require time to become familiar with), and the mobile experience needs to be optimized.

  • NocoDB is clearly positioned in the open source no-code/low-code space. Compared to Airtable, NocoDB’s annual cost for a team of 10 is only $228 (vs Airtable $2,400), a savings of 90%+. Compared to Supabase, NocoDB is more suitable for non-technical people, and the interface is closer to a spreadsheet. Compared to NocoBase, NocoDB focuses more on data management rather than building complex business applications. GitHub data shows that NocoDB ranks high among open source no-code tools for the number of stars and is one of the lowest-cost and most complete of the Airtable self-hosted alternatives.

  • 2025 License Change Stirs Community Concern - The team switched the license from AGPL 3.0 to a Sustainable Use License, citing reasons to protect the long-term sustainability of the project. Some advanced features, such as audit logs, have been removed from the open source version and are available on paid plans. In addition, TheHackerWire has disclosed that NocoDB has a SQL injection vulnerability (which has been fixed), and users are advised to always use the latest version.

  • NocoDB is suitable for technical teams that have existing database systems and need to quickly provide visual interfaces for business departments; individual developers or small teams to build lightweight database management applications; and business personnel who need to perform code-free operations on existing databases. It is not suitable for enterprise-level applications that need to build complex business workflows and approval processes (NocoBase is recommended), as well as users who have high security requirements for data and are unwilling to self-host.

  • NocoDB is currently the most mature open source Airtable alternative. It has established a solid position in the no-code database field with ultra-low cost of use, complete data control capabilities and active community support. The 2025 update to real-time collaboration and dashboard capabilities shows Teams is expanding into more complex collaboration scenarios. The commercial sustainability of the project is strengthened with the licensing changes and the introduction of a payment model. Recommended for teams that require lightweight database management tools.

User Reviews

  • 头像
    EvelynMurphy_2022
    —
    开源免费，用起来真香！而且功能一点都不缩水，该有的视图、API、权限控制全都有，对比之下 Airtable 免费版那 1200 行的限制真的太抠了。
  • 头像
    Bobby.Nelson
    —
    Docker 一键部署，太方便了。公司内部有运维同学维护 Docker 环境，部署 NocoDB 基本就是几分钟的事。而且更新也很方便，拉新镜像重启就行。
  • 头像
    DeFiSaver_Torres
    —
    NocoDB 自托管确实香，数据完全在自己手里，不用看 Airtable 的脸色。我拿它接了个 Postgres 库跑 CRM，运营同学直接上手，不用天天找我写 SQL 了。
  • 头像
    browngorilla353
    —
    比 Airtable 省太多钱了。
  • 头像
    KEdwards168
    —
    Docker 一行命令部署也太方便了吧，docker run 完直接开用。对于小团队来说这个上手速度无敌了。公司内部有运维同学维护 Docker 环境，部署 NocoDB 基本就是几分钟的事。而且更新也很方便，拉新镜像重启就行。
  • 头像
    Larry_Murphy_2021
    —
    试了下 NocoDB，数据量大到十万行以上明显变卡，前端渲染跟不太上。不过话说回来，对于中小规模的数据管理场景确实够用了，而且自托管没有行数限制，算是有得有失吧。
  • 头像
    春雨_15
    —
    自动生成 REST API 这个功能真香，建完表接口就有了，前端直接调，省掉了写后端 CRUD 的时间。
  • 头像
    Frank.Ruiz369
    —
    公式引擎确实不如 Airtable 强大，没有 ARRAYFORMULA，日期计算也比较基础。不过对于大部分业务场景来说够用了，真要搞复杂计算可以在数据库层面写视图或触发器来解决。
  • 头像
    程敏琳
    —
    给运营搭了个库存管理系统，以前他们查库存要找开发写 SQL，现在自己在 NocoDB 上拖拖拽拽就行了。我清闲了不少。API 文档自动生成省了很多沟通成本，前端和后端不用反复确认接口格式，直接用 Swagger UI 就能测试和调试。
  • 头像
    YItay_x
    —
    试了好几个 Airtable 的开源替代，NocoDB 的连接已有数据库这个能力确实是独一档的。Baserow 体验更接近 Airtable 但没法直接连现有库，NocoDB 这个方向选对了。
  • 头像
    DeFiLi_nk
    —
    NocoDB + n8n 的搭配简直绝了，NocoDB 处理数据展示和录入，n8n 搞定复杂工作流，组合起来比 Airtable 还灵活。
  • 头像
    8w8uo
    —
    部署到公司的内网服务器上，财务那边用了两周说挺好的，终于不用在 Excel 里传来传去了。安全合规也达标了。公司内部有运维同学维护 Docker 环境，部署 NocoDB 基本就是几分钟的事。而且更新也很方便，拉新镜像重启就行。
  • 头像
    purplezebra414
    —
    UI 确实没 Airtable 精致，小细节上有一些粗糙的地方。但开源嘛，能接受，毕竟省下来的钱够买几台服务器了。
  • 头像
    JamesWatson
    —
    看板视图做项目管理还挺顺手的，把任务按状态分组，拖拽更新，团队协作没有任何学习成本。
  • 头像
    JEbel
    —
    GraphQL API 直接生成这点很赞，前端可以按需取数据，不用像 REST 那样搞一堆定制 endpoint。对于前后端分离的项目来说，这相当于白送了一套完整的 BFF 层。
  • 头像
    MPowellSr
    —
    我比较关心数据隐私，所以 NocoDB 自托管对我来说是刚需。数据全在自家 PostgreSQL 里，想怎么备份都行。
  • 头像
    MichaelMorales59
    —
    说实话文档确实有点拉胯，有些高级功能只能去 GitHub Issues 里翻或者读源码才能搞清楚怎么用。希望官方能在文档上多花点精力，不然很多用户试两下就劝退了。
  • 头像
    MsSteveCastro_2024
    —
    拿来做了个简单的客户管理系统，建表、设字段、配置权限一步到位，前后不到一小时就搭完了，效率远超预期。不同角色看到的字段和数据范围都不一样，这个灵活度对于有多部门协作需求的企业来说非常实用，不用像以前那样搞多个表格了。
  • 头像
    brownostrich444
    —
    之前用 Airtable 免费版限制 1200 行真心难受，换了 NocoDB 自托管，想存多少存多少，年费直接省了。
  • 头像
    JHernandez_99
    —
    自动化功能比较基础，只有 webhook，没有 Airtable 那种 trigger-action 的工作流编辑器。需要用 n8n 或者 Make 来补。
  • 头像
    MargaretKrauss
    —
    表单视图做数据收集很方便，配置好字段生成链接发出去，回复自动汇总到表格，运营同事都说好。配置好之后生成一个链接发给客户或同事，填写的内容自动汇总到后台表格里，不需要额外的开发工作，运营团队自己就能搞定数据收集流程。
  • 头像
    孔彤_1
    —
    连接已有数据库这个思路真的绝了，不用迁移数据，直接给旧系统套个新 UI，零迁移成本。不过对于开源项目来说已经很不错了，社区版的功能覆盖了大部分核心需求，团队协作也够用。毕竟 Airtable 也是经过这么多年迭代才有今天的体验的。
  • 头像
    KennethRobinson168870
    —
    跟 Airtable 比差距还是有的，尤其是集成生态差太多。Airtable 有上千个集成插件，NocoDB 才几十个。
  • 头像
    BrandonStephens
    —
    画廊视图展示图片类数据很好看，用来做产品目录管理挺合适的，视觉效果不错。产品图片搭配文字描述一目了然，客户选品的时候可以直接在画廊视图里浏览，比传统的表格视图直观多了，销售团队反馈很好。
  • 头像
    BBaker_882
    —
    权限控制做得挺细的，可以精确到表和列级别。财务数据只有财务组能看到，销售只能看客户信息，合规性没问题。
  • 头像
    烟雨_9
    —
    公司的老系统数据库是 MySQL 的，之前运营想看数据都得找开发写查询。上了 NocoDB 之后他们自己就能查了，我这边工单少了一堆。API 文档自动生成省了很多沟通成本，前端和后端不用反复确认接口格式，直接用 Swagger UI 就能测试和调试。
  • 头像
    金梅
    —
    试了一下直接用 SQLite 跑，数据量小的时候还行，生产环境强烈建议上 PostgreSQL。
  • 头像
    cudvb4y3w
    —
    百万条数据排序过滤挺丝滑的，比我预想的好多了。之前看评测说十万行以上会卡，实际体验还好，可能新版优化过了。
  • 头像
    JacobLopez_Max924
    —
    之前团队用 Airtable 一年下来账单两千多刀，记录数超了还得升套餐。换了 NocoDB 自托管后零软件成本，就花了个服务器钱，一年省下来的够团队出去团建好几趟了。
  • 头像
    MOhil
    —
    开发体验挺好的，API 文档清晰，Swagger 直接集成，测试起来很方便。做二次开发也比较顺手。API 文档自动生成省了很多沟通成本，前端和后端不用反复确认接口格式，直接用 Swagger UI 就能测试和调试。

Similar Products