Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

Active and Supported

Web Win. Lin. Misc. Name Description Licence / Price Trial Version


phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite2 and SQLite3. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single 100KB source file that is dropped into a directory on a server and then visited in a browser. Setup is as simple as specifying which databases to manage and creating a password. The available operations, feature set, interface, and user experience is comparable to that of phpMyAdmin for MySQL. If you know how to use phpMyAdmin, then you know how to use phpLiteAdmin.

  • Lightweight - consists of a single source file for portability and quick installation
  • Supports SQLite3 with backwards-compatibility for SQLite2
  • Add, delete, rename, empty, and drop tables
  • Browse, add, edit, and delete records
  • Add, delete, and edit table columns
  • Manage table indexes
  • Import and export table structure and data
  • Graphical search tool to find records based on specified field values
  • Create and run your own custom SQL queries in the free-form query editor/builder
  • Secure password-protected interface with login screen
  • Specify and manage an unlimited number of databases
  • Design your own theme using CSS or install a pre-made theme from the community
  • All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases
Open Source (free) -


SQLite Maestro 11.3
(updated 2011/03/10)
SQLite Maestro is a full-featured SQLite admin tool with state-of-the-art graphical user interface that allows you to complete all the database management, control and development tasks easy and fast. SQLite Maestro provides a rich set of amazing tools to make SQLite even easier than before.
Key Features:
  • Support for all SQLite versions 2.8 and 3.x.y
  • Working with remote SQLite databases via HTTP tunnel
  • Transparent database encryption
  • FTS3 and FTS4 support
  • Easy database object management
  • Database Designer
  • Visual Query Builder with support for subqueries and UNIONS
  • Data management: editing, grouping, sorting and filtering abilities
  • Unicode support
  • Handy SQL Editor with code folding and multi-threading
  • Data export/import to/from the most popular formats including Excel, Access, HTML, XML, and CSV.
  • Powerful BLOB Viewer/Editor

The latest version (11.3) was released at March 10, 2011. It comes with support for full-text search extensions, data import from ODBC data sources, and other useful things (read full press-release).

SQLite Maestro is developed by SQL Maestro Group that also offers complete database management tools for MySQL, Microsoft SQL Server, Oracle, DB2, SQL Anywhere, PostgreSQL, Firebird and MaxDB.

From $79 30 days


SQLite2009 Pro Enterprise Manager
(Last Updated 2011.03.05)
[SQLite v3.7.5]


SQLite2009 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases. Not only that, you can using this tool for learning and working with LUA programming language.

  • Encryption Method is now compatible with wxSQLite3 (AES-128 bits) and SQLite3 ADO.NET Provider (RSA-MS Crypt) (New)
  • Syntax Highlight (New)
  • Hex Viewer (New)
  • Dump database to SQL file format
  • Unicode Support
  • Blob/Image viewer
  • Built-in FTS3 Extention
  • Built-in LUA Programming Language
  • Encrypted database support
  • Export recordset into excel, csv, xml and html format
  • Import data from Ms Access, MS SQL server and MySQL server
  • Includes Additional sqlite3 function (compress, decompress, crc32, md5, lua_exec, etc)
  • Includes the user-contributed extension-functions from
    The new functions are: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi, replicate, charindex, leftstr, rightstr, reverse, proper, padl, padr, padc, strfilter, and aggregates stdev, variance, mode, median, lower_quartile, upper_quartile.
  • Visual Query Builder
Included SQLite2010 Pro ODBC Driver,the first free ODBC driver which have supported for accessing encrypted database that was build with SQLite2009 Pro Enterprise Manager (includes with vb6 sample project).


Adminer is a database management tool written in PHP. It is available in a single file and despite its small size (under 300 KB) it has an interesting set of features. It works with MySQL, SQLite 2 and 3, PostgreSQL, MS SQL and Oracle and it is available in 16 languages. All SQLite features are supported:

  • Select an existing database or create a new one
  • List, add and drop tables and columns, change name, auto_increment of table
  • List, create, alter and drop indexes
  • List, create and links by foreign keys
  • Create, alter, drop and select from views
  • Create, alter, drop and call stored procedures and functions
  • List, create, alter and drop triggers
  • List data in tables with search, aggregate, sort and limit results
  • Insert new records, update and delete the existing ones
  • Execute any SQL command from a text field or a file (with syntax highlighting)
  • Export table structure, data, views, routines, databases to SQL or CSV
  • Print database schema connected by foreign keys
  • Display variables and status with links to documentation

