sqlite - Management Tools

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.

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

• 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 http://www.sqlite.org/contrib.
  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

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.

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

• 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

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

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.

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

• 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

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

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.

Download

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

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

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

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

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

Download

PHP SQL console/editor

features

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

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

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

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

• 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 hungry 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.
Supported databases:

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

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

Download

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

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.

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. Updated weekly with new features.

• 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

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

• 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

• 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

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.

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

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

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.

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.

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.