VSCode extension to explore and query SQLite databases.
Requirements
Windows, MacOS: No requirement.
Linux: If the extension is not working out-of-the-box, it may be necessary to install sqlite3 in your system (on Ubuntu: sudo apt install sqlite3)
Note: The extension includes precompiled binaries for the SQLite CLI (used to execute queries), in case the included binaries do not work (or if you want to use your own binaries) you need to provide the path/command to the sqlite3 CLI executable in the setting sqlite.sqlite3.
Features
Query SQLite databases and view results in a table (also supports dot commands like .tables, .schema, ecc).
Export query results to json, csv and html.
Sidebar explorer: list databases, tables, views and columns.
Autocompletion for SQLite keywords, table and views names, column names (autocompletion is available for an SQL document once its bound to a database, to bind an sql document to a database use the command SQLite: Use Database)
Grammar support for SQLite keywords. This is available for documents with language sqlite. You can mark a document as an sqlite document adding -- sqlite in the first line.
Commands
SQLite: New Query Create a new untitled sqlite file.
SQLite: Run Query Execute query script in the editor.
SQLite: Quick Query Choose a database and execute a query without creating a new document.
SQLite: Use Database Bind current sql document to the selected database.
SQLite: Open Database Open the selected database in the sqlite explorer.
SQLite: Close Database Remove the selected database from the sqlite explorer.
SQLite: Refresh Databases Refresh databases open in the sqlite explorer.
SQLite: Show output Show the extension's output channel.
SQLite: Change Workspace Trust Change the trust of this workspace. By default every workspace is untrusted for security reasons.
Settings
"sqlite.sqlite3": string sqlite3 command or CLI executable path (this setting is disabled for untrusted workspaces)
