Adminer is unclaimed —
Adminer
Database management in a single PHP file·adminer.org
Free · Open source See pricing ↓
Adminer is a database management tool distributed as a single PHP file that you upload to a web server. It provides a browser-based interface for connecting to and managing MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle and CockroachDB databases, with support for additional systems such as MongoDB, Redis, Elasticsearch, Firebird and ClickHouse via plugins. It supports full database administration including tables, views, indexes, foreign keys, triggers, stored procedures, users/rights, and SQL execution.
What it's for
Connect to a database server with username and passwordSelect an existing database or create a new oneList fields, indexes, foreign keys and triggers of a tableChange name, engine, collation, auto_increment and comment of a tableAlter name, type, collation, comment and default values of columnsAdd and drop tables and columnsCreate, alter, drop and search by indexes including fulltextCreate, alter, drop and link lists by foreign keysCreate, alter, drop and select from viewsCreate, alter, drop and call stored procedures and functionsCreate, alter and drop triggersList data in tables with search, aggregate, sort and limit resultsInsert new records, update and delete existing onesExecute any SQL command from a text field or a fileExport table structure, data, views, routines, databases to SQL or CSVPrint database schema connected by foreign keysShow processes and kill themDisplay users and rights and change themManage events and table partitions (MySQL 5.1)
Features 20
- Add and drop tables and columns
- Alter table names, types, collations, comments and default values
- 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 lists by foreign keys
- Create, alter, drop and search by indexes including fulltext
- Create, alter, drop and select from views
- Display and change users and rights
- Display variables with links to documentation
- Execute any SQL command from a text field or file
- Export table structure, data, views, routines, databases to SQL or CSV
- Extensive customization options via plugins and skins
- Insert, update and delete records
- List data with search, aggregate, sort and limit
- List fields, indexes, foreign keys and triggers of tables
- Print database schema connected by foreign keys
- Show processes and kill them
- Single PHP file deployment
- Support for all data types, blobs via file transfer
At a glance
free tieropen sourceself-hostable
TypeWeb app
DeploymentSelf-hosted
PlatformsWeb
LanguagesEnglish
Integrations
FirebirdMongoDBIGDBRedisMariaDBClickHouseSQLiteCockroachDBMySQLSimpleDBElasticsearchOracleIMAPPostgreSQLMS SQL
Pricing
Adminer is free for commercial and non-commercial use, available under the Apache License or GPL 2.
FreeFree
Distributed under Apache License or GPL 2.
Similar apps
phpMyAdminOpen sourceBringing MySQL administration to the webPriceFreeTry freeFree planRuns onWebFeatures15
DbGateOpen sourceSQL & noSQL database managerPrice$3.9–$15/moTry freeFree planRuns onWeb · Windows +2Features18
pgAdminOpen sourceThe Most Popular PostgreSQL Admin ToolPriceNot statedTry freeFree planRuns onWeb · Windows +2Features18
CloudBeaverSelf-hostableSecure browser-based data managementPriceNot statedTry free14-day trialRuns onWebFeatures20
MathesarOpen sourceSecure, spreadsheet-like tool for Postgres dataPriceNot statedTry freeFree planRuns onWebFeatures10
myDBRSelf-hostablemyDBR – Web Reporting for MySQL, MariaDB & SQL ServerPriceFrom €13.25/moTry freeFree planRuns onWeb · iOS +1Features14