https://github.com/centerofci/mathesar Skip to content Toggle navigation Sign up * Product + Actions Automate any workflow + Packages Host and manage packages + Security Find and fix vulnerabilities + Codespaces Instant dev environments + Copilot Write better code with AI + Code review Manage code changes + Issues Plan and track work + Discussions Collaborate outside of code + Explore + All features + Documentation + GitHub Skills + Blog * Solutions + For + Enterprise + Teams + Startups + Education + By Solution + CI/CD & Automation + DevOps + DevSecOps + Case Studies + Customer Stories + Resources * Open Source + GitHub Sponsors Fund open source developers + The ReadME Project GitHub community articles + Repositories + Topics + Trending + Collections * Pricing [ ] * # In this repository All GitHub | Jump to | * No suggested jump to results * # In this repository All GitHub | Jump to | * # In this organization All GitHub | Jump to | * # In this repository All GitHub | Jump to | Sign in Sign up {{ message }} centerofci / mathesar Public * * Notifications * Fork 154 * Star 389 Web application providing an intuitive user experience to databases. mathesar.org/ License GPL-3.0 license 389 stars 154 forks Star Notifications * Code * Issues 311 * Pull requests 26 * Discussions * Actions * Security * Insights More * Code * Issues * Pull requests * Discussions * Actions * Security * Insights centerofci/mathesar This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. develop Switch branches/tags [ ] Branches Tags Could not load branches Nothing to show {{ refName }} default View all branches Could not load tags Nothing to show {{ refName }} default View all tags Name already in use A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch? Cancel Create 6 branches 1 tag Code * Local * Codespaces * Clone HTTPS GitHub CLI [https://github.com/c] Use Git or checkout with SVN using the web URL. [gh repo clone center] Work fast with our official CLI. Learn more. * Open with GitHub Desktop * Download ZIP Sign In Required Please sign in to use Codespaces. Launching GitHub Desktop If nothing happens, download GitHub Desktop and try again. Launching GitHub Desktop If nothing happens, download GitHub Desktop and try again. Launching Xcode If nothing happens, download Xcode and try again. Launching Visual Studio Code Your codespace will open once ready. There was a problem preparing your codespace, please try again. Latest commit @pavish pavish Merge pull request #2629 from centerofci/master ... 3e98bcf Mar 2, 2023 Merge pull request #2629 from centerofci/master Merge master into develop 3e98bcf Git stats * 9,517 commits Files Permalink Failed to load latest commit information. Type Name Latest commit message Commit time .github Added funding.yml file. March 1, 2023 11:10 LICENSES Clean up license info for toast November 23, 2021 11:58 config consistent 404 pages across client and server February 21, 2023 18:37 db Merge pull request #2621 from centerofci/master March 1, 2023 20:28 demo Merge branch 'master' into limit-redundant-reflection February 28, 2023 22:17 docs Fix command in uninstall docs March 2, 2023 09:01 fixtures Some refactoring and clean up May 31, 2022 16:29 mathesar Updated version number. March 1, 2023 15:18 mathesar_ui Merge branch 'centerofci:develop' into linh March 1, 2023 22:50 setup Split secret key generator function into a separate file December 20, 2022 05:50 .dockerignore Use client build and disable vite dev server when not in development ... July 23, 2021 00:07 .env.example fix ADDED_HOSTS variable for security when running locally February 24, 2023 16:15 .flake8 Add Flake8 configuration July 15, 2021 10:05 .gitignore Merge branch 'master' into update-gitignore January 13, 2023 14:42 CONTRIBUTING.md Updated contributor instructions. June 3, 2021 12:48 Caddyfile Increase keepalive duration limit February 27, 2023 12:50 Dockerfile Fix Dockerfile to copy all requirement files January 24, 2023 03:17 Dockerfile.caddy Add caddy data and config directory as docker volumes February 21, 2023 15:26 Dockerfile.integ-tests Fix requirements-demo.txt installation January 10, 2023 14:55 LICENSE License mathesar under GPLv3 May 3, 2021 15:17 README.md Clarified feature description in README March 1, 2023 15:36 THIRDPARTY Add django-prefetch license terms to mathesar THIRDPARTY docs September 13, 2022 03:13 conftest.py Various changes September 30, 2022 16:28 currency_info.json Add fuzzy matching currency symbols for money type display options March 21, 2022 17:26 dev-run.sh Create superuser during dev setup February 20, 2023 20:02 docker-compose.yml Merge pull request #2584 from centerofci/ fix-prod-exposing-8000-to-host March 1, 2023 16:23 install.py fix ADDED_HOSTS variable for security when running locally February 24, 2023 16:15 install.sh actually set db host for preexisting DBs March 2, 2023 22:06 lint.sh Revert lint.sh to conditionally turn on RUN_NODE May 31, 2022 11:42 manage.py Add production and development settings file January 5, 2023 07:15 pyproject.toml Added pytest fixture to vulture ignore list September 28, 2022 16:06 requirements-demo.txt remove demo compose service, reorganize February 8, 2023 00:45 requirements-dev.txt Bump ipython from 7.31.1 to 8.10.0 February 11, 2023 00:30 requirements-prod.txt Move gunicorn to common requirements file January 21, 2023 02:57 requirements.txt Bump requests to 2.28.2 February 25, 2023 03:46 run.sh add connection timeouts to DB connection testing February 28, 2023 02:09 setup.cfg Add production and development settings file January 5, 2023 07:15 View code [ ] Mathesar Status Join our community! Screenshots Live Demo Features Self-hosting Local development setup Our motivation Contributing License README.md Mathesar logo An intuitive UI for managing data, for users of all technical skill levels. Built on Postgres. License GitHub closed issues GitHub commit activity Codecov Website * Docs * Live Demo * Matrix (chat) * Wiki Mathesar Mathesar is a straightforward open source tool that provides a spreadsheet-like interface to a PostgreSQL database. Our web-based interface helps you and your collaborators work with data more independently and comfortably - no technical skills needed. You can use Mathesar to build data models, enter data, and even build reports. You host your own Mathesar installation, which gives you ownership, privacy, and control of your data. Table of Contents * Status * Join our community! * Screenshots * Live Demo * Features * Self-hosting * Local development setup * Our motivation * Contributing * License Status * [*] Public Alpha: You can install and deploy Mathesar on your server. Go easy on us! * [ ] Public Beta: Stable and feature-rich enough to implement in production * [ ] Public: Production-ready We are currently in the public alpha stage. Join our community! The Mathesar team is on Matrix (chat service). We also have mailing lists and the core team discusses day-to-day work on our developer mailing list. Screenshots crm-table authors-filter talks-with-topics author-record arxiv-schema db-page Live Demo Check out a live demo of Mathesar here! Features * Built on Postgres: Connect to an existing Postgres database or set one up from scratch. * Set up your data models: Easily create and update Postgres schemas and tables. * Data entry: Use our spreadsheet-like interface to view, create, update, and delete table records. * Filter, sort, and group: Quickly slice your data in different ways. * Query builder: Use our Data Explorer to build queries without knowing anything about SQL or joins. * Schema migrations: Transfer columns between tables in two clicks. * Uses Postgres features: Mathesar uses and manipulates Postgres schemas, primary keys, foreign keys, constraints and data types. e.g. "Links" in the UI are foreign keys in the database. * Custom data types: Custom data types for emails and URLs (more coming soon), validated at the database level. * Basic access control: Users can have Viewer (read-only), Editor (can only edit data, but not data structure), or Manager (can edit both data and its structure) roles. Self-hosting Please see our documentation for instructions on installing Mathesar on your own server. Local development setup Please see our guide in our documentation. Our motivation Mathesar is a non-profit project. Our goal is to make understanding and working with data easy for everyone. Databases have been around for a long time and solve common data problems really well. But working with databases often requires custom software. Or complex tooling that people struggle to get their heads around. We want to make existing database functionality more accessible, for users of all technical skill levels. Contributing We actively encourage contribution! Read through our contributing guidelines to get started. License Mathesar is open source under the GPLv3 license - see LICENSE. It also contains derivatives of third-party open source modules licensed under the MIT license. See the list and respective licenses in THIRDPARTY. About Web application providing an intuitive user experience to databases. mathesar.org/ Topics javascript python postgres sqlalchemy django typescript rest-api django-rest-framework postgresql svelte database-management database-gui restful-api sveltejs automatic-api airtable-alternative Resources Readme License GPL-3.0 license Stars 389 stars Watchers 12 watching Forks 154 forks Sponsor this project * * open_collective opencollective.com/mathesar Learn more about GitHub Sponsors Contributors 61 * @pavish * @silentninja * @seancolsen * @mathemancer * @dmos62 * @kgodey * @eito-fis * @rajatvijay * @Anish9901 * @mr-gabe49 * @Jyuart + 50 contributors Languages * Python 48.3% * Svelte 27.4% * TypeScript 21.3% * SCSS 1.8% * Shell 0.6% * HTML 0.4% * Other 0.2% Footer (c) 2023 GitHub, Inc. Footer navigation * Terms * Privacy * Security * Status * Docs * Contact GitHub * Pricing * API * Training * Blog * About You can't perform that action at this time. You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.