Skip to content
SPECIFICTION
Get listed

phpLiteAdmin

phpliteadmin.org

Free plan WebiOSSelf-hosted
Visit phpliteadmin.org
Spec score 7.7 #12 of 34 in Database Administration Tools

What it is

phpLiteAdmin is a free, web-based SQLite administration tool written in PHP. Its single PHP source file can be placed on a server and opened in a browser without installation, supporting SQLite 2 and SQLite 3 databases. It can create and delete databases, manage tables and columns, browse and edit records, and manage indexes and triggers. Import and export cover tables, structure, indexes, and data in SQL and CSV formats. Other 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 login cookies and separate passwords for different installations. It says the interface is available in 15 languages and supports custom and community CSS themes. Hosting requires PHP 5.2.4 or later and an enabled PDO, SQLite3, or SQLiteDatabase extension. PDO and SQLite3 handle SQLite 3, while SQLiteDatabase handles SQLite 2. The stable download is version 1.9.8.2; development builds are updated automatically and tested less thoroughly. The project offers the software under GNU GPL version 3 or any later version, without warranty.

Spec sheet

Purpose
phpLiteAdmin is a web-based SQLite database administration tool written in PHP.Read 9 Oct 2026 · github.com
Deployment
The tool consists of a single PHP source file that can be placed on a server and opened in a browser without installation.Read 9 Oct 2026 · github.com
Support
The project README directs users to its wiki and discussion group for help and to its issue tracker to report bugs.Read 9 Oct 2026 · github.com
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.Read 9 Oct 2026 · github.com
Authentication
The README describes a password-protected interface with a login screen and cookies, and says multiple installations can use different passwords.Read 9 Oct 2026 · github.com
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.Read 9 Oct 2026 · phpliteadmin.org
Database management
It can create and delete databases, manage tables and columns, browse and edit records, and manage indexes and triggers.Read 9 Oct 2026 · github.com
Database support
It supports SQLite 3 and SQLite 2 databases.Read 9 Oct 2026 · github.com
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.Read 9 Oct 2026 · phpliteadmin.org
Import and export
It can import and export tables, structure, indexes, and data in SQL and CSV formats.Read 9 Oct 2026 · github.com
Languages and themes
The project README says it is available in 15 languages and supports custom CSS themes and community themes.Read 9 Oct 2026 · github.com
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.Read 9 Oct 2026 · phpliteadmin.org
Queries and charts
It provides a graphical record search, a free-form SQL query editor, and bar, pie, and line charts.Read 9 Oct 2026 · github.com
Requirements
It requires a server with PHP 5.2.4 or later and at least one enabled PHP SQLite extension: PDO, SQLite3, or SQLiteDatabase.Read 9 Oct 2026 · github.com
SQLite extension behavior
PDO and SQLite3 handle SQLite 3, while SQLiteDatabase handles SQLite 2; when multiple extensions are available, PDO and SQLite3 take precedence.Read 9 Oct 2026 · demo.phpliteadmin.org

Plans and prices

phpLiteAdmin Free PHP server · PDO, SQLite3, or SQLiteDatabase extension Read 9 Oct 2026 · github.com

Every phpLiteAdmin plan and price →

Strong points and limits

Strong points

  • Single PHP file needs no installation
  • Supports SQLite 2 and SQLite 3
  • SQL and CSV import and export
  • Password-protected interface with themes
  • Free under GNU GPL version 3 or later

Limits

  • Requires PHP 5.2.4 or later
  • Needs an enabled SQLite extension
  • Self-hosted deployment is required
  • Software is provided without warranty

Who it suits

It suits administrators who need browser-based management of SQLite databases on a self-hosted PHP server. It is also useful for users wanting SQL and CSV import, queries, charts, and record editing.

Verdict

phpLiteAdmin offers a compact, self-hosted browser interface for SQLite administration, including records, schema, queries, imports, exports, and charts. Its PHP and extension requirements should be checked before deployment.

Where Specifiction places it

Alternatives to phpLiteAdminAll alternatives →