About Adminer
Adminer is a lightweight database management tool delivered as a single PHP file. It works with several popular database systems, in a browser or as a desktop app.
What it does
You can browse tables, edit records, run SQL queries and manage structure such as indexes, foreign keys, views and triggers. Export and import are supported too. Because it is one file, setup is quick: upload it to a server, or run the desktop build on your computer.
Key features
- Works with MySQL, PostgreSQL, SQLite, MS SQL and Oracle
- Manage tables, indexes, foreign keys and triggers
- Search, sort and edit table data
- Export table structure and data to SQL
- Plugins for other database types
Who it's for
Developers and site owners who need a simple admin tool without installing a large application. It is common on small web projects and shared hosting.
Pricing and good to know
Adminer is open source and free to download. Donations are accepted through GitHub, PayPal and Patreon. The Windows, macOS and Linux builds include PHP, so they need no separate web server. Restrict access when you place it on a public server.
Highlights
- Works with MySQL, PostgreSQL, SQLite, MS SQL and Oracle
- Manage tables, indexes, foreign keys and triggers
- Search, sort and edit table data
- Export table structure and data to SQL
- Plugins for other database types
