Skip to content
Search

SQLiteStudio

lastmod 2024-11-27created 2024-11-271 edits

A free, open source, multi-platform SQLite database manager.

Open-source multi-platform SQLite management tool

  • An open-source tool for creating, editing, and browsing SQLite databases
  • Written in C++ with the Qt framework, so powerful yet light and fast
  • Portable binaries for Windows, Linux, MacOS X: no installation or uninstallation needed; download, extract, and run

Features

  • Advanced SQL code editor
    • SQL syntax hints and highlighting
    • Includes code formatting and syntax error marking
    • Ctrl+click a table name etc. in an SQL query to open the corresponding table, index, trigger, view, etc.
  • Encrypted databases
    • Supports encryption and password protection of SQLCipher, WxSQLite3, System.Data.SQLite, etc.
  • Multiple database support
    • Provides a transparent database attaching mechanism that lets a single query reference multiple databases
  • User-defined SQL functions
    • User-defined SQL functions (scalar and aggregate functions) can be implemented in JavaScript, Python, Tcl
    • Ready-to-use scripts available on the Wiki page
  • User-defined collations
    • Supports user-defined collations that implement a sorting algorithm for use in ORDER BY clauses, etc.
  • SQL and DDL history
    • Easily find even queries run two weeks ago
    • Review DDL statements run in SQLiteStudio and upgrade production databases
  • Drag and drop between databases
    • Copy or move objects such as tables and indexes between databases by drag and drop
    • Choose whether to include data
  • Cross-platform support
    • Runs on major platforms including Windows, MacOS X, Linux
    • Can also run on other platforms such as FreeBSD by compiling the source code
  • Portable distribution
    • No installation needed; just download, extract, and run
    • No administrator privileges required
  • Data generation
    • Automatically populate tables with data using various strategies (constants, sequences, random numbers, dictionary-based text, etc.)
  • Data import and export
    • Import data from CSV or from text files using regular expressions
    • Export to various formats such as SQL statements, CSV, HTML, XML, PDF, JSON
  • Scripting
    • Supports JavaScript, Python, Tcl languages
    • Scripts can be used to implement data generators, user-defined SQL functions, user-defined collations, etc.
  • Plugin support
    • New scripting languages, data import/export formats, table data generation strategies, database formats, etc. can be added via plugins

See also

Favorite site

author Zer0 sitemap