Mathesar is An Open-source Low-Code Database Interface

Mathesar is An Open-source Low-Code Database Interface

Airtable is a popular low-code web service that allows you to manage your data with your team. Moreover, customize your workflow, work on complex data sheets.

Here, we provide you a simple  open-source alternative for it, that allows you to do almost the same, with more control of your data.

Mathesar is a free open-source data management and low-code platform that allows you to import/ export your datasheets, control your database columns/ fields, search with full-text search support, and more.

The project is currently in progress, so new features can be expected soon. Although, unlike similar projects, it targets technically skilled users.

Potential use cases for Mathesar include publishing and exploring public datasets, running business processes such inventory management and project tracking, providing a ready-made interface for speedy data entry and custom reporting, collecting and processing data from large groups of people, simple data cleaning and analysis, and automatic web API generation.

With Mathesar you can:

  1. Aggregate data from multiple table.
  2. Collect data from many sources in one table.
  3. Bookmark subset of data in one table.
  4. Summarize data
  5. Compute and manipulate data from one or multiple columns into a new column.

Furthermore, Mathesar, is built on top of Django and uses PostgreSQL database, can be configured to use MySQL, Oracle, SQLite, and MS SQL Server. However, it will require some work from your side.

Why you may consider Mathesar?

Here are few reasons why you need to consider Mathesar in your work:

Interoperability and Data Portability

Data stored using most comparable tools cannot be modified by other software. Mathesar uses a general purpose database (Postgres) with a thriving ecosystem of interoperable tools.

Approachable User Experience

Existing tools either limit available features or focus on power users. Mathesar meets users at their technical skill level while also supporting advanced features and encouraging learning.

Data Integrity and Reuse

Spreadsheets and low code platforms don’t do much by default to help you make sure data is consistent and this limits reuse potential. Databases are good at this by design.

Open Source Infrastructure

Data is valuable and shouldn’t be tied to using a specific proprietary service. The public needs open source, decentralized, and private infrastructure for people to manage their own data.

User cases

  1. Manage large data sets
  2. Inventory management
  3. CRM building
  4. Event management and planning
  5. Expense tracking
  6. Accounting
  7. As a basic data entry tool
  8. Collect and process data from public and private sources
  9. Automatically generate REST APIs to interact with connected database

Features

  1. Easy installation using Docker and Docker-Compose
  2. Clean clutter-free user-interface
  3. It operates primary on PostgreSQL databases but can be configured to work with MySQL, MS SQL Server, and, SQLite.
  4. Easy to use with a straightforward interface
  5. Full-text search for fields
  6. Import and export your data in several formats
  7. Generate ready-to-use REST-API
  8. Manages large data sets
  9. Collect information from several sources.
  10. User groups and permissions.
  11. Auto-detect field types and formats
  12. Supports dozens of formulas.
  13. Supports complex queries.
  14. Comes with a strong query builder

License

The project is released under the GPL-3.0 License.

Resources