Mathesar Documentation

Mathesar is a self-hostable open source web application that provides a spreadsheet-like interface to PostgreSQL databases. 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).

Try Mathesar

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.

1. With Docker installed, run:

   docker run -it --name mathesar -p 8000:8000 mathesar/mathesar:latest
   

2. 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:

     docker exec -it mathesar sudo -u postgres psql
     

   • 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!

Install 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.

Help out

• Make a donation - We’re a non-profit organization and your donations help sustain our core team.
• Help build Mathesar - As an open source project, we actively encourage contribution!