# mathesar-foundation/mathesar

An intuitive spreadsheet-like interface that lets users of all technical skill levels view, edit, query, and collaborate on Postgres data directly. 100% open source and self hosted, with native Postgres access control.

Repository: https://github.com/mathesar-foundation/mathesar
Canonical: https://ross.abutalabs.com/products/mathesar
Homepage: https://mathesar.org/
Language: Svelte
License: GPL-3.0
License Family: copyleft
Topics: python, django, javascript, typescript, svelte, sveltejs, postgresql, postgres, database-management, database-gui, airtable-alternative, automatic-api, database-access, db-admin, postgresql-database
Last push: 2026-08-25T23:08:00+00:00

## Health v2 (maintenance only)
Score: 92/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 79, longevity 100
- inputs: {"age_days": 1995, "days_push": 8, "days_rel": 62, "gap_med": 32, "n_releases_24m": 18}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 5107, forks 486 (observed 2026-08-28T04:09:09.867162+00:00)

## What it is
Mathesar is a self-hosted web application providing a spreadsheet-like interface for viewing, editing, querying, and collaborating on PostgreSQL data. It works directly with Postgres schemas, tables, and role-based permissions without extra abstractions, and is maintained by a nonprofit as 100% open source.

## Use cases
- give non-technical users a spreadsheet UI over a Postgres database
- self-hosted Airtable alternative backed by Postgres
- build a CRUD front end for existing Postgres tables
- manage inventory or asset records in a shared database
- collaborate on data with Postgres role-based access control
- administer Postgres schemas and tables without writing SQL

## When to choose
- you use PostgreSQL and want a no-code interface for non-technical users
- you need self-hosting so data never leaves your servers
- you want access control to come from native Postgres roles and privileges
- you need a tool that scales with production databases without extra abstraction layers

## When to avoid
- you use MySQL, SQLite, or other non-Postgres databases
- you need a hosted SaaS with zero infrastructure
- you need a full spreadsheet engine with formulas and pivot tables
- you need heavy analytics or BI dashboards rather than data entry and editing

## Facets
- artifact type: application
- maturity: active
- function: database, gui, http-server, auth, authorization, api-framework
- domain: databases, self-hosted, web-development, developer-tools
- platform: self-hosted, python, cross-platform
- tags: postgresql, database-gui, spreadsheet-interface, airtable-alternative, django, svelte, data-management, crud, admin-ui, web-server, docker, linux

## Member repositories
- mathesar-foundation/mathesar (main) score 92

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:09.867162+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:02:10.660895+00:00, confidence not recorded.
  - readme: https://github.com/mathesar-foundation/mathesar (fetched 2026-08-28T04:09:09.867162+00:00, sha acc21f07c0ce)
  - homepage: https://mathesar.org/ (fetched 2026-08-29T08:57:19.425624+00:00, sha c0f93b87bd92)
  - site_page: https://docs.mathesar.org (fetched 2026-08-29T08:57:19.439961+00:00, sha 36c6c3c2e4f9)
  - site_page: https://mathesar.org/about (fetched 2026-08-29T08:57:19.435407+00:00, sha b18f7de22353)
  - site_page: https://docs.mathesar.org/latest (fetched 2026-08-29T08:57:19.438066+00:00, sha db9e89992e3b)
- Data as of 2026-08-30T08:39:29.467469+00:00.