Skip to content
| Marketplace
Sign in
Visual Studio Code>Other>SQLiteNew to Visual Studio Code? Get it now.

SQLite

alexcvzz

|
562,791 installs
| (40) | Free
Explore and query SQLite databases.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

vscode-sqlite

VSCode extension to explore and query SQLite databases.

static/sqlite_workflow_1

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)

  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2021 Microsoft