Adminer
Database management in a single PHP file·adminer.org
Adminer is a database management tool distributed as a single PHP file that runs on a web server and is accessed through a browser. It supports MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL, and Oracle natively, with additional database systems supported via plugins (e.g. Elasticsearch, MongoDB, Redis, Firebird, ClickHouse). It provides a web interface for managing database structure, data, users, permissions, and running SQL commands.
What it's for
Features 27
- Add and drop tables and columns
- Alter column type, collation, comment and default values
- Alter table names, engine, collation, auto_increment and comments
- Connect to a database server with username and password
- Create, alter and drop triggers
- Create, alter, drop and call stored procedures and functions
- Create, alter, drop and link foreign keys
- Create, alter, drop and search indexes including fulltext
- Create, alter, drop and select from views
- Customizable skins/themes
- Display and manage users and rights
- Execute SQL commands from a text field or file
- Export table structure, data, views, routines, and databases to SQL or CSV
- Insert, update and delete records
- List fields, indexes, foreign keys and triggers of tables
- Manage events and table partitions (MySQL)
- Plugin system for extending functionality and supporting additional databases
- Print database schema connected by foreign keys
- Rate-limits login attempts to protect against brute-force attacks
- Search, aggregate, sort and limit table data
- Select or create a database
- Show and kill running processes
- Single-file PHP deployment
- Strict Content-Security-Policy (CSP) protection
- Support for blobs through file transfer
- Support for generated columns and check constraints
- Support for schemas, sequences and user types (PostgreSQL)
At a glance
No company, integrations, or compliance data published yet.
Pricing
Adminer is free for commercial and non-commercial use under the Apache License or GPL 2.
Free for commercial and non-commercial use (Apache License or GPL 2)