Repolode
Submit
mathesar-foundation

mathesar-foundation/mathesar

A spreadsheet-like web interface for viewing, editing, querying and sharing data in self-hosted PostgreSQL databases.

Open-source alternative to:Airtable

View on GitHubWebsite
Stars
5,169
Forks
489
Open issues
316
Last commit
2 days ago

What is it?

Mathesar is a self-hosted web application that gives people a spreadsheet-like way to work with PostgreSQL data without writing SQL. It connects directly to existing PostgreSQL databases, schemas and tables rather than maintaining a separate data layer, so the data stays in your own Postgres instance.

Users can create and edit tables, filter, sort and group records, and link tables through foreign keys, which the interface presents as relationships. A Data Explorer lets people build queries without knowing SQL or joins, and Forms can collect submissions from anyone through a shared link, saving each one as a new record.

Access is governed by existing Postgres roles and privileges, so permissions set in the database apply inside Mathesar. The project is installed with Docker and is released under GPL-3.0.

Key features

  • 01Spreadsheet-style view, create, edit and delete of table records
  • 02Query builder (Data Explorer) that works without SQL knowledge
  • 03Public forms with a shareable link that save submissions as records
  • 04Access control using existing Postgres roles and privileges
  • 05Import and export of data, plus moving columns between tables
  • 06Installs with Docker and works with existing Postgres databases

Use cases

  • Letting non-technical staff edit a production Postgres database safely
  • Replacing an Airtable-style spreadsheet with data kept on your own server
  • Collecting data from external people through a shared form that writes to a database table
  • Exploring relational data across linked tables without writing joins

Quick start

  1. 1

    Follow the installation instructions in the official Mathesar documentation to deploy it on your server

  2. 2

    Or sign up for Mathesar Cloud, which has a free plan and needs no installation

Things to know

  • The README says the project is in public beta, not yet widely used in production.
  • It is licensed under GPL-3.0, a copyleft license that requires derivative works to be distributed under the same terms.
  • It works only with PostgreSQL databases and requires you to self-host it or use the cloud service.

In collections

Self-hosted appsDatabases & SQL tools

Topics

#postgresql#database-gui#spreadsheet#self-hosted#data-entry#no-code#sql#docker#airtable-alternative#automatic-api

FAQ

What is mathesar?
A spreadsheet-like web interface for viewing, editing, querying and sharing data in self-hosted PostgreSQL databases. Mathesar is a self-hosted web application that gives people a spreadsheet-like way to work with PostgreSQL data without writing SQL. It connects directly to existing PostgreSQL databases, schemas and tables rather than maintaining a separate data layer, so the data stays in your own Postgres instance.
Is mathesar free to use? What license does it have?
mathesar is open source under the GPL-3.0 license. Check the license terms before using it in commercial products.
Is mathesar still maintained?
Actively maintained. The last commit to mathesar was on Nov 5, 2026.
What can I use mathesar for?
Letting non-technical staff edit a production Postgres database safely Replacing an Airtable-style spreadsheet with data kept on your own server Collecting data from external people through a shared form that writes to a database table Exploring relational data across linked tables without writing joins
How do I install mathesar?
Follow the installation instructions in the official Mathesar documentation to deploy it on your server Or sign up for Mathesar Cloud, which has a free plan and needs no installation
Where can I get mathesar?
The source code and installation instructions are on GitHub: https://github.com/mathesar-foundation/mathesar

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects