🛢️ Database Pilot

A powerful, all-in-one database & file client for Visual Studio Code

✨ Features at a Glance

🚀 Installation

Install from the VS Code Marketplace or Open VSX.

ext install exaland.database-pilot

🗄️ Database Connections

Connect

1. Open the Database Explorer panel in the sidebar.
2. Click the + button to add a new connection.
3. Select your database type, fill in the connection details, then click Connect.

Browse & Edit Tables

• Click a table to open the interactive table view.
• Inline editing, filtering, pagination, and column sorting are all supported.

Execute SQL Queries

Click Open Query in the Database Explorer panel to open a SQL editor bound to the current database.

The SQL editor provides:

• IntelliSense — auto-complete for tables, columns, and functions
• Snippets — sel, del, ins, upd, joi…
• Ctrl+Enter — run the selected or cursor SQL
• Ctrl+Shift+Enter — run all SQL in file

📁 File Explorer

Open via Cmd/Ctrl+Shift+P → MySQL: 📁 Explorateur de fichiers

The File Explorer supports three providers in a single unified interface:

💻 Local Filesystem

Navigate your local files and folders. Open files directly in VS Code, reveal in OS Finder / Explorer, copy paths.

🟠 AWS S3

Connect to any S3-compatible bucket (AWS, MinIO, Backblaze B2…).
Saved S3 connections from the Database Explorer are auto-detected — just click to load credentials.

🔷 Azure Blob Storage

Connect via account + key or a SAS URL.

Common Features (all providers)

• Multi-select — Cmd/Ctrl+click to toggle, Shift+click to select a range, header checkbox to select all
• Delete — per-item or bulk, with confirmation dialog
• Export — download files from S3 / Azure to a local folder
• Image & Video preview — auto-loads in the detail panel for images (jpg, png, gif, webp, svg…) and videos (mp4, webm, mov, mkv…) up to 50 MB
• Sort — by name, size or modified date
• Search — live filter within the current folder/prefix
• List & Grid view modes

💾 Backup & Import

Right-click any connection, database, or table node to access Export and Import options.

The extension implements its own backup engine. If mysqldump or pg_dump is on your PATH, it will be used automatically for higher fidelity output.

🧪 Mock Data

Generate test data for any table directly from the table context menu.

📜 Query History

Click the History button to browse and re-run previous queries.

🔬 ElasticSearch

• Query via HTTP with account/token auth
• Backup and restore indexes (structure + data)
• Restore modes: merge or overwrite with safety confirmation

🔥 Firestore (Firebase) — Experimental

Add a Firestore connection via Connection Config (config.json) or directly in nosql.global / nosql.workspace:

{
  "<your-key>": {
    "key": "<your-key>",
    "name": "Firestore Dev",
    "dbType": "Firestore",
    "host": "your-project-id",
    "dbPath": "/absolute/path/to/service-account.json",
    "disable": false
  }
}

host = projectId · dbPath = path to your service account JSON file.
Lists top-level collections and the first 50 documents per collection.

⚡ Performance & Cache

Database metadata is cached for performance. If your schema changes externally, click the Refresh button on the relevant node.

⚙️ Settings

Go to Settings (Ctrl+,) and search for database-client to see all available options.

Telemetry

Database Pilot collects anonymous usage data to improve the extension. To opt out:

"database-client.telemetry.usesOnlineServices": false

Or follow the VS Code telemetry settings.

🏆 Credits

🐛 Issues & Feedback

• Bug reports / Feature requests: GitHub Issues
• Email: exaland@gmail.com