Please help to keep this list up to date by: {linebreak} -- adding your comments on usability _[in italics]_ to the end of the desriptions -- filling in licence details -- {linebreak} -- highlighting entries according to the key -- adding any new programs you discover -- fixing bad links -- {linebreak} {linebreak} Other possibilities to look into and add to the list: {linebreak} * Kexi (part of KOffice) {linebreak} * OpenOffice.org v2 {linebreak} {linebreak} {linebreak} _Key:_ {linebreak} _- Programs highlighted in bright green below, are *recommended* and are under active development_ {linebreak} _- Programs highlighted in pale green below, are under active development_ {linebreak} _- Programs highlighted in pale red below, appear NOT to be under active development_ {linebreak} _- Licenses: commercial / freeware(closed source) / public domain / GPL / etc.._ {linebreak} {linebreak} {linebreak} *Multi-OS*
_Name_ _Description_ _Licence_
{link: http://sqlitebrowser.sourceforge.net SQLiteDatabaseBrowser} SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. Version 1.2 was updated to support SQLite 3.x databases. {linebreak} _[fairly simplistic, works but slightly buggy, awkward data entry, single file executable]_ public domain
dgSQLite A tcl/tk based GUI SQLite-Database Client which allows to import, export and query sqlite-databases. Available as kit/exe for Linux/Windows/OSF1. Other platforms can be added easily on request.{linebreak} _[download location unknown]_ ?
{link: http://sqlabs.net?sqlitemanager SQLiteManager} a commercial SQLite database manager that runs on Windows, Mac OS X, and Mac OS Classic. commercial
{link: http://bobmanc.home.comcast.net/sqlitecc.html SQLiteCC} SQLite Control Center is a visual tool for working on SQLite database files similar to MySQL CC. ?
{link: http://home.student.uu.se/frax0795/ SQLiteCC for SQLite3} Same as SQLiteCC but for SQLite3 database files ?
{link: http://reddog.s35.xrea.com/wiki/TkSQLite.html TkSQLite} A graphical database manager for SQLite implemented by Tcl/Tk. BSD
*PHP*
_Name_ _Description_ _Licence_
{link: http://pear.php.net/package/DB_Sqlite_Tools DB_SQLite_Tools} PHP PEAR official OO extension to manage and backup Sqlite Databases under PHP 5. BSD
{link: https://sourceforge.net/projects/sqlitemanager/ SQLiteManager} SQLiteManager is a multilingual web based tool to manage SQLite databases. The programming language used is PHP4 but it works fine with PHP5. Works just as well on a Linux as on Windows platform. This project is in course of developpement, but is already very functional. GNU/GPL
{link: http://code.jenseng.com/db/ SQLiteDB} A PHP class for working with SQLite databases. Supports ALTER TABLE statements. Public Domain
{link: https://sourceforge.net/projects/sqlitewebadmin/ SQLiteWebAdmin} SQLiteWebAdmin is a webbased administration tool for SQLite Databases. It is written in PHP and requires PHP 4.x with SQLite extension or PHP 5. It provides management of multiple sqlite Databases. Artistic License
{link: http://www.webtrickscentral.com/wtcSQLite.php wtcSQLite} Web Tricks Central SQLite Administration Tool is an administration tool written in PHP. Create, edit, delete tables, data, indexes, triggers, views and more without knowing any SQL at all! On top of that, you may run 'ALTER TABLE' statements anywhere in wtcSQLite LGPL
{link: http://www.zend.com/apps.php?id=967&single=1 DCSQLite} A Flash MX2004 front-end based on Database Connector System to manage SQLite database files with PHP5 interaction. GPL
{link: http://sqlitefront.sourceforge.net/ SQLiteFront} a tool to manage SQLite databases like phpMyAdmin is to MySQL. Written in pure PHP5 using PHP5 DOM XML, XSL and SQLite extensions GPL
{link: http://www.phpSQLiteAdmin.com phpSQLiteAdmin} (1) PHP based administration tool for SQLite in the same style as phpMyAdmin. Requires PHP 4.3+. GPL. GPL
{link: http://phpsqliteadmin.sourceforge.net phpSQLiteAdmin} (2) Web interface for the administration of SQLite databases. GPL
*Windows*
_Name_ _Description_ _Licence_
SQLitePlus Database Manager GUI tool used to create, view and edit SQLite databases, similar to MS Query Analyzer
  • Open multiple databases at the same time
  • Open unlimited Query windows
  • View schema info (eg. field types)
  • Create Stored Scripts
  • Execute highlighted query text or all text (like MS Query Analyzer) - invaluable for working-out complex queries
Commercial - Download free trial
{link: http://www.vive.net/products/sqlpro.htm SqlPro SQL Editor } {link:http://www.vive.net/products/sqlpro.htm SqlPro} SQL Editor is a visual database management and development tool for multiple databases with Explorer interface. Supports Oracle, MySql, Microsoft SQL Server, Microsoft Access and Sqlite 3. Commercial (Free trial)
{link: http://www.monkeyshinez.net/SQLiteQA/ SQLite Query Analyzer } Sqlite Query Analyzer is a query analyzer tool for {link: http://sourceforge.net/projects/adodotnetsqlite ADO.NET Data Provider for SQLite}. The current version supports sqlite version 2 & 3. It can be described as a visual query builder, and it is written in C#. GNU/GPL
{link: http://www.sharpplus.com/ Sqlite Developer } Sqlite3 Database Manager supports table, view & trigger edit. visual query builder, export/import data as csv,sql,etc, unicode support, etc. Commercial
{link: http://www.visualsqlite.com/ Visual SQLite} GUI application for SQLite 3 Databases. Visually control tables, indexes and triggers. Data editing, modify pragmas, SQL queries executions and more... Commercial. 30 day trial available.
{link: http://www.yunqa.de/delphi/sqlitespy/ SQLite Spy} A freeware, graphical database manager for SQLite 3 databases. Features full Unicode input and display; REGEXP keyword with Perl 5.8 regular expression syntax; a schema tree showing tables, views, columns, indexes, and triggers; multiple tabbed SQL edits and query results; type-colored data grids; time measurement; outstanding performance and low memory consumption. {link: http://www.yunqa.de/delphi/sqlitespy/ SQLite Spy} is realized as a fully self-contained, single-file executable, requires no installation and runs on plain Win9X, WinME, WinNT, Win2K, and WinXP with no dependencies. Data changes must be enacted through SQL statements (no cell based editing). Freeware for personal and educational use
{link: http://www.vieka.com/esql.htm eSQL} A FREE sqlite database and database manager from Vieka. Provide consistent interface on Windows and Windows Mobile devices such as Pocket PC and Microsoft Smartphone. Freeware (Windows) / Commercial with exceptions (Windows CE)
{link: http://www.arkesystems.com/downloads.aspx Another SQLite Explorer} A Free open source SQLite Explorer provided by Arke Systems. Binary and Source zips availabla. Enjoy! Open Source
{link: http://www.dbtools.com.br DBTools Manager} Freeware Win32 application to manage MySQL, PostgreSQL, XBase Tables and SQLite databases. Supports managing all objects in the database, create queries in visual mode, import/export data from MSAccess, ODBC, text files, Paradox, DBF Tables and generate PHP scripts. The list of features is just too big. Enterprise Edition with powerful features is available:
  • Database Comparer
  • Task Builder
  • Blob and Image Viewer
  • Data Migration Wizard
  • Database Documenter
  • Diagram Designer
  • Report and Forms Builders
  • And Much More
Commercial (Trial and Freeware available)
{link: http://republika.pl/roed/ LiteQuery} Another GUI tool to create view and edit SQLite databases. Discontinued by author. GPL
{link: http://www.kraslabs.com/sqlite_analyzer.html SQLite Analyzer} A comprehensive SQLite database processor. Edit or modify SQLite data visually without any risk of losing your data. Commercial. 30 day trial available.
{link: http://www.mygenerationsoftware.com/ MyGeneration} a freeware template based code generation tool that supports SQLite and many other databases. With this tool, you can generate a middle tier for your database in practically any language (Needs .NET 1.1 or higher) Freeware
{link: http://www.caligari.sakh.com/sql/ Caligari's SQLite Admin Tool} SQLite admin tool. Have source too. GPL
{link: http://www.singular.gr/sqlite/ SQLite 3 Explorer} A great GUI tool written by Mike Cariotoglou. Freeware SQLite admin tool. ?
{link: http://www.simios.org/projetos/sqlitesharpadmin SQLite Sharp Admin} A tool written by Evandro Junior (needs .NET Framework 2). ?
{link: http://sqliteadmin.orbmu2k.de/ SQLite Administrator} SQLite Administrator is a powerful tool if you easily want to create, design or administrate SQLite database files. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator. Freeware
*Linux*
_Name_ _Description_ _Licence_
{link: http://knoda.sourceforge.net knoda} a database frontend for KDE. Its driver concept allows a uniform connection to different database servers (Mysql , Postgresql , SQLite or ODBC). GPL
{link: http://noprianto.com/index.php?mod=modules/sqliteweb/index.php sqliteweb} Very small and simple web-based (CGI) sqlite administrator. Developed totally using shell script, with help from GNU coreutils and sed. BSD
{link: http://sqlitetools.com Commando} Auto-completion for table and column names. Commercial. 10 day trial available.