Local Database Explorer

Explore local SQLite databases inside VS Code with a fast table browser, query runner, and multi-format export.

Why Local Database Explorer

Local Database Explorer gives you a focused SQLite workflow without leaving VS Code:

• Open .db, .sqlite, and .sqlite3 files directly from the file context menu.
• Browse tables and columns in a dedicated sidebar.
• Run SQL and inspect results in a grid view.
• Export selected data in practical formats for sharing or downstream tooling.
• Use the extension in multiple languages.

Features

• SQLite file support:
  • .db
  • .sqlite
  • .sqlite3
• Table and schema explorer:
  • Table list in Activity Bar view
  • Column metadata and row counts
• SQL query runner:
  • Supports SELECT, INSERT, UPDATE, DELETE, PRAGMA, and other SQLite statements
  • Results are shown in the integrated preview grid
• Data copy/export formats:
  • CSV
  • TSV
  • HTML table
  • JSON
  • SQL object
• Data actions:
  • Copy row JSON
  • Copy individual field values
• Usability:
  • Pagination for large result sets
  • Refresh command for current database session

Quick Start

1. Open a SQLite file in VS Code.
2. Right-click the file and choose Open Database.
3. Select a table from the sidebar.
4. Use the query bar to run SQL.
5. Use the copy/export menu to export selected data.

You can also run Local Database Explorer: Open Database from the Command Palette.

Usage

1. Open your database.

• In the Explorer, right-click a .db, .sqlite, or .sqlite3 file.
• Choose Open Database.

2. Navigate tables and columns.

• Open the Local Database Explorer activity bar view.
• Click a table to load its rows.
• Expand table entries to inspect column names and types.

3. Work with row data.

• Scroll through paged results in the center grid.
• Use selection to focus individual cells or row ranges.
• Use row and field copy actions where needed.

4. Use the query bar.

• Enter your query in the bottom query input.
• Run or clear using the toolbar controls.
• Review status and results directly in the grid.

5. Export selected results.

• Select cells or rows in the preview grid.
• Open the copy/export menu.
• Choose output format: CSV, TSV, HTML, JSON, or SQL object.

6. Refresh when needed.

• Run Local Database Explorer: Refresh from the Command Palette.
• Or use refresh controls in the UI to reload current data.

Commands

• localDataExplorer.openDatabase - Open a SQLite database file.
• localDataExplorer.refresh - Refresh the active database session.

Localization

Localized extension and webview UI support:

• English (en)
• Czech (cs)
• German (de)
• Spanish (es)
• French (fr)
• Hungarian (hu)
• Italian (it)
• Japanese (ja)
• Korean (ko)
• Polish (pl)
• Portuguese (Brazil) (pt-BR)
• Russian (ru)
• Turkish (tr)
• Chinese (Simplified) (zh-cn)
• Chinese (Traditional) (zh-tw)

Requirements

• VS Code ^1.95.0

License

Copyright (c) 2026 BreckCode.

Permission is granted for personal and commercial use. The software is provided "AS IS", without warranty of any kind.

See LICENSE for the full text and terms.