Local Database Explorer

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

Marketplace Description

Local Database Explorer is a VS Code extension for opening local SQLite databases, browsing tables and schema, running SQL, and exporting selected results in practical formats like CSV, TSV, HTML, JSON, and SQL object. It is designed for fast, local-first data inspection directly inside your editor.

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.

How to Use

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.

Major Roadmap Items

• Formula import/export:
  • Import formula definitions from external files/sources.
  • Export formulas for reuse across databases and projects.
  • Preserve formula metadata and compatibility checks.
• Keyboard shortcuts:
  • Fast actions for opening databases, running queries, refreshing, and exporting.
  • Grid navigation and selection shortcuts for power users.
  • Shortcut customization through standard VS Code keybinding settings.

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

Known Scope

• This extension currently targets local SQLite databases only.
• Formula import/export sql queries, export as xml and keyboard shortcuts are planned roadmap features

License

See LICENSE.