Mathesar
Provide a simple, spreadsheet-like UI for your PostgreSQL database. This open-source tool is self-hosted, secure, and easy for anyone to use, no technical skills needed.
Mathesar provides an intuitive, open-source UI to view, edit, and query your PostgreSQL data. It combines the simplicity of a spreadsheet with the power of Postgres, making it accessible for both database administrators and business users. It works directly with your existing database schemas and tables, adding no extra layers of abstraction.
This tool is designed for production databases and scales as easily as Postgres, supporting any size or complexity of data. You have complete control, as it's self-hosted on your own infrastructure and your data is never shared with third parties.
Key features include:
- 100% Open Source & Nonprofit: Maintained by a 501(c)(3) nonprofit, eliminating vendor lock-in.
- Native Postgres Permissions: Relies on your existing database permissions for access control, enhancing security.
- Easy Installation: Get started in minutes with a tool that requires no code to use.
Use it for asset management, as a CRUD front end, for customer support, or to build shareable data dashboards.
Directory Structure
mathesar
mathesar-db-data
.env
docker-compose.yml
docker-compose.yml
services:
db:
image: postgres:14
restart: unless-stopped
environment:
POSTGRES_DB: mathesar
POSTGRES_USER: mathesar
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
volumes:
- ./mathesar-db-data:/var/lib/postgresql/data
mathesar:
image: mathesar/mathesar:latest
restart: unless-stopped
ports:
- "8000:8000"
environment:
POSTGRES_HOST: db
POSTGRES_PORT: 5432
POSTGRES_DB: mathesar
POSTGRES_USER: mathesar
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
SECRET_KEY: ${SECRET_KEY}
depends_on:
- db.env
POSTGRES_PASSWORD=your_secure_postgres_password
SECRET_KEY=your_super_secret_django_key_hereCategories:
Tags:
Ad
Similar to Mathesar