# Mathesar

> A spreadsheet view on your PostgreSQL data, for your whole team.

- Page: https://cgt.octabyte.io/templates/mathesar/
- Category: Docs & wikis
- Replaces: Airtable
- Ease of use: Easy. Open your web address right after setup to create the admin account; untick the two usage-data boxes on that page if you want nothing sent to Mathesar.
- App price: Free. To run it you need Cloudgate (hosted, or free to install yourself) and a server, which hosted Cloudgate can provide.
- License: GPL-3.0-only
- Good for: Teams that keep their data in PostgreSQL and want colleagues to work with it without SQL
- Official website: https://mathesar.org
- Documentation: https://docs.mathesar.org/latest/
- Source code: https://github.com/mathesar-foundation/mathesar
- Last updated: 2026-11-20

## What is Mathesar?

Self-hosted Mathesar gives your PostgreSQL data a spreadsheet-like screen, so your team can view, edit, link and report on records without SQL.

Self-hosted Mathesar is an open-source web app that gives a PostgreSQL database a spreadsheet-like screen, so your team can view, edit, link and report on data without writing SQL. It is a free alternative to Airtable for teams that want their data kept as ordinary database tables rather than in an app's own format.

Everything you see in Mathesar is a real PostgreSQL table, a link between tables is a real database relationship, and access is set with PostgreSQL's own roles. So any other PostgreSQL tool can use the same data, while colleagues use Mathesar's grid, forms and reports. A bike repair shop, for example, could keep customers, bikes and service requests in linked tables, take new repair requests through a shared form, and build a report of open jobs by mechanic.

Mathesar works with the database Cloudgate sets up alongside it, and can also connect to a PostgreSQL database you already run. It imports and exports CSV files. It is simpler than Airtable: there are no formulas, kanban or calendar views, automations or webhooks, and it is still a public beta. It is made by the Mathesar Foundation, a nonprofit, and works in a web browser, including on a phone. Cloudgate installs it on your server with a secure web address.

## What you can do with Mathesar

- **Edit data like a spreadsheet**: View, add and change records in a grid, with filters, sorting and grouping.
- **Build tables without SQL**: Create tables and columns with plain types such as text, money, date, email and URL.
- **Link related tables**: Connect customers to orders and pick a linked record from a searchable list.
- **Make reports across tables**: The Data Explorer combines tables with filters and summaries, and saves each report.
- **Collect data with forms**: Share a form by link, and every answer becomes a new row in your table.
- **Decide who sees what**: Give each colleague access to a database, schema or table, using PostgreSQL's own roles.
- **Use a database you already have**: Connect Mathesar to an existing PostgreSQL database and work on its tables as they are.
- **Import and export CSV**: Bring in CSV or TSV files with column types guessed for you, and export any table to CSV.

## Replaces Airtable

Mathesar does the same job as Airtable. Here is what changes when you switch.

### What you gain

- Your data is ordinary PostgreSQL tables that any database tool can also read
- No price per editor and no paid tier; every feature is free
- Permissions follow PostgreSQL roles, so the database enforces them
- It can sit on top of a PostgreSQL database you already run

### What is different

- No formulas, and no kanban, calendar or gallery views
- No automations or webhooks
- No Airtable importer; you move tables across as CSV files
- Still a public beta (version 0.x), so expect changes between releases

## What happens when you click Deploy?

Deploy link: https://cloudgate.octabyte.app/get-started?template=mathesar

1. **Click Deploy and create your account.** Deploy takes you to Cloudgate. Create an account, or log in if you have one. Mathesar itself is free.
2. **Choose a server.** No server? Get one from Cloudgate: pick a size and a country, and Cloudgate gets it ready. Already have one? Connect it instead.
3. **Cloudgate sets up Mathesar.** It prepares the server, makes the passwords the app needs and starts it. There is nothing to install and nothing to write down.
4. **Open your app and sign in.** Your app gets a free web address to start, without https. Add your own domain, like app.yourshop.com, and Cloudgate secures it with https for you.

## Questions

### Is Mathesar free?

Yes, Mathesar is free and open source under the GPL-3.0 licence, and the self-hosted app has no paid features. You pay only for your server.

### Is Mathesar a good alternative to Airtable?

Yes. Mathesar is a good alternative to Airtable if you want linked tables, filters and forms on data stored as plain PostgreSQL tables. Mathesar has fewer Airtable features than Baserow or NocoDB, with no formulas, no kanban or calendar views and no automations.

### Can Mathesar work with my existing PostgreSQL database?

Yes, Mathesar can connect to an existing PostgreSQL database you have login details for and show its tables as they are, as well as use the database Cloudgate sets up with it. Changes you make in Mathesar are real changes to that database.

### How do I sign in to Mathesar the first time?

The first person to open Mathesar's web address creates the admin account, so open it right after setup. That page has two boxes ticked by default that send Mathesar an install notice and anonymous usage counts, never your records; untick them if you want nothing sent.

### Can I import my Airtable data into Mathesar?

Partly. Mathesar has no Airtable importer, so you export each Airtable table to CSV, import the CSV files, then link the tables again in Mathesar.

### How are permissions handled in Mathesar?

Mathesar uses PostgreSQL roles and privileges. You add colleagues, give each one a role, and choose what that role can see and change for each database, schema and table.

### Is Mathesar ready for everyday use?

Mathesar calls itself a public beta that is stable enough for production, but it is still at version 0.x and changes between releases. File columns are not set up in this template.

### Do I need technical skills to run Mathesar?

No. Click Deploy, create your Cloudgate account and choose a server, and Cloudgate sets up Mathesar and gives it a web address. You use it in your browser like any other online tool.

### Do I need my own server for Mathesar?

No. When you deploy Mathesar, hosted Cloudgate can provide a server. If you already rent one, you can connect it instead.
