Logo
Deploy Now

SaaS Alternative

Airtable Retool Google Sheets

Stars

5,101

Forks

484

Watchers

30

Developer links

Mathesar

Mathesar puts a spreadsheet in front of your PostgreSQL database, letting anyone on the team browse, edit, filter, sort, and query tables without writing a line of SQL. Connect it to any existing PostgreSQL instance and immediately navigate schemas, tables, and records through an intuitive grid interface with inline editing, grouping, and summarization. The query builder joins tables across foreign key relationships, creates custom views with aggregations, and exports results to CSV. Rather than inventing its own permission layer, Mathesar maps each user or team to a native PostgreSQL role with granular schema-level and table-level privileges enforced at the database engine level, so there is never a gap between what the UI allows and what the database permits. Record summary templates display human-readable representations of linked records, making foreign key relationships immediately understandable instead of showing raw IDs. Import data from CSV files, create new tables and columns with proper PostgreSQL types including arrays, JSON, and custom domains, and modify schema structure through the web interface. Mathesar scales as well as the underlying PostgreSQL instance with no artificial limits on database size or complexity. Maintained by the Mathesar Foundation, a 501(c)(3) nonprofit, with a permanent commitment against vendor lock-in or licensing changes. Docker deployment connects to existing PostgreSQL instances or a bundled database in minutes. 5,000+ GitHub stars. GPL-3.0 licensed.

Mathesar
Mathesar
Mathesar
Mathesar
Mathesar

Benefits

  • Spreadsheet Interface for Postgres
  • Browse, edit, filter, sort, and group PostgreSQL data through an intuitive spreadsheet-like grid interface requiring zero SQL knowledge for viewing and modifying database records.
  • Native Postgres Access Control
  • Security enforced through native PostgreSQL roles and privileges at the database engine level, eliminating application-layer permission models that can diverge from actual database security.
  • No-Code Query Builder
  • Join tables across foreign key relationships, create custom views with aggregations and summaries, and export filtered results to CSV without writing any SQL queries.
  • Nonprofit Open Source Commitment
  • Maintained by Mathesar Foundation, a 501(c)(3) nonprofit committed to keeping the project permanently open source with no vendor lock-in or future licensing changes.

Features

  • Data Exploration
  • Filter, sort, group, and summarize PostgreSQL table data with visual controls supporting record summary templates for human-readable foreign key display.
  • Schema Management
  • Create tables, add columns with proper PostgreSQL types including arrays and JSON, modify constraints, and manage indexes through the web UI.
  • Table Joining
  • Build multi-table views by joining across foreign key relationships with visual query construction, aggregation functions, and CSV export.
  • CSV Import/Export
  • Import data from CSV files into new or existing tables with automatic type detection, and export filtered query results for external analysis.
  • Docker Deployment
  • Single Docker Compose setup with automatic database migrations, connecting to existing PostgreSQL instances or bundled database in minutes.