mathesar-foundation/mathesar

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.

Star history