vscode-sqlite

VSCode extension to explore and query SQLite databases.

Requirements

No requirements

Note: The extension includes binaries for the sqlite cli (used to execute queries), in case the included binaries do not work you need to provide your own path/command for the sqlite cli in the setting sqlite.sqlite3

Features

Query sqlite databases and view results in a table.
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.

Settings

"sqlite.sqlite3": <string> sqlite3 command or binaries path.
"sqlite.logLevel": <string> Set output channel log level (DEBUG, INFO, WARN, ERROR).
"sqlite.recordsPerPage": <number> Number of records to show per page. (-1 to show all records).

Known Issues

No known issues.