Overview:

Mathesar is an open-source tool that offers a user-friendly interface for interacting with PostgreSQL databases. Users can work with data, build models, enter data, and generate reports without needing technical expertise. Mathesar allows users to self-host their installation, ensuring ownership, privacy, and control over their data.

Features:

Built on Postgres: Connect to existing Postgres databases or set up a new one.
Data Models: Easily create and update Postgres schemas and tables.
Data Entry: Utilize a spreadsheet-like interface for viewing, creating, updating, and deleting table records.
Filter, Sort, and Group: Quickly manipulate data in various ways.
Query Builder: Build queries using the Data Explorer without SQL knowledge.
Schema Migrations: Transfer columns between tables with ease.
Postgres Features: Utilizes Postgres schemas, keys, constraints, and data types.
Custom Data Types: Includes custom data types for emails and URLs.
Basic Access Control: Offers roles such as Viewer, Editor, and Manager for data access control.

Mathesar Foundation

Mathesar