Pleasant user interface is one of the top priorities of development. Easy creation of foreign keys, inline or bulk editing are features not available in much other tools.

GPL or Apache No Limit


Database Master 3
(Updated 30.10.2010)
Database Master is a modern, powerful and innovative Oracle, IBM DB2, Ingres, SQL Server, MySQL, PostgreSQL, FireBird, MongoDB, SQLite, EffiProz, ODBC, OleDB and XML File client application with a consistent, modern and easy-to-use interface
that simplifies querying, editing, visualizing, managing, designing, reporting and constructing relational and schema free databases.

Main Features:
  • Multiple Database Connections
  • Table Manager: Create/Edit/Delete Tables
  • View Manager: Create/Edit/Delete Views
  • Procedure Manager: Create/Edit/Delete Stored Procedures
  • Index Manager: Create/Edit/Delete Indexes
  • Column Manager: Create/Edit/Delete Columns
  • Trigger Manager: Create/Edit/Delete Table Triggers
  • Collection Manager: Create/Delete MongoDB Collections
  • Relations View & ER Modelling
  • Reports
  • Host Information (Settings, Process List)
  • User Management
  • Multiple Query Output
  • Object Properties
  • Data Visualizer: Text, Image and Chart Visualizer
  • Table Data Editor: Create, edit or delete data records.
  • Database Maintenance
  • Powerful SQL Query Editor: Code Highlighting and IntelliSense
  • Visual SQL Query Builder
  • Table/View Data Export (XML, CSV, Excel, Word, Html, OpenOffice, XPS, dBase, PNG, PDF and more...)
  • SQL Script Export (Database, Table, View and Procedure Structure)
  • CSV Data Import: Imports any size CSV file.
  • XML File Import
  • Bulk SQL Import: Imports any size SQL file.
  • Pack&Go Data Export/Import
  • Search Engine: Full text or Fuzzy search
  • Code Factory: Generates Java, C# Code
  • MongoDB: GridFS, MapReduce, JSON Query support
  • Unicode (UTF-8 and UTF-16) Support
Freeware(Limited)/Full Version-$39 Trial 30 days /After Freeware(Limited)


SQLite Designer

SQLite Designer is a freeware tool to Design easy database and linq to sqlite generator tool

GNU No Limit


AnySQL Maestro 10.7
(updated Jul 6, 2010)
AnySQL Maestro is the premier multi-purpose tool for database management, control and development. It allows you to administer any database engine accessible via ODBC driver or OLE DB provider (SQLite, MySQL, Oracle, SQL Server, Access, and so on). AnySQL Maestro has been successfully tested with the SQLite ODBC driver and all the latest SQLite versions.
Key Features:
  • Support of any database engine
  • Database Designer
  • Data management: editing, grouping, sorting and filtering abilities
  • Handy SQL Editor with code folding and multi-threading
  • Visual Query Builder
  • Data export/import to/from the most popular formats
  • Powerful BLOB Viewer/Editor

The application also comes with a set of powerful tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.

The latest version (10.7) features database profile management extensions, updated Script Runner, improved Data Analysis and Data Import tools, and some other useful things (full press-release).

(Professional edition
starts from $79)
No limit/30 days

(New 2011/04/02)


SQLVue 4.0.1 is an elegant IDE for SQLite developers. Some of its features include:
  • Full-featured SQL Editor with syntax highlighting, autocomplete (for keywords and full DB schema), parenthesis matching
  • Multiple tab display
  • Visual display of table columns, data, indexing and triggers
  • Supports SQLite 3.7.3
$19 SQLVue Lite (free)


SharpPlus Sqlite Developer
(Update 2010/03/21)


SQLite Developer is a powerful database manager that will manage sqlite3 database!

  • Power SQL Editor with syntax highlight, autocomplete(keyword, schema), live sql syntax check, parenthesis matching, unicode support
  • Sqlite SQL Formatter
  • Unicode Support
  • Custom Data Type Mapping
  • Execute multiple sql seperated by semi colon.
  • Execute sql script with parameters.
  • Visual Query Builder
  • Visual schema management with foreign key support
  • Test Data Generator(New)
  • View and edit field as Text, Hex, HTML or Image.
  • Master Detail Browser.
  • Attach, Detach databases.
  • RTree and ICU support(with 300+ new unicode collation).
  • Import data from CSV, SQLite Database and ADO DataSource
  • Export data as csv, sql, excel, word, html, xml
  • Extract db schema and data.
  • Backup and restore Database.
  • Encrypt and decrypt database compatible with System.SQLite.Data.
  • Support loadable extension and virtual table.
  • Multi language supports(english, japanese, simple chinese)
