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.recordsPerPage": <number> Number of records to show per page. (-1 to show all records).
"sqlite.databaseExtensions": <string[]> The file extensions recognized as SQLite database.
Known Issues
Linux: sometimes the extension is not able to execute the bundled SQLite binary, manually installing SQLite (e.g. sudo apt-get install sqlite3 for Ubuntu) solves the problem.
