SQLite Database Query Tool Features

The SQLite database query tool provided by RazorSQL includes such features as a custom SQLite database browser tailored to SQLite, an SQL editor with SQLite specific features and syntax highlighting, custom SQLite visual tools, and SQLite specific database administration tools. Listed below are more details on these features.

SQLite Database GUI Tools SQLite GUI Tools

RazorSQL provides many SQLite GUI tools for working with SQLite databases. Click the link above for more detailed information about the GUI tools, which include the following:

  • GUI tools for creating SQLite tables, views, indexes, and triggers
  • GUI tools for altering SQLite tables and views
  • GUI tools for dropping / deleting SQLite tables, views, indexes, and triggers
  • a GUI tool for editing SQLite tables
  • GUI tools for importing and exporting data into SQLite databases
  • an SQLite SQL explain plan tool
  • See the SQLite Database Management Tool page for more information on management features

SQLite Database Browser SQLite Database Browser

  • Displays information in a tree format for databases, tables, views, triggers, and indexes
  • An SQLite View DDL option for viewing object DDL such as the Create Table DDL behind SQLite tables
  • Displays SQLite table information such as column name, column type, column length, column nullability, and primary and foreign key information
  • Easily view table contents or database object information via the View Contents and Show Info context menu options

SQLite SQL Editor  SQLite SQL Editor

Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, PHP, HTML, XML, Java, and more.

SQLite Import Tool SQLite Import Tool

Import data from various formats such as delimited files, Excel spreadsheets, and fixed width files.

SQLite Export Tool SQLite Export Tool

Export data in various formats such as delimited files, Excel spreadsheets, text, HTML, XML, and SQL insert statements.

SQLite Table Editor SQLite Table Editor

Edit tables in a spreadsheet format with support for finding and replacing data, automatic generation of SQL, and support for editing multi-line data.

SQLite SQL Query Builder SQLite SQL Query Builder

Easily build select, insert, delete, and update SQL queries. Build multi-table joins.

SQLite Database Convertion Tools SQLite Database Conversion Tools

Convert database tables from SQLite to other database types and from other database types to SQLite.

Below is a screen shot of the RazorSQL SQLite GUI Tool

SQLite GUI Tool