$29 for a non-commercial license,
$49 for a business one
30 days


(Last Updated 2010-02-18)

DataPro is visual cross-platform database tool with Explorer like interface designed for database management, database development and database conversion. Transfer database objects beetwen different databases and servers, convert tables schema and migrate data from one database type to another.
Supported databases:

  • SQLite
  • MySQL
  • Oracle
  • PostgreSQL
  • Microsoft SQL Server
  • Microsoft Access

No other software to install. DataPro comes with full set of drivers.


$99 One record upload/download/transfer

x Base

Base is an application for creating, designing, editing and browsing SQLite 3 database files. It's a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need.

Trial version

£10 Trial limited to 15 minute sessions and only 5 rows from custom SQL queries


DataMate Connect

Database exploration, manipulation and automation tool. Connect to almost any database and immediately begin exploring and manipulating your data. Supports SQLite and all major databases, including SQL Server, SQL Server Compact, Oracle, etc. etc.

  • Open multiple database connections at once
  • Easy Drag/Drop table copy - to the same database or to any other
  • Easy CSV data import and export facilities (using wizards)
  • Open unlimited Query windows
  • Superior Data grouping DataGrid component - easily group on any column, and any number of columns
  • Built-in .NET Scripting features - create scripts to do repetitive tasks
  • Connect to any OLEDB/ODBC remote database via webserver (either PHP or ASP)
  • Execute highlighted query text
  • Extensible. Create your own .NET User Controls to be added into DataMate. For example, a component to graph data from SQL queries in DataMate. Write any number of .NET components to be loaded into DataMate by your users.
  • And more!

Download free evaluation version

$200 Row SELECT limit until licensed


SQLitePlus Database Explorer

Top selling GUI tool used to create, view and edit SQLite databases. SQLitePlus features built-in scripting capability - something NO OTHER PRODUCT has. Create simple or complex automation scripts, and generate XML documents with PHP-like script files using VbScript or Javascript.

  • Database Encryption support
  • Open multiple databases at once
  • Support for FTS1, FTS2 and FTS3
  • Additional Built-in SQLite3 functions (contains, encrypt, compress, etc.)
  • Open unlimited Query windows
  • Import/export dataset to csv in various formats (UTF-8, UTF-16 and CodePage
  • View/edit data and table schema
  • Blob/binary data viewer
  • Execute highlighted query text
  • Companion COM DLL wrapper for use in your own applications
  • Built-in Scripting features (like stored procedures, except uses VBScript or JScript)
  • And more!

Download free evaluation version

$30 10 row limit until licensed


DBMaster Beta 1
(updated 2008/07/17)

DBMaster is a tool for working with multiple database servers and multiple databases. Sometimes it is much easier to work using a set of commands than working with wizards. DBMaster has a command language which can be used for copying Tables, Views, etc from one database to another. It supports SQLite, Firebird and Interbase


DeZign for Databases
(updated 2008/10/21)

DeZign for Databases is a database modeling tool supporting SQLite and other databases. Create, design and document SQLite databases. You can import existing SQLite databases (and making a data model out of it) by importing a SQLite SQL script.

$195 30 Day evaluation version


(Last Updated 2008-02-29)

Image2db is a utility for uploading images to the database and downloading content of BLOB fields. It allows you to insert any number of binary or text files into the database table.
Supported databases:

  • SQLite
  • MySQL
  • Oracle
  • PostgreSQL
  • Microsoft SQL Server
  • Microsoft Access


$29.95 One image upload / download
x x x x Bazdig

PHP SQL console/editor


  • unlimited history
  • history search
  • syntax coloring
  • schema browser
  • save queries as links (CTRL-D in Firefox)
  • save reports as HTML files (CTRL-S in Firefox)
  • save ALL your query history as an sqlite database
  • works with MySQL and sqlite (for now)

x x x Sqliteman
The best developer's and/or admin's GUI tool for Sqlite3 in the world. No joking here (or just a bit only) - it contains the most complette feature set of all tools available. And it's just the beginning...

Let's see little part of features:
- full alter table support
- blob preview
- 'populate table' tool (for testing databases)
- real NULL values handling
- import, export
- SQL editor
- schema browser and pragma editor
... and many many more very usefull features!
Try it! It's free and being improved every day for your comfort work with SQLite!
GPLv2/free -

x x
(Updated 2009-05-30, v0.3.0)
[SQLite v3.6.14.2]

A great GUI tool written by Fred Cailleau-Lepetit.
sources availables (French site).



SQLite 3 Explorer
(Updated 2007-11-29, v3.01)

A great GUI tool written by Mike Cariotoglou. Freeware SQLite admin tool.


x x x SQLiteStudio
(Update December 16th, 2010)


SQLiteStudio is an advanced, cross-platform SQLite database manager.

  • Intuitive MDI interface (see screenshots),
  • All SQLite3 and SQLite2 features wrapped witin simple GUI,
  • Cross-platform - runs on Windows, Linux, Solaris, FreeBSD, MacOSX and should work on other Unixes.,
  • Localizations, currently translated to:
    • English,
    • Polish,
    • German,
    • Spanish,
    • Italian,
    • Russian,
  • Exporting to various formats (SQL statements, CSV, HTML, XML),
  • Numerous additions, like advanced formatting code, history of queries executed in editor windows, custom SQL functions, populating tables, postponed commits, real-time syntax checking and smart syntax completion,
  • UTF-8 support,
  • skinnable (interface can look native for Windows 9x/XP, KDE, Mac OS X, or draw widgets to fit for other environments, like Gnome, WindowMaker, etc), Configurable colors, fonts and shortcuts.
  • Simple to start - just download binary distribution and run - no installation process is required, application is just a single file.
GPLv2/free -

x Kylix

(Update 19 Feruary 2009)


SQLcc is a completely different open source Database manager for SQLite3, with future plans for any SQL database. I've a plans to rewrite SQLcc into Python, so it becomes really multi platform. First steps can be seen here: SQLcc in Python ?

  • open source (BSD license) written in Delphi
  • claims to need only half the clicks, compared to the most user friendly db-manager
  • flat view of database, SQL-query and SQL-query result
  • can handle automatically most common image types, including PNG and animated GIF
  • Visual Query Builder
  • all SQL statements caused by clicking, drag&drop can be visualised, resulting in 3 learning levels
  • logging of all commands per database in a local storage
  • user templates
  • local storage of the settings of each database
Download SQLcc Installer (2MB)


open source,
(BSD license)


SmartDB for Sqlite 3.x
(Update 2007/02/21)


SmartDB for Sqlite 3.x provides msado like interface.
Complete source code also available at sourceforge
  • User friendly Interface
  • One click table view.
  • Execute Ad hoc Queries w/o leaving the interface.
  • Not a resource hungry app, loads faster
  • Used and tested by more then 200 users
Freeware No limit


Icequake - SQLite 3 Query Browser

SQLite 3 query browser written in DigitalMars D Language and DWT gui kit

  • Object Explorer;
  • Script Edit;
  • SQL Result Visual Display;
  • Table Visual Edit;
  • SQL Console;
  • ...;

Open Source / LGPL


Visual SQLite

GUI application for SQLite 3 Databases. Visually control tables, indexes and triggers. Data editing, modify pragmas, SQL queries executions, Export table data to Word, Excel, XML, CSV, HTML, and more...

$40 30 day



PlaneDisaster.NET PlaneDisaster.NET is a database browser for MS Access and SQLite.NET databases. It is written in C#.


Open Source (GPL)


SQLPro SQL Editor
(Last Updated 2010-02-26)

SQLPro SQL Editor is the best visual database management and development tool for multiple databases with Explorer interface and integrated SQL editor.
Supported databases:

  • SQLite
  • MySQL
  • Oracle
  • PostgreSQL
  • Microsoft SQL Server
  • Microsoft Access

No other software to install. SQLPro comes with full set of drivers.


$30 Popup reminder


Easy SQLite Manager
(Last Updated 2008-02-10)

Easy SQLite Manager
This version has support for:
* creating databases
* open existing database
* creating tables
* viewing database structure
* running SQL statements, including inserts and selects

$0 Freeish


Another SQLite Explorer

An open source SQLite 3 Explorer provided by a Software Development firm in Atlanta, Arke Systems.

Recently updated to support 3.3.7, with the SQLite Explorer you can create databases, work with existing databases, add/edit/delete tables.

  • Manage Multiple SQLite Databases
  • Unlimited SQL Query Windows
  • Create, Delete, Rename Tables
  • Create columns
  • Check DB Integrity
  • Ad Hoc SQL Queries

    Arke Systems SQLite Explorer also allows you to do adhoc queries against your SQLite DB. Can't directly edit data. Requires that you provide an email address. Very poor interface. Very limited. No screen shots on website.

    Binary and Source zips available. Enjoy!

  • Open Source


    PHP PEAR official OO extension to manage and backup Sqlite Databases under PHP 5.



    DBTools Manager

    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. 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, etc.

    $50 / free for non-commercial use 20 days


    eSQL for Windows

    A free sqlite database and database manager from Vieka. Provide consistent interface on Windows.


    x eSQL for Windows Mobile

    Sqlite database and database manager for Windows Mobile devices such as Pocket PC and Microsoft Smartphone.



    A database frontend for KDE. Its driver concept allows a uniform connection to different database servers (Mysql , Postgresql , SQLite or ODBC).


    x x x LiteMan

    SQLite3 database manager based on Qt4.


    x x

    Kexi is an integrated data management application. It can be used for creating database schemas, inserting data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects - tables, queries and forms - are stored in the database, making it easy to share data and design.


    x x

    Use SQLite 2.8.x to read single file SQLite databases under Linux. It's tied to OOo 1.1, does not support OOo 2.0 and was not updated since autumn 2004. As an alternative all OOo versions can interface with SQLite2 & 3 using the ODBC drivers from

    BSD / LGPL


    SQLite Expert Professional

    SQLite Expert Professional is a commercial tool that enables you to easily administer your SQLite3 databases. Restructure tables visually without losing existing data. Updated weekly with new features.

    Manage SQLite Databases
    • Manage Multiple SQLite Databases
    • Transparent Database Encryption compatible with System.Data.SQLite
    • Use external or internal SQLite3 library
    • View Database Schema
    • View and change PRAGMA values
    • Attach, Detach databases.
    • Unicode support
    • Supports custom file extensions like .db3 or .sqlite
    • Manage SQLite extensions
    • Unique ability to display functions and collations installed by each SQLite extension
    • Built-in FTS3 Extension
    • Built-in LUA and Pascal Script programming languages
    Manage SQLite objects
    • Table Manager: Create/Edit/Delete Tables
    • View Manager: Create/Edit/Delete Views
    • Index Manager: Create/Edit/Delete Indexes
    • Trigger Manager: Create/Edit/Delete Triggers
    • Foreign Key Manager: Create/Edit/Delete Foreign Keys
    • Constraint Manager: Create/Edit/Delete Unique and Check Constraints
    Execute SQL scripts
    • Execute multiple SQL separated by semicolon
    • Execute SQL scripts with parameters
    • Execute highlighted query text
    • SQL history
    • Syntax Highlighting
    • Visual Query Builder with support for subqueries and UNIONS
    • Generate SELECT, INSERT, DELETE and UPDATE statements based on the selected fields on the current table
    Data management
    • Editing, sorting and filtering abilities
    • Easy table copy between SQLite databases via drag/drop or clipboard
    • Image editor (supports BMP, JPEG, PNG, GIF and ICO)
    • Powerful BLOB Viewer/Editor
    • Custom Data Type Mapping
    • Generate random data
    Import and Export Data
    • Export data into Excel, CSV, XML and HTML formats
    • Import data from CSV, SQLite Database and ADO DataSource (MS Access, MS SQL Server or other)
    • Export database to SQL file format
    • Import SQL script
    $59 30 days


    SQLite Expert Personal

    SQLite Expert Personal is a freeware tool that enables you to easily administer your SQLite3 databases. Restructure tables and views visually without losing existing data. Execute SQL scripts, visually edit data in the grid, including BLOB and image fields.

    Web Win. Lin. Misc. Name Description Licence / Price Trial Version


    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.

    Free for non-commercial use


    SQLite Analyzer

    A comprehensive SQLite database processor. Edit or modify SQLite data visually without any risk of losing your data.

    $60 30 days


    SQLite Spy

    A graphical database manager for SQLite 3 databases. Unicode input and display; REGEXP keyword with Perl 5.8 syntax; a schema tree showing tables, views, columns, indexes, and triggers; multiple tab SQL edits and query results; type-colored data grids; time measurement; fast and low memory. Fully self-contained, single-file executable, requires no installation. Data changes through SQL statements.

    Freeware or donationware

    x x x 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.

    Public Domain


    A PHP class for working with SQLite databases. Supports ALTER TABLE statements.

    Public Domain


    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.


    x SQLiteManager

    a commercial SQLite database manager that runs on Windows, Mac OS X, and Mac OS Classic.

    $39 10 query rows

    x SyBrowser

    a commercial SQLite and Sybase database manager that runs on Windows, Mac OS X, and Mac OS Classic.

    $89 35 query rows


    Very small and simple web-based (CGI) sqlite administrator. Developed totally using shell script, with help from GNU coreutils and sed.

    Web Win. Lin. Misc. Name Description Licence / Price Trial Version

    x x

    A graphical database manager for SQLite implemented by Tcl/Tk.



    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


    x x
    SQLiteTool SQLiteTool is a free GUI Client for the SQLite Database. Supports both versions 2 and 3 of SQLite. Available on multiple platforms (Windows and Linux). Easy installation with no additional software requirements. View Screenshot. Freeware

    pySQLiteGUI PySQLiteGUI is a GUI tool for creating and managing.
    supporting both SQLite 2 and's base on GTK+ libs.

    x x x Mike T's SQLite Database Administrator Tool This GUI was created in REALbasic, so it is inherently cross-platform (Windows, Mac OS X and Linux).

    • Create new tables and view the actual CREATE TABLE statement
    • Edit table data directly, even in tables with no primary key
    • Add new records directly to a table with the same interface.
    • Import data from a tab-delimited file.
    • Maintain encrypted databases (it even saves the passwords)
    • An experimental "code completion" function

    x x
    SQLiteTool SQLiteTool is a free GUI Client for the SQLite Database. Supports both versions 2 and 3 of SQLite. Available on multiple platforms (Windows and Linux). Easy installation with no additional software requirements. View Screenshot. Freeware

    x x x SQLite Manager A very lightweight firefox extension (originally) to manage all your sqlite databases.
    SQLite Manager is available as a XULRunner application too.
    Mozilla Public License 1.1

    x x

    A small utility to load the contents of a file to a BLOB field in a SQLite database

    Public Domain

    x x
    x Parse-Dia-SQL (SQLite option)

    Parse-Dia-SQL is a set of perl modules that takes an entity-relationship model built with the Dia diagramming tool and outputs database creation scripts in various dialects.

    The SQLite3 output option supresses some unsupported features (like grant/revoke) and includes automatic generation of foreign key contraints as triggers.

    Current status of the SQLite output (as of May 2009) is beta, meaning it works for me in a real development cycle but might have some bugs in areas I haven't used (like views), so be nice.

    Free (Perl License) -

    x x
    x dbed

    dbed is Sqlite 3 database editor, written in PHP version 5. It allows to add data into tables, edit records and delete rows. Also is possible to add raw sql and look tables list and structure and search data from table. dbed contains ini-file, where is possible to setup users permissions (who can do what).

    dbed uses PHP PDO extension, so it's should be theoretically possible to use it with sqlite version 2 databases too.

    Freeware -

    Inactive or Unsupported

    Web Win. Lin. Misc. Name Description Licence / Price Trial Version


    Caligari's SQLite Admin Tool

    SQLite admin tool. Have source too.



    A Flash MX2004 front-end based on Database Connector System to manage SQLite database files with PHP5 interaction.


    x x

    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.



    Another GUI tool to create view and edit SQLite databases. Discontinued by author.



    PHP based administration tool for SQLite in the same style as phpMyAdmin. Requires PHP 4.3+. GPL.



    Web interface for the administration of SQLite databases.



    SQLite Query Analyzer

    Sqlite Query Analyzer is a query analyzer tool for ¤ 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#.



    SQLite Sharp Admin

    A tool written by Evandro Junior (needs .NET Framework 2).



    SQLite Control Center is a visual tool for working on SQLite database files similar to MySQL CC.


    SQLiteCC for SQLite3

    Same as SQLiteCC but for SQLite3 database files



    A tool to manage SQLite databases like phpMyAdmin is to MySQL. Written in pure PHP5 using PHP5 DOM XML, XSL and SQLite extensions



    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