Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

phpLiteAdmin

phpliteadmin.org

  • Free plan
  • Web
  • iPhone and iPad
  • Self-hosted
7.5 Club score Visit phpliteadmin.org

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

phpLiteAdmin

Free

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.