BlizDB MCP — VS Code Extension
Database explorer, SQL editor, data grid and MCP integration for BlizDB — a high-performance file-based SQL database engine.
Features
Database Explorer
A full tree view in the VS Code sidebar showing your connection hierarchy:
- Connections — add, edit, remove and connect/disconnect servers
- Databases — browse all databases with active-database indicator (★), 24h insight tooltips, portal/domain info
- Tables — row counts, expandable columns (types, nullable, PK) and indices
- Portals & Domains — multi-tenant namespace management
- Users — view server users and roles
- Auto-refreshes on a configurable interval (default 30s)
SQL Editor & IntelliSense
- Open SQL files with
Ctrl+N or run ad-hoc queries
- IntelliSense with ~130 SQL keywords, live table names, column completions (qualified and unqualified)
- Context-aware: columns from referenced tables are boosted in suggestions
- Run query:
Ctrl+Enter (entire file) or Ctrl+Shift+Enter (selection only)
- Results shown as a styled table with row count, execution time, and copy to CSV/JSON
Interactive Data Grid
- Browse table data with pagination, sorting (click column headers) and filtering (SQL WHERE expressions)
- Inline editing — double-click any cell to edit, auto-commits via UPDATE
- Row deletion with confirmation dialog
- Configurable default row limit
Server Dashboard
Real-time server health panel showing:
- Hostname, OS, architecture, engine type
- CPU usage, memory (process + system), disk usage
- Database/table/row counts, connected clients, total queries
- PostgreSQL and HTTP port info, replication role
- Per-database 24h insights (reads, inserts, updates, deletes, avg query time)
- Auto-refreshes every 10 seconds
Compact status card in the sidebar with server metrics, CPU/disk progress bars, and connection info. Refreshes every 10 seconds.
Server Log Viewer
Live-streaming log viewer with two tabs:
- SQL Queries — timestamp, query type, database, SQL preview, row count, duration, status
- Server Logs — streaming entries with level coloring (ERROR/WARN/INFO), user and database tags
- Pause/resume, clear, manual refresh. Auto-polls every 3 seconds.
MCP Integration (GitHub Copilot)
When you connect to a BlizDB server, the extension automatically registers the server's MCP endpoint in VS Code so GitHub Copilot can discover and use all database tools — no manual configuration needed.
Simply open Copilot Chat and ask:
- "List all tables in my database"
- "Show me the first 10 rows from the users table"
- "Create a new table called sensors with columns id, name, value"
- "What's the server status?"
16 MCP tools are available for AI-assisted database operations:
| Tool |
Description |
blizdb_query |
Execute SQL queries |
blizdb_list_databases |
List all databases |
blizdb_create_database |
Create a database |
blizdb_drop_database |
Drop a database |
blizdb_list_tables |
List tables in a database |
blizdb_get_schema |
Get full schema |
blizdb_describe_table |
Describe table columns and indices |
blizdb_create_table |
Create a table via SQL |
blizdb_drop_table |
Drop a table |
blizdb_server_status |
Get server status/metrics |
blizdb_list_users |
List server users |
blizdb_create_user |
Create a user |
blizdb_backup_database |
Create a database backup |
blizdb_audit_log |
View audit log entries |
blizdb_rename_database |
Rename a database |
blizdb_rename_table |
Rename a table |
Destructive tools require user confirmation before execution.
Multi-Tenant Support
- Portals & Domains — create and manage tenant namespaces
- Context switching — switch between Global, Portal, and Domain contexts
- Assign/unassign databases to domains
Getting Started
Prerequisites
Installation
Install from the VS Code Marketplace:
- Open VS Code
- Go to Extensions (
Ctrl+Shift+X)
- Search for "BlizDB MCP"
- Click Install
Or install from the command line:
code --install-extension Traberg-Larsen.blizdb-mcp
Add a Connection
- Open the BlizDB sidebar (click the BlizDB icon in the Activity Bar)
- Click Add Connection or run
BlizDB: Add Connection from the Command Palette
- Enter a name, host, port, and optionally enable SSL or provide an API key
- Connect by clicking the plug icon on the connection
Commands
All commands are available via the Command Palette (Ctrl+Shift+P) under the BlizDB category:
| Command |
Description |
BlizDB: Add Connection |
Add a new server connection |
BlizDB: Edit Connection |
Edit connection settings |
BlizDB: Remove Connection |
Remove a saved connection |
BlizDB: Connect |
Connect to a server |
BlizDB: Disconnect |
Disconnect from a server |
BlizDB: Refresh |
Refresh the explorer tree |
BlizDB: New SQL Query |
Open a new SQL editor |
BlizDB: Open SQL Editor |
Open the webview SQL editor |
BlizDB: Run Query |
Execute the active SQL file |
BlizDB: Run Selected Query |
Execute selected SQL text |
BlizDB: Browse Data |
Open the data grid for a table |
BlizDB: Describe Table |
Show table schema |
BlizDB: Create Database |
Create a new database |
BlizDB: Drop Database |
Delete a database |
BlizDB: Drop Table |
Delete a table |
BlizDB: Set Active Database |
Set the working database |
BlizDB: Copy Name |
Copy item name to clipboard |
BlizDB: Copy SELECT Statement |
Copy a full SELECT for a table |
BlizDB: Copy INSERT Template |
Copy an INSERT template |
BlizDB: Backup Database |
Create a database backup |
BlizDB: Open Dashboard |
Open the server dashboard |
BlizDB: View Audit Log |
View audit log |
BlizDB: View Server Log |
Open live server log |
BlizDB: Run Self-Test |
Run server self-diagnostics |
BlizDB: Manage API Keys |
List, create, and revoke API keys |
BlizDB: Switch Context |
Switch portal/domain context |
BlizDB: Create/Delete Portal |
Manage portals |
BlizDB: Create/Delete Domain |
Manage domains |
Keyboard Shortcuts
| Shortcut |
Action |
Ctrl+Enter |
Run entire SQL file |
Ctrl+Shift+Enter |
Run selected SQL |
Settings
Configure via File > Preferences > Settings and search for "BlizDB":
| Setting |
Default |
Description |
blizdb.connections |
[] |
Saved server connections (name, host, port, SSL) |
blizdb.autoRefreshInterval |
30 |
Explorer auto-refresh interval in seconds (0 to disable) |
blizdb.defaultRowLimit |
100 |
Default row limit when browsing table data |
blizdb.queryTimeout |
30000 |
Query execution timeout in milliseconds |
Development
Setup
git clone https://github.com/antigravity/blizdb-vscode.git
cd blizdb-vscode
npm install
Build
npm run compile # Development build
npm run watch # Watch mode (rebuilds on save)
npm run package # Production build (minified)
Debug
- Open the project in VS Code
- Press
F5 to launch the Extension Development Host
- The extension activates automatically when you open the BlizDB sidebar
Lint & Test
npm run lint # ESLint
npm test # Vitest
Publishing New Versions
Prerequisites
@vscode/vsce is already included as a dev dependency- You must be logged in:
npx vsce login Traberg-Larsen
- You need a valid Personal Access Token (PAT) with Marketplace > Manage scope
Publish a New Version
# Patch release: 0.1.0 → 0.1.1
npx vsce publish patch
# Minor release: 0.1.0 → 0.2.0
npx vsce publish minor
# Major release: 0.1.0 → 1.0.0
npx vsce publish major
# Or set a specific version
npx vsce publish 1.2.3
This automatically:
- Bumps the version in
package.json
- Runs
npm run package (production build)
- Packages the
.vsix file
- Uploads to the VS Code Marketplace
Build Without Publishing
# Create a .vsix file for local testing
npx vsce package
# Install locally
code --install-extension blizdb-mcp-0.1.0.vsix
Updating Your PAT
If your Personal Access Token expires:
- Go to https://dev.azure.com → User Settings → Personal Access Tokens
- Create a new token (Organization: All accessible, Scope: Marketplace > Manage)
- Run
npx vsce login Traberg-Larsen and enter the new token
License
MIT
