Documentation

Introduction

SQLite Studio is a professional, offline-first desktop application designed for efficient database management. It combines a powerful SQL editor with a visual schema designer to provide a complete development environment for SQLite.

Installation

You can install SQLite Studio using the latest setup installer or use the portable version:

• Setup Installer: Standard Windows installation. Register file associations and desktop shortcuts.
• Portable (.zip): Extract and run the executable directly. No installation or admin rights required.

Managing Databases

SQLite Studio makes it easy to work with multiple databases:

• Open Database: Use Ctrl+O or the toolbar to open existing .db, .sqlite, or .sqlite3 files.
• New Database: Create fresh databases with Ctrl+N.
• Persistence: Changes are saved automatically (atomic writes) back to the original file.

SQL Editor

The editor is powered by Monaco (the same engine as VS Code):

• Syntax Highlighting: Supports all standard SQLite keywords and functions.
• Execution: Run your queries using Ctrl+Enter.
• Multiple Results: The results panel displays data in a clean, filterable table.

Schema Designer

Visualize your data structure automatically:

• Automatic Layout: Tables and their relationships (Foreign Keys) are rendered visually.
• Interactivity: Drag and drop tables to organize your view.
• Export: Save your diagram as a high-quality SVG or PNG for documentation purposes.

Troubleshooting

Missing a feature or found a bug? Check out the Issues page on GitHub.