SQLite3 Editor

This extension lets you edit SQLite files without having to write SQL queries, a feature that is not available in any other extensions.

IMPORTANT: This extension requires Python >=3.6 compiled with SQLite >=3.37.0 (fully supported) or >=3.8.8 (partially supported). The extension will tell you if the requirements are not met.

Features

Spreadsheet GUI for Browsing and Editing Data

This extension offers several advantages over other extensions:

• You can click a cell and UPDATE data in-place with an intuitive GUI, even through a view or a custom query (*1). This feature is not available in other extensions.
• This extension uses scrolling instead of pagination for browsing records, by only querying the visible area, avoiding performance degradation. This makes the browsing more intuitive.
• The data is automatically reloaded when the table is modified by another process. This feature is not present in alexcvzz/SQLite (issue) and SQLite Viewer.

Advanced Query Editor

Although this extension was created to fill the need for an extension that could intuitively edit SQLite databases using a GUI, it also has an advanced query editor with auto completion, syntax highlighting, hover information, and signature help.

Find Widget

This extension also includes a find widget that enables you to filter records using regex, whole word, and case-sensitivity switches, making data searching faster than using the query editor to write WHERE clauses.

*1: To edit data through a view or a custom query, you need to build a helper program to access the SQLite C/C++ interface. Everything else works fine without the helper program.

File Associations

This extension recognizes .db, .sqlite, .sqlite3, and .duckdb files as database files. To open other files, right click the file in the explorer and select Open with… then SQLite3 Editor.

Error Reporting

This extension displays a "Send error report" button on error notifications. When clicked, it sends the error message with sensitive information removed to the extension's author using Microsoft/vscode-extension-telemetry, or opens a GitHub issue, depending on the user's telemetry settings. If vscode-extension-telemetry is used, the system information (i.e. the "common properties" of Microsoft/vscode-extension-telemetry) will also be included. Keep in mind that the bugs may not be fixed if the reports do not include enough information or the developer is busy, but your help in reporting errors is greatly appreciated.