Mathesar is a self-hostable open source project that provides a spreadsheet-like interface to a PostgreSQL database. Our web-based interface helps you and your collaborators set up data models, edit data, and build custom reports — no technical skills needed. You can create a new PostgreSQL database while setting up Mathesar or use our UI to interact with an existing database (or do both).
See our live demo site to try Mathesar without installing anything.
This is a quick way to play with Mathesar locally, but is not appropriate for saving data that you care about or setting up a long-term installation.
With Docker installed, run:
Visit http://localhost:8000/ to set up an admin user account and create a database connection.
Tips when trying Mathesar locally
To open a psql shell within the container, run:
To stop Mathesar, press Ctrl+C in the shell where it is running.
To start again, run
docker start mathesar.
To remove the Docker container, run
docker rm mathesar.
⚠️ This will also delete the data that you’ve saved within Mathesar!
You can self-host Mathesar by following one of the guides below:
- Install using Docker compose — a production setup with separate reverse-proxy and database containers.
- Install from scratch — an advanced setup that doesn’t rely on Docker.
More installation methods coming soon
We’re working on supporting additional installation methods, and we’d appreciate feedback on which ones to prioritize. Please comment on this issue if you have thoughts.
Mathesar should be pretty intuitive to use. More documentation is coming soon, but for now, we’ve written some documentation for some things that could be tricky.
- Syncing database changes if the database’s structure is changed outside of Mathesar.
- How to set up users with different access levels
Contribute to Mathesar¶
As an open source project, we actively encourage contribution! Get started by reading our Contributor Guide.