Small. Fast. Reliable.
Choose any three.

Active and Supported

<;td>Trial Version
Web Win. Lin. Misc. Name Description Licence / Price Trial Version

x x x Sqliteman
[2008/01/15]
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

SharpPlus Sqlite Developer
(Update 2008/01/14)

 

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

Features:
  • Power SQL Editor with syntax highlight, autocomplete(keyword, schema), live sql syntax check, parenthesis matching, unicode support
  • Sqlite SQL Formatter
  • Unicode Support
  • Data Type Mapping.
  • Execute multiple sql seperated by semi colon
  • Visual Query Builder
  • Visual schema management
  • View and edit field as Text, Hex, HTML or Image.
  • Attach, Detach databases.(New)
  • Export/Import data
  • Extract db schema and 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

x

wxSQLite+

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

GPL

x

SQLite Maestro 7.12
(updated 2008/01/03)

SQLite Maestro allows you to create, edit, copy, extract and drop all the database objects such as tables, views, triggers, indexes; build queries visually, execute queries and SQL scripts, view and edit data including BLOBs (with full Unicode/UTF-8 support), represent data as diagrams, export and import data to/from most popular file formats, and use a lot of other tools designed for the easiest and most efficient work with SQLite server (versions 2.8 and 3.x.y are supported).

The latest version (7.12) was released at 2007/12/10. It features Graphical Database Designer, support for attached databases, support for Reindex and Vacuum commands, The SQL Generator tool, improved data managemenet and some other useful things. Full press-release is available here:
http://www.sqlmaestro.com/news/company/4698/

SQLite Maestro is developed by SQL Maestro Group, which also offers complete management tools for MySQL, Microsoft SQL 7/2000/2005, Oracle, PostgreSQL, Firebird and MaxDB.

$59 for a non-commercial license,
$99 for a business one
30 days

x

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

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

Freeware

x

SQLite2007 Pro Enterprise Manager
(Updated 2007-11-11)
[SQLite v3.5.2]

 

SQLite2007 Pro Enterprise Manager is a freeware (features limited) and shareware tool that enables you to manage your SQLite3 databases.

Features:
  • Database Encrypted support
  • Built-in FTS1, FTS2 and FTS3
  • Additional Built-in SQLite3 function (concat, g_concat,md5, mid$, left$, right$, etc...)
  • Import data from Ms Access, MS SQL server 2000, MS SQL 2005 and MySQL
  • Export recordset into excel, csv, xml and html format
  • Query Builder
  • Blob/Image viewer
  • Transactions supported
  • Much more ...
New:
Added SQLite2007 Pro ODBC Driver,the first free ODBC driver which have supported for accessing encrypted database that was build with SQLite2007 Pro Enterprise Manager (includes with vb6 sample project).
$19.49 / free with features limited

x x x SQLiteStudio
(Update 2007/07/25)

 

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

Features:
  • Intuitive MDI interface,
  • All SQLite3 features wrapped witin simple GUI,
  • Some features implemented on top of basic SQLite3 SQL statements, like editing all existing objects, or wizard for Foreign Keys,
  • Cross-platform - runs on Windows, Linux and should work on other Unixes. Mac OS X support is planned,
  • Localizations, currently translated to:
    • English,
    • Polish,
  • Exporting to various formats (SQL statements, CSV, HTML, XML),
  • Numerous small additions, like formatting code (uppercase keywords), fast navigate between MDI windows and tabs in notebooks by shortcuts, history of queries executed in editor windows and more,
  • 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.
free for non-commercial, commercial is not yet released (see homepage for details) -

x Kylix

SQLcc
(Update 16 March 2007)

 

SQLcc is a completely different open source Database manager for SQLite3, with future plans for any SQL database.

Features:
  • 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)
-

x

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
Features:
  • User friendly Interface
  • One click table view.
  • Execute Ad hoc Queries w/o leaving the interface.
  • Not a resource hungary app, loads faster
  • Used and tested by more then 200 users
Freeware No limit

x

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

x

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

x

PlaneDisaster.NET

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

Download

Open Source (GPL)

x

SQLPro SQL Editor

SqlPro SQL Editor is the best visual database management and development tool for multiple databases with Explorer interface and integrated SQL editor. Supports Oracle, MySQL, Microsoft SQL Server, Microsoft Access and Sqlite 3.

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

Download

$30 Popup reminder

x

Another SQLite Explorer

An open source SQLite 3 Explorer provided by Arke Systems, LLC.

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
    x


    DB_SQLite_Tools

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

    BSD

    x

    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

    x

    eSQL for Windows

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

    Freeware



    x eSQL for Windows Mobile

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

    $9.50


    x
    knoda

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

    GPL

    x x x LiteMan

    SQLite3 database manager based on Qt4.

    GPL

    x x
    Kexi

    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.

    LGPL

    x x
    OpenOffice

    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 www.ch-werner.de/sqliteodbc/.

    BSD / LGPL

    x

    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. Edit fields, indexes, constraints, triggers. Create SQL scripts and views using the integrated Query Builder. Import/export data, visually edit data in the grid, including BLOB and image fields.

    $59 30 days

    x

    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.

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

    x

    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

    x

    SQLite Analyzer

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

    $60 30 days

    x

    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
    x


    SQLiteDB

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

    Public Domain
    x


    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.

    GPL

    x
    x SQLiteManager

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

    $39 10 query rows

    x
    x SyBrowser

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

    $89 35 query rows

    x

    SQLitePlus Database Explorer

    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, create Create Stored Scripts (like stored procedures, except uses VBScript or JScript), execute highlighted query text

    $20 Feature limited
    x


    sqliteweb

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

    BSD
    Web Win. Lin. Misc. Name Description Licence / Price

    x x
    TkSQLite

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

    BSD-style
    x


    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

    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
    pySQLiteGUI PySQLiteGUI is a GUI tool for creating and managing.
    supporting both SQLite 2 and 3.it's base on GTK+ libs.
    GPL

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

    Features:
    • 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
    Freeware

    Inactive or Unsupported

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

    x

    Caligari's SQLite Admin Tool

    SQLite admin tool. Have source too.

    GPL
    x


    DCSQLite

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

    GPL

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




    x

    LiteQuery

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

    GPL
    x


    phpSQLiteAdmin(1)

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

    GPL
    x


    phpSQLiteAdmin(2)

    Web interface for the administration of SQLite databases.

    GPL

    x

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

    GPL

    x

    SQLite Sharp Admin

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

    ?




    SQLiteCC

    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

    ?
    x


    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
    x


    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