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.
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.
This is free and open source software.
Key Features
- Built on Postgres: Connect to an existing Postgres database or set one up from scratch.
- Install in minutes: Install using Docker in minutes, integrate into any existing infrastructure.
- Postgres-based access control: Use existing Postgres roles within Mathesar’s UI, or set up your own.
- Interoperable with other tools: Mathesar works harmoniously alongside your database and thousands of other tools in the Postgres ecosystem.
- Set up your data models: Easily create and update Postgres schemas and tables.
- Data entry: Use our spreadsheet-like interface to view, create, update, and delete table records.
- Filter, sort, and group: Quickly slice your data in different ways.
- Query builder: Use our Data Explorer to build queries without knowing anything about SQL or joins.
- Import and export data: Import and export data into Mathesar easily to work with your data elsewhere.
- Schema migrations: Transfer columns between tables in two clicks.
- Uses Postgres features: Mathesar uses and manipulates Postgres schemas, primary keys, foreign keys, constraints and data types. e.g. “Relationships” in the UI are foreign keys in the database.
- Custom data types: Custom data types for emails and URLs, validated at the database level.
Website: mathesar.org
Support: GitHub Code Repository
Developer: Mathesar Foundation
License: GNU General Public License v3.0
Mathesar is written in TypeScript and Python. Learn TypeScript with our recommended free books and free tutorials. Learn Python with our recommended free books and free tutorials.
Related Software
| No-Code Database Tools | |
|---|---|
| NocoDB | Build databases as spreadsheets |
| Teable | Manage your data and connect your team |
| Baserow | No-code database and Airtable alternative |
| Directus | Real-time API and App dashboard for managing SQL database content |
| Grist | Modern relational spreadsheet |
| rowy | Low-code backend in the browser |
| Saltcorn | No-code application development platform |
| Mathesar | Spreadsheet-like tool for Postgres data |
| UNDB | No-code platform that can also serve as a Backend as a Service |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.