Mathesar – open-source collaborative UI for Postgres databases
Hi HN! We just released the public alpha version of Mathesar (https://mathesar.org/, code: https://github.com/centerofci/mathesar). Mathesar is an open source tool that provides a spreadsheet-like interface to a PostgreSQL database. I was originally inspired by wanting to build something like Dabble DB. I was in awe of their user experience for working with relational data. There’s plenty of “relational spreadsheet” software out there, but I haven’t been able to find anything with a comparable UX since Twitter shut Dabble DB down. We're a non-profit…
In plain words
Mathesar is an open-source tool that provides a spreadsheet-like interface for working with PostgreSQL databases. It allows users to connect to existing databases or create new ones, with UI elements like links mapping directly to database features such as foreign keys. The tool is designed for anyone needing to access and manage relational data without writing SQL, and is maintained by a non-profit organization.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hi HN! We just released the public alpha version of Mathesar (https://mathesar.org/, code: https://github.com/centerofci/mathesar). Mathesar is an open source tool that provides a spreadsheet-like interface to a PostgreSQL database. I was originally inspired by wanting to build something like Dabble DB. I was in awe of their user experience for working with relational data. There’s plenty of “relational spreadsheet” software out there, but I haven’t been able to find anything with a comparable UX since Twitter shut Dabble DB down. We're a non-profit project. The core team is based out of a US 501(c)(3). Features: * Built on Postgres: Connect to an existing Postgres database or set one up from scratch. * Utilizes Postgres Features: Mathesar’s UI uses Postgres features. e.g. "Links" in the UI are foreign keys in the database. * Set up Data Models: Easily create and update Postgres schemas and tables. * Data Entry: Use our spreadsheet-like interface to view, create, update, and delete table records. * Data Explorer: Use our Data Explorer to build queries without knowing anything about SQL or joins. * Schema Migrations: Transfer columns between tables in two clicks in the UI. * Custom Data Types:: Custom data types for emails and URLs (more coming soon), validated at the database level. Links: CODE: https://github.com/centerofci/mathesar LIVE DEMO: https://demo.mathesar.org/ DOCS: https://docs.mathesar.org/ COMMUNITY: https://wiki.mathesar.org/en/community WEBSITE: https:/mathesar.org/ SPONSOR US: https://github.com/sponsors/centerofci or https://opencollective.com/mathesar
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, March 2023
the whole month →
- BI
I'm a big fan of the BBC podcast In Our Time -- and (like most people) I've been playing with the OpenAI APIs. In Our Time has almost 1,000 episodes on everything from Cleopatra to the evolution of teeth to plasma physics, all still available, so it's my starting point to learn about most topics. But it's not well organised. So here are the episodes sorted by library code. It's fun to explore. Web scraping is usually pretty tedious, but I found that I could send the minimised HTML to GPT-3 and get (almost) perfect JSON back: the prompt includes the Typescript definition. At the same time I…
AI · 2023 · genmon.github.io