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).

• "sqlite.databaseExtensions": <string[]>   The file extensions recognized as SQLite database.

Thanks to the Contributors!

mandel59 (Ryusei YAMAGUCHI), LokiSharp (LokiSharp), MrCodingB(MrCodingB)