Mathesar

Intuitive spreadsheet-like interface that lets users of all technical skill levels view, edit, query, and collaborate on Postgres data directly—self hosted, with native Postgres access control.

Website • Docs • Matrix (chat) • Discord • Contributor Wiki • Roadmap

Mathesar is a web application that makes working with PostgreSQL databases both simple and powerful. It empowers users of all technical skill levels to view, edit, query, and collaborate on data with a familiar spreadsheet-like interface—no code needed. It’s self hosted, can be deployed in minutes, and works directly with PostgreSQL databases, schemas, and tables without extra abstractions. The project is 100% open source and maintained by Mathesar Foundation, a 501(c)(3) nonprofit.

Mathesar is as scalable as Postgres and supports any size or complexity of data, making it ideal for workflows involving production databases. It requires minimal setup, and integrates into your existing infrastructure. Because Mathesar is self-hosted, your data never leaves your servers, and access control based on Postgres roles and privileges keeps your database secure without adding unnecessary risk.

Table of Contents

• Status
• Install Mathesar
• Join our community
  • Contribute to Mathesar
• Features
• Screenshots
  • Connecting a database
  • Adding collaborators
  • Viewing a Postgres schema
  • Working with tables
  • Finding a nested record
  • Linking two tables together
  • Managing table permissions
  • [Viewing a single record with rel