Mathesar
A self-hosted web app that turns PostgreSQL into a collaborative spreadsheet-like interface, enabling non-technical users to view, edit, and query data without code.
Smart Download
Visit Project Homepage
No installer available yet — head to the source repository
Turn PostgreSQL into a collaborative spreadsheet – self-hosted, open source, no code required.
Core Features
- Spreadsheet-like data editing and collaboration
- Visual query builder (no SQL needed)
- Custom form builder and sharing
- Postgres role-based access control
- Import/export CSV, JSON, and more
What It Can't Do
- •Requires an external PostgreSQL database (can be self-hosted); cannot run standalone. 2. Currently in Beta; test thoroughly before production use. 3. Self-hosting requires operational skills for server maintenance. 4. Only supports PostgreSQL, not other databases.
Use Cases
- Internal team data collaboration – replace Excel email chains
- Quick data entry forms – generate forms, share links, collect records
- Self-serve reporting for non-technical users via drag-and-drop explorer
- Visual management of Postgres schemas for development/testing
Detailed Introduction
Mathesar is an open-source web application that provides a familiar spreadsheet-like interface for PostgreSQL databases. It allows users of any technical skill level to view, edit, query, and collaborate on data directly within their own infrastructure. Key features include a visual query builder, custom forms for data entry, role-based access control inherited from Postgres, and support for schema migrations, imports/exports, and custom data types. Mathesar runs as a Docker container and can be deployed in minutes. It is maintained by the Mathesar Foundation, a 501(c)(3) nonprofit, ensuring the project remains truly open and free from vendor lock-in. Unlike cloud-only tools (e.g., Airtable), Mathesar keeps all data on your own servers, giving you full control over security and compliance. Its tight integration with PostgreSQL means you can leverage existing roles, constraints, and performance optimizations without extra layers of abstraction.
Troubleshooting & FAQ (2)
TroubleshootingHow to fix 'no library called cairo-2' error and 400 Bad Gateway when installing Mathesar on Debian 13.5?
For the direct installation, the missing system library libcairo2 causes the error. Install it with: sudo apt install libcairo2. For the Docker installation, the Bad Gateway (400) is due to missing ALLOWED_HOSTS. Add your server's IP or domain to the ALLOWED_HOSTS entry in the .env file.
TroubleshootingHow to fix Prettier not running in mathesar_ui due to outdated dependencies?
Delete node_modules, clear the cache (e.g., npm cache clean or yarn cache clean), and reinstall dependencies (npm install or yarn). This resolves the Prettier execution issue caused by stale or corrupted packages.
Tags
Getting Started
Download installer
Click the button above to download the installer for your system
Install the software
Double-click the downloaded installer and follow the prompts
Step 1: Ensure Docker and Docker Compose are installed on your server
Step 2: Download the docker-compose.yml file (see official docs)
Step 3: Run 'docker compose up -d' to start the service
- Step 1: Ensure Docker and Docker Compose are installed on your server
- Step 2: Download the docker-compose.yml file (see official docs)
- Step 3: Run 'docker compose up -d' to start the service
Checksum not available
This project has not published a SHA-256 checksum on its GitHub Release page
SHA256 Checksum
No checksum available
Download directly from GitHub Releases and verify file integrity yourself
All SHA-256 checksums on this platform are extracted from the project's official GitHub Release page, without any modification. You can independently verify them on the GitHub Releases page.
Open Source Transparency
View GitHub SourceUninstall Info
Run 'docker compose down -v' to stop and remove containers and volumes, then delete the configuration files to fully uninstall.
No Extra Dependencies
Ready to use after download. No additional runtime required.
Having issues? Check the FAQ below
2 FAQs
Similar Projects
Git
Fast, scalable, distributed revision control system with a rich command set for version control and collaboration.
pocketbase
PocketBase is an open source Go backend that includes embedded SQLite with realtime subscriptions, built-in file & user management, admin dashboard UI, and simple REST API. Can be used as standalone app or Go framework.
godot
Godot Engine is a free, open-source, cross-platform 2D and 3D game engine with a unified editor. Unlike Unity or Unreal, it's entirely MIT-licensed and community-driven, offering a lightweight yet powerful node-based workflow that runs on a single executable.