Mathesar
A self-hosted, spreadsheet-like web interface for viewing, editing and querying PostgreSQL data.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
About Mathesar
Mathesar gives a PostgreSQL database a spreadsheet-like web interface, so both database admins and non-technical colleagues can view, edit and query data without writing code. It works directly with Postgres schemas and tables and relies on Postgres permissions for access control rather than adding its own layer.
It is self-hosted on your own servers and maintained by a 501(c)(3) nonprofit that commits to keeping it fully open source. A hosted cloud version can also be tried.
Strengths
- Spreadsheet-like editing for non-technical users
- Uses native Postgres permissions for access control
- Self-hosted, keeping data on your servers
- Nonprofit, fully open-source project
Limitations
- PostgreSQL only
- Requires running a server
Details
- Pricing
- FreeFree and open source, maintained by a nonprofit; a cloud version can be tried free.
- License
- Open source, license not stated
- Developer
- Mathesar Foundation
- Platforms
- Web, Self-hosted
- How it runs
- Self-hosted, Hosted service
- Best suited for
- Teams that want non-developers to work with PostgreSQL data safely
- Categories
- Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to Mathesar
Compare allSoftware that can replace Mathesar for an important use case, and what changes if you switch.
NocoDB
A no-code tool that presents a database as a spreadsheet, offered as a cloud service or self-hosted.
NocoDB connects to existing Postgres and MySQL databases with grid, Kanban, gallery and form views, but it is not open source and larger plans go through sales.
Teable
An Airtable-style no-code database and AI spreadsheet for building business tables, apps and workflows.
Teable is an open-source Airtable-style spreadsheet on a PostgreSQL database with automations and AI data extraction, though it is web-based and its hosted version needs an account.
Baserow
An open-source no-code database and app builder, used in the cloud or self-hosted.
Baserow is an MIT-licensed no-code database with Kanban, calendar and timeline views plus automations, storing data in its own tables rather than working on your existing PostgreSQL.
Grist
A relational spreadsheet-database that can be self-hosted or used as a managed web service.
Grist is a relational spreadsheet-database with cell-level access rules and a self-hostable open-source core, using its own documents instead of native Postgres permissions.
Mathesar as an alternative
Listings that name Mathesar as an alternative.
pgweb
A web-based PostgreSQL client that ships as a single binary and runs in your browser.
Mathesar is a self-hosted PostgreSQL web interface with spreadsheet-like editing for non-technical users and native Postgres permissions, requiring a running server.
Similar software
Related functionality, not necessarily a direct replacement.
pgAdmin
The standard open-source administration tool for PostgreSQL.
Metabase
An open-source analytics tool for querying databases and building dashboards, with or without writing SQL.
Outerbase Studio
A lightweight open-source database GUI that runs in the browser for Postgres, MySQL and SQLite.
PostgreSQL
The open-source relational database with 35 years behind it, known for correctness, extensibility and a long feature list.
