Description
Mathesar is an open-source, web-based interface for PostgreSQL databases that looks like a spreadsheet. Database administrators and people who do not write SQL can view, edit and query tables in the same place, without a separate layer of abstraction on top of the data. It works directly with Postgres schemas, tables and permissions, so access control is handled by the database itself, and the project says it does not share your data or allow third parties to access it. Mathesar is designed for production databases and is meant to scale with Postgres. Installation takes a few minutes and needs only minimal additions to an existing database, and no code is needed to use it. It is maintained by the Mathesar Foundation, a 501(c)(3) nonprofit, which says the project is 100% open source. The site also offers Mathesar Cloud, which you can try for free, and it describes uses such as asset and inventory management.…
Preview
Highlights
- Spreadsheet-style view, edit and query of Postgres
- Access control from Postgres permissions
- Installs in minutes on existing databases
- Self-hosted with no third-party access
- Mathesar Cloud free to try
Ratings & Reviews
No ratings yet
Be the first to rate Mathesar.
People also visit
LibreDB Studio
Browser-based SQL IDE for PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Redis
Mathesar FAQ
Is Mathesar free?
Yes. The site says it is 100% open source and maintained by a nonprofit foundation. It also offers Mathesar Cloud, which you can try for free.
Which databases does it work with?
PostgreSQL. It works directly with Postgres schemas, tables and permissions.
How is access controlled?
Through Postgres database permissions, so the rules you already have in the database apply in the interface.
Do I need technical skills to use it?
The site says no. Database administrators and business users can work with the data in a spreadsheet-like interface without writing code.
How do I install it?
The site says installation takes a few minutes, with minimal additions to your existing database. Installation guides are linked from the site.
What are the best Mathesar alternatives?
Popular alternatives to Mathesar include Baserow, Adminer and NocoDB. See all Mathesar alternatives



