sqlite - Management Tools

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

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

Data modeling tool for SQLite database design.

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.

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

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

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

• 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

• 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

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;
• ...;

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

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

Download

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

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.

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

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.

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

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

SQLite3 database manager based on Qt4.

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.

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

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.

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.

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.

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

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.

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.

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

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.

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

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

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

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

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

• 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

SQLite admin tool. Have source too.

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

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

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.

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.