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