Help shape Mathesar! Share your thoughts in our quick survey: Take it here

Open Source Database Interface

Allow quick access to your database – without disrupting your workflow

Use Mathesar’s open source and web-based interface to give your team direct access to Postgres. No technical skills required.

Now you can spend less time creating custom reports and manually updating data.

Allow quick access to your database – without disrupting your workflow

Speed up your data workflows – using Mathesar’s open source interface

You can ensure data integrity. Perform quick schema changes. And let teammates create reports – without depending on you.

Mathesar doesn’t have its own set of abstractions so it won’t make unexpected changes to your database.

Use Postgres directly

BUILT ON POSTGRES

Use Postgres directly

Mathesar uses and manipulates Postgres schemas, primary keys, foreign keys, constraints and data types.

So any configuration you do in the UI will reflect directly in your Postgres databases. Nothing will prevent you from working with the same data in other tools outside of Mathesar.

All the same data integrity safeguards you set up via the Mathesar UI will still apply.

Your data is yours

SELF-HOSTED

Your data is yours

Proprietary products can keep you locked in their ecosystem. This can make it difficult to integrate or migrate your disparate data sources.

If you decide to move away, you could lose data.

Mathesar is self-hosted – giving you full control over your system and your data. You can integrate with other Postgres-friendly tools.

Your collaborators can easily work with normalized data

NORMALIZED DATA

Your collaborators can easily work with normalized data

Non-technical people often struggle to work with normalized data. Even database-spreadsheet hybrid applications complicate the normalization process.

Mathesar creates and reflects relationships at the database level. There are no “relationship column types” and there are no abstractions.

Mathesar uses actual foreign key constraints and provides a UI to understand links easily – no technical skills required.

Reduce dependencies on you – empower collaborators to use your database

EASY UX

Reduce dependencies on you – empower collaborators to use your database

Your colleagues can use Mathesar’s interface to answer their ad-hoc questions quickly.

This can reduce the need for you to create custom reports and update data manually.

Developed in collaboration with our community

OPEN SOURCE

Developed in collaboration with our community

Mathesar is free, licensed under GPLv3. There are no paid plans.

Although we’re new, we already have dozens of contributors. If you’re interested, you can also contribute.

We work in public – you can check out what our team is doing on GitHub and Matrix. And via our mailing lists.

Perform schema changes – in minutes

SCHEMA MIGRATIONS

Perform schema changes – in minutes

Manually changing your schema can require hours of rote work or custom code. This can lead to disruptions – like downtime, stale data and difficulties in meeting your SLA.

Mathesar makes schema and data migrations a one-click solution. There are no disruptions – which can help ease your data integration workflow.

Build views across multiple tables

DATA EXPLORER

Build views across multiple tables

Database joins can be confusing for non-technical users to fully understand.

With Mathesar’s Data Explorer, your collaborators don’t need to understand joins. They can see and use relationships between data – with the joins happening behind the scenes.

Anyone can build a query through the UI that displays data from across multiple tables.

This can remove the dependency layer on you and allow for more exploration into your database.

You and your collaborators can quickly enter data. View it. Slice it.

Move data around. Transform and filter it.

While still retaining structure and consistency.

Pavish - Engineer, Mathesar

"I experienced collaboration issues every day."

“At my previous job, business experts relied on me to create reports for them, every single day.

But shouldn’t developers be focusing more on supporting technical infrastructure? Isn’t that our main function?

With Mathesar, they would have had the tools to generate their own reports, allowing developers to focus on what we do best.”

Pavish - Engineer, Mathesar

Use Cases

Here's what you could set up in your first 30 mins of using Mathesar:

Use Mathesar as a flexible tool throughout your project lifecycle

Use Mathesar to set up a backend for your custom application.

Mathesar can work as frontend to existing databases, without altering your data.

Stay updated on our open source and cloud development

We'll send you occasional email updates about Mathesar. You can opt out at any time.

Which version(s) of Mathesar are you most interested in?