mathesar-foundation/mathesar
Mathesar
Mathesar is a no-code database manager and PostgreSQL GUI that provides a visual interface for managing relational database structures and records. It functions as a low-code data platform for administering schemas, tables, and relationships without the need to write manual SQL commands.
The platform allows for the creation of shareable forms to collect data and the management of file attachments linked directly to database records. It includes a PostgreSQL administration tool for controlling database roles, user permissions, and data validation rules.
The system covers relational data modeling and visual database management, enabling users to link tables and query data through a visual builder. It provides capabilities for importing and exporting data, formatting column displays, and managing record associations via a spreadsheet-like interface.
Features
- Data Record Editing - Provides a spreadsheet-like visual interface for creating, updating, and deleting database records.
- Visual Database Management - Provides a graphical user interface for browsing, editing, and managing database structures and relationships.
- No-Code Database Interfaces - Provides a visual platform to manage and manipulate relational database records using spreadsheet-like interfaces.
- Database Schema Designers - Provides a visual interface for defining and managing database table structures, columns, and constraints.
- Database Schema Mapping - Maps visual table and column configurations directly to PostgreSQL schemas and constraints.
- Database Table Editors - Allows establishing foreign key constraints between tables to model complex data structures.
- Foreign Key Constraints - Enforces referential integrity by managing foreign key constraints between relational database tables.
- PostgreSQL Administration Tools - Includes utilities specifically designed for the administration and management of PostgreSQL databases.
- PostgreSQL GUIs - Provides a visual interface for managing PostgreSQL schemas, tables, and relationships without writing manual SQL.
- Relational Data Modeling - Enables the design of complex data structures by organizing data into structured tables with defined relationships.
- Administration Interfaces - Provides a graphical tool for managing the schema and data of relational databases through a spreadsheet-like interface.
- Visual Query Builders - Ships a visual builder to filter, sort, and group datasets without writing manual SQL.
- Database Access Controls - Implements granular permission and role management specifically for database objects and assets.
- Role-Based Access Control - Manages data visibility and editing permissions by mapping application users to database-level roles.
- Dynamic UI Generators - Dynamically generates data grids and forms based on database column types and stored metadata.
- Internal Business Tools - Offers a platform for building custom dashboards and data management interfaces for internal organizational use.
- Low-Code Platforms - Functions as a visual development environment for collecting data via forms and managing attachments.
- Cloud-Storage Object Linking - Create specialized columns for uploading documents and images directly into database cells using cloud storage.
- Custom Data Collection Forms - Provides shareable forms that save user submissions as new records in the database.
- Data Import and Export - Enables importing and exporting datasets to maintain compatibility with external tools.
- File Attachment Systems - Manages the association and storage of binary files linked to primary database records.
- Data Validation - Enforces data validation and type safety for inputs, such as email formats, before saving to the database.
- Referential Record Selectors - Provides fuzzy search and inline creation for linking specific records to other database entries.
- Query Construction - Translates visual filters and sorts into structured JSON objects for backend processing.
- Data Management Systems - Spreadsheet-like interface for PostgreSQL databases.
- Database and Storage Tools - Web interface for managing PostgreSQL databases.
- Database Management - Listed in the “Database Management” section of the Awesome Selfhosted awesome list.
