Schema & data exploration
Databases, tables, columns, indexes, and foreign keys—inspect quickly without juggling desktop clients.
Database clarity for people who need answers, not tickets
PyAdminer is a lightweight, open-source web interface for MySQL and MariaDB. Browse structure, run safe queries, visualize trends, and spot schema issues early—so your team spends less time waiting and more time shipping.
Open source (MIT). Run it on your infrastructure. This site: py-adminer.erevolutionsindia.com — product page by eRevolutions India.
What PyAdminer gives you
Built with Flask for operators, developers, and analysts who live in SQL. Same neutral, focused visual language as the app—minimal chrome, maximum signal.
SQL command panel
Run read-only or permitted writes from one place; optional AI-assisted SELECT drafting when enabled.
Visualization & quality
Profiles, charts, impact and diff views—spot outliers, duplicates, and dependency risk before production.
Diagram & dashboard
ER-style Mermaid diagrams and a per-table health dashboard with practical tuning hints.
Export & audit
CSV/SQL exports and an optional JSON activity log for accountability in regulated workflows.
Hardening options
CSRF protection, rate limits, optional read-only mode, HTTP Basic Auth, and a /health probe.
Improve process, not just queries
PyAdminer fits teams that need fast, repeatable access to truth in the database.
- Faster incident response — Filter and inspect rows, check FKs and orphans, compare tables without a heavy DBA toolchain.
- Cleaner handoffs — Diagrams and structure views onboard new engineers on how data is wired.
- Proactive maintenance — Health hints highlight missing PKs, weak indexing patterns, and charset choices before they hurt performance.
- Vendor-neutral — MIT-licensed; deploy beside your stack. No SaaS lock-in for browsing and querying your own servers.
Quick wins for everyday database work
- Ad-hoc investigations — Save time on “what’s in this column?” and “who references this table?”
- Safe exploration — Combine read-only mode with role separation on the host for production guardrails.
- Optional AI assist — When enabled, draft read-only SQL from plain language; always review before run.
- Portable deployment — Docker compose for local stacks; see project docs/SETUP.md on GitHub.
Frequently asked questions
Quick answers for teams evaluating a self-hosted MySQL or MariaDB admin tool.
What is PyAdminer?
PyAdminer is an open-source web UI for MySQL and MariaDB, built with Flask. It helps you browse databases and tables, run SQL, export data, visualize columns, view ER-style diagrams, and review database health hints—without handing your credentials to a third-party SaaS.
Is it really free and open source?
Yes. PyAdminer is released under the MIT License. You can use it commercially, modify it, and redistribute it subject to the license. Source code lives on GitHub.
Where does my data go?
You run PyAdminer on your servers or containers. This marketing website does not host the app and does not receive your database. Responsibility for backups, access control, and compliance stays with you—see our privacy policy.
How do I install it?
Use Python 3.9+ with pip install -e ".[dev]" from the repo, or Docker Compose. You need a reachable MySQL/MariaDB instance and OS packages to build mysqlclient. Full steps are in docs/SETUP.md on GitHub.
Download the latest release
Source archives are hosted on GitHub. The button below resolves the current latest release automatically. PyAdminer remains free and open source for everyone to use and modify under the MIT License.