phpLiteAdmin
phpLiteAdmin is a web-based SQLite database administration tool written in PHP.
What phpLiteAdmin is
phpLiteAdmin is a web-based SQLite database administration tool written in PHP. Its single PHP source file can be placed on a server and opened in a browser without installation, and it supports SQLite 2 and SQLite 3. The interface can create and delete databases, manage tables, columns, indexes, and triggers, and browse or edit records. It also imports and exports tables, structure, indexes, and data in SQL and CSV formats. Additional tools include graphical record search, a free-form SQL query editor, and bar, pie, and line charts. The project describes a password-protected interface with a login screen and cookies; separate installations can use different passwords. It says the tool is available in 15 languages and supports custom CSS and community themes. Hosting requires PHP 5.2.4 or later and an enabled SQLite extension: PDO, SQLite3, or SQLiteDatabase. PDO and SQLite3 handle SQLite 3, while SQLiteDatabase handles SQLite 2; PDO and SQLite3 take precedence when multiple extensions are available. The software is free under GPL version 3 or later and is provided without warranty.
Good
- Supports both SQLite 2 and SQLite 3.
- Manages records, tables, columns, indexes, and triggers.
- Imports and exports SQL and CSV formats.
- Includes a SQL editor, search, and charts.
- Free under GPL version 3 or later.
Watch out
- Requires PHP 5.2.4 or later.
- Requires an enabled PHP SQLite extension.
- The software is provided without warranty.
Who it suits
phpLiteAdmin suits people who want to administer SQLite databases through a browser on a PHP server. It requires an enabled SQLite extension and is self-hosted.
Verdict
phpLiteAdmin brings database management, queries, imports, exports, and charts into a browser-based interface. Before using it, check that the server meets its PHP and SQLite extension requirements.
Plans and prices
From phpLiteAdmin's own pricing page, checked 9 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| phpLiteAdmin | Free | PHP server · PDO, SQLite3, or SQLiteDatabase extension |
The facts
Each one read from phpLiteAdmin's own pages, with the date it was checked.
What it does
- Authentication
- The README describes a password-protected interface with a login screen and cookies, and says multiple installations can use different passwords.checked 9 Oct 2026
- Compatibility release
- The download page lists stable version 1.9.8.2 and says versions 1.9.8.1 and 1.9.8.2 fix compatibility issues with PHP versions below 5.4.0 and PHP 7.3.9.checked 9 Oct 2026
- Database management
- It can create and delete databases, manage tables and columns, browse and edit records, and manage indexes and triggers.checked 9 Oct 2026
- Database support
- It supports SQLite 3 and SQLite 2 databases.checked 9 Oct 2026
- Deployment
- The tool consists of a single PHP source file that can be placed on a server and opened in a browser without installation.checked 9 Oct 2026
- Development build
- The maker's download page says development builds are updated automatically from the Git repository and are not tested as thoroughly as stable versions.checked 9 Oct 2026
- Import and export
- It can import and export tables, structure, indexes, and data in SQL and CSV formats.checked 9 Oct 2026
- Languages and themes
- The project README says it is available in 15 languages and supports custom CSS themes and community themes.checked 9 Oct 2026
- License
- The project README identifies the license as GNU GPL version 3 or, at the user's option, any later version, and provides the software without warranty.checked 9 Oct 2026
- Other software
- The download page says phpLiteAdmin is included in MAMP and available as an app for AMPPS, and is included in phpwin for iOS.checked 9 Oct 2026
- Purpose
- phpLiteAdmin is a web-based SQLite database administration tool written in PHP.checked 9 Oct 2026
- Queries and charts
- It provides a graphical record search, a free-form SQL query editor, and bar, pie, and line charts.checked 9 Oct 2026
- Requirements
- It requires a server with PHP 5.2.4 or later and at least one enabled PHP SQLite extension: PDO, SQLite3, or SQLiteDatabase.checked 9 Oct 2026
- SQLite extension behavior
- PDO and SQLite3 handle SQLite 3, while SQLiteDatabase handles SQLite 2; when multiple extensions are available, PDO and SQLite3 take precedence.checked 9 Oct 2026
- Support
- The project README directs users to its wiki and discussion group for help and to its issue tracker to report bugs.checked 9 Oct 2026
Alternatives to phpLiteAdmin
- 1
IBM Db2
Free planWebAPILinuxSelf-hosted7.4From $630 a month - 2
Neo4j
Free planSelf-hosted7.0From $65 a month - 3
ClusterControl
Free planWebAPILinuxSelf-hosted6.8From €250 a month - 4
YugabyteDB Anywhere
Free planWebAPILinuxSelf-hosted6.5Free plan - 5
DbNinja
Free planWebLinuxmacOSSelf-hosted6.4Free plan - 6
Oracle Maestro
Windows6.4$129 one-time