Mathesar
GPL-3.0
- Platform
- Web Docker
- Licence
- GPL-3.0 Open source
Mathesar is a self-hosted web application that puts a spreadsheet-style interface in front of a PostgreSQL database. You point it at an existing Postgres database — or let it set one up — and users of any technical level can browse schemas, edit table records, build queries and share forms without touching SQL. It works directly with Postgres schemas, tables, primary keys, foreign keys, constraints and data types instead of inventing its own abstractions on top of them.
Access control is what separates it from most no-code database front ends: Mathesar uses the database’s own Postgres roles and privileges, so the permissions someone has in the UI are the permissions they actually have on the server. It is developed by Mathesar Foundation, a 501(c)(3) nonprofit, and released under the GPLv3.
Features
- Connect to an existing Postgres database or create a new one from the interface
- Spreadsheet-like data entry — view, create, update and delete table records, with filter, sort and group
- Postgres-native access control: existing roles and privileges are used in the UI, or you can set up new ones
- Data Explorer query builder for building joins and filters without writing SQL
- Forms you can share by unique link, with submissions saved straight back as records
- Create and update schemas and tables, and move columns between tables in two clicks
- Import and export data to work on it elsewhere
- Custom email and URL data types, validated at the database level
Things to know
- The project still labels itself public beta, though it describes that stage as stable and feature-rich enough for production use.
- Installation is Docker-based (docker compose) per the official docs, and it needs a reachable PostgreSQL server — either yours or one it creates.
- There is a hosted Mathesar Cloud in early beta with a free plan if you would rather not run the server yourself.
- Current release at the time of writing is 0.12.0.
Alternatives
Datasette is the read-first option — it publishes a SQLite database as browsable, queryable pages and JSON APIs, whereas Mathesar is a read-write front end built for Postgres. ChartDB covers the diagramming side, drawing an ER diagram from a schema without editing the rows themselves.
Views: 2