phpLiteAdmin
phpliteadmin.org
- Free plan
- Web
- iPhone and iPad
- Self-hosted
What phpLiteAdmin is
phpLiteAdmin is a free, open-source web tool for administering SQLite databases, written in PHP. It supports SQLite 2 and SQLite 3, and its single PHP source file can be placed on a server and opened in a browser without a separate installation. It can create and delete databases, manage tables, columns, indexes, and triggers, and let users browse or edit records. Import and export cover tables, database structure, indexes, and data in SQL and CSV formats. The tool also provides graphical record search, a free-form SQL editor, and bar, pie, and line charts. Its password-protected interface supports separate passwords for multiple installations. The project says it is available in 15 languages and supports custom CSS and community themes. Hosting requires PHP 5.2.4 or later and at least one SQLite extension: PDO, SQLite3, or SQLiteDatabase. PDO and SQLite3 work with SQLite 3, while SQLiteDatabase handles SQLite 2; PDO and SQLite3 take precedence if multiple extensions are available. The project identifies its license as GNU GPL version 3 or later and provides the software without warranty.
Who it suits
phpLiteAdmin suits people who need browser-based administration for SQLite databases on a PHP server. It is relevant when self-hosting and configuring the required PHP SQLite extension are acceptable.
Good to know, and what to watch
- Free and open source under GPL version 3 or later
- Supports both SQLite 2 and SQLite 3
- Imports and exports SQL and CSV
- Includes a query editor and charts
- Requires PHP 5.2.4 or later
- Requires an enabled SQLite extension
- Does not provide automated provisioning or high availability management
Plans
Every plan and pricephpLiteAdmin
Open source
The verdict
phpLiteAdmin offers database administration in a compact, self-hosted PHP tool, with import, export, query, and chart features. Its fit depends on having the required PHP and SQLite extension setup.
What the maker publishes
- Authentication
- The README describes a password-protected interface with a login screen and cookies, and says multiple installations can use different passwords. source
- 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. source
- Database management
- It can create and delete databases, manage tables and columns, browse and edit records, and manage indexes and triggers. source
- Database support
- It supports SQLite 3 and SQLite 2 databases. source
- Deployment
- The tool consists of a single PHP source file that can be placed on a server and opened in a browser without installation. source
- 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. source
- Import and export
- It can import and export tables, structure, indexes, and data in SQL and CSV formats. source
- Languages and themes
- The project README says it is available in 15 languages and supports custom CSS themes and community themes. source
- 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. source
- 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. source
- Purpose
- phpLiteAdmin is a web-based SQLite database administration tool written in PHP. source
- Queries and charts
- It provides a graphical record search, a free-form SQL query editor, and bar, pie, and line charts. source
- Requirements
- It requires a server with PHP 5.2.4 or later and at least one enabled PHP SQLite extension: PDO, SQLite3, or SQLiteDatabase. source
- SQLite extension behavior
- PDO and SQLite3 handle SQLite 3, while SQLiteDatabase handles SQLite 2; when multiple extensions are available, PDO and SQLite3 take precedence. source
- Support
- The project README directs users to its wiki and discussion group for help and to its issue tracker to report bugs. source
Checked against the maker's pages on 9 Oct 2026.