档案库 · 开发与企业工具 · 产品决策 · 2023–2026
Mathesar押注开源和真Postgres能击败SaaS数据工具
Mathesar基金会发布了一款自托管的电子表格风格界面，可直接编辑Postgres；其2023年Show HN获得281分，仓库显示5.1k星。
Mathesar基金会
做的是什么生意
Mathesar is a free, self-hosted web application that gives PostgreSQL a spreadsheet-like interface: users of any skill level can view, edit, query and collaborate on real Postgres schemas and tables with no code, using native Postgres roles and privileges for access control. It is GPLv3 open source, maintained by the Mathesar Foundation, a 501(c)(3) nonprofit, which also operates Mathesar Cloud (early beta, free plan).
起因
Mathesar's pitch, from its README and about page, is that working with data should not require technical expertise or expensive, closed-off tools: databases are powerful but 'often trapped behind complex interfaces'. The project is 100% open source under GPLv3 and maintained by Mathesar Foundation, a 501(c)(3) nonprofit whose core team includes veterans of communities like Creative Commons and WordPress; the repository lived under the centerofci GitHub org at launch and now sits under mathesar-foundation. On 2023-03-02 maintainer kgodey posted the Show HN, writing in-thread that 'I was pretty surprised that nothing like Mathesar existed already' — unlike desktop tools such as Sequel Pro or TablePlus, it is a collaborative web app that also works without an existing database.
经过
The discussion shows the bet being worked out in public: a commenter called it 'the first free, user-friendly interface for Postgres'; core maintainer seancolsen explained Mathesar takes inspiration from Airtable but deliberately avoids the 'Open Source Airtable alternative' label because it stays truer to relational data — thin abstractions over real foreign keys, normalized data, and a graphical Data Explorer for joins across tables. Maintainers described an eight-person team and a demo server that spun up a fresh Postgres template database per session; when front-page traffic overwhelmed it, they added a load balancer mid-thread. By the 2026-09-05 snapshot the repo showed 5.1k stars, 486 forks and 19,134 commits, the README declared public beta, and Mathesar Cloud (early beta, free plan) offered a hosted route.
结果
Still live and open as of the 2026-09-05 snapshot: the project is in public beta under Mathesar Foundation, lists 100+ contributors on its about page, and discloses no shutdown, acquisition, funding or pivot.
背景
Mathesar是一款免费、自托管的Web应用，为PostgreSQL提供电子表格样界面：任何技能水平的人都能无代码查看、编辑、查询和协作处理真实模式和表，而访问控制保留在原生Postgres角色和权限中。该项目在GPLv3下100%开源，由Mathesar基金会（一家501(c)(3)非营利组织）维护，并拥有Mathesar Cloud（早期测试版，免费计划）作为托管选项。
该押注是用户将通过薄电子表格层使用Postgres，而非Airtable式SaaS或仅SQL工具，并且开源、非营利组织拥有的工具是值得信赖的。维护者刻意避免“开源Airtable替代品”标签，因为他们更忠实于关系数据：一对多关系是真实外键列，可可视化Data Explorer处理连接。项目于2023-03-02通过Show HN公开，该帖子获得281分和74条评论，其现场演示服务器在前页流量下中途不得不扩容。
到2026-09-05快照时，仓库显示5.1k星、486个fork和19,134次提交；README声明公开测试版，关于页面统计100+贡献者。未披露资金、收入或关闭；项目与启动时相同的开放核心加云结构依然活跃。
这件事要成立，得有什么
- 因为Mathesar指向现有Postgres数据库，团队无需迁移数据或放弃已在生产运行的数据库即可评估。
- 真实外键、模式和Postgres角色保持模型真实：UI像数据库一样表现，而非假装关系不存在的电子表格。
- GPLv3非营利项目解决了封闭SaaS对敏感数据引发的信任异议，而自托管将数据保留在团队自己的服务器上。
- Web应用形式使协作和共享成为原生的，因此面向非技术用户的工具像Airtable一样在团队中传播，却无锁定。
可借鉴之处
在用户信任的基础上构建：Mathesar编辑真实的Postgres表、角色和外键，采用薄抽象，使强大数据库易于使用，无需迁移或封闭层。
后续进展
截至2026-09-05快照，Mathesar处于公开测试阶段：GitHub仓库显示5.1k星、486个fork和19,134次提交；README链接到文档、Matrix聊天、Discord和路线图；对于不希望自托管的用户，Mathesar Cloud处于早期测试版，提供免费计划。关于页面描述了核心团队，成员是社区资深人士，背景包括Creative Commons和WordPress，统计有100+贡献者。未披露关闭、收购、融资轮或转向。
资料来源
发现哪里写错了？告诉我们。
轮到你了
你刚读完一家。说说你在做什么，看看谁在赌同一件事。
免费账号 · 3 次免费提问 · 不用绑卡