DBCode
Query and explore 100+ databases through your DBCode connections.
What can you do with DBCode?
- Import/Export: CSV, Excel, JSON, Parquet, Avro
- Backup/Restore: Native tools for PostgreSQL, MySQL, SQLite, SQL Server, MongoDB
- File Formats: Open and edit CSV, Excel, Parquet, Avro files directly
- Data Formatters: Lookup values from other tables, expand JSON columns
- Inferred Relationships: Define relationships for databases without foreign keys (MongoDB, DynamoDB)
- Data Search: Search across all columns in a table
- Transaction Control: Manual commit/rollback with auto-commit toggle
- SQL Filters: WHERE clause filtering with saved filters
Install
Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).
@dbcode/mcpclaude mcp add dbcode -- npx -y @dbcode/mcp@1.0.1
{
"mcpServers": {
"dbcode": {
"command": "npx",
"args": [
"-y",
"@dbcode/mcp@1.0.1"
]
}
}
}
Documentation
From the project's README on GitHub, refreshed weekly. Links open on GitHub.
Contents
- DBCode - SQL & Database Client for VS Code
- Data Viewing & Editing
- AI & Copilot Integration
- Entity Relationship Diagrams (ERD)
- Foreign Key Navigation
- SQL Editor with IntelliSense & Autocomplete
- Secure Report Sharing
- SQL Notebooks
- Stored Procedures & Functions
- Data Visualization
- Data Compare
- Zero Config Connections
- Query Execution Plans (EXPLAIN)
- More Features
- Supported Databases
- Works with VS Code, Cursor & Windsurf
- Coming from DBeaver, DataGrip, TablePlus, or SQLTools?
- Pricing
- Telemetry
DBCode - SQL & Database Client for VS Code
A modern database client for VS Code, Cursor, Windsurf, Antigravity, and Kiro - and the database layer for your AI agent, with built-in MCP and Copilot tools.
Write SQL with IntelliSense, edit table data in place, and manage 90+ databases without leaving your editor. SQL Notebooks, auto-generated ER diagrams, charts, and secure report sharing built in.
Available on the VS Code Marketplace and OpenVSX (for Cursor, Windsurf, and other VS Code forks).
90+ supported databases, warehouses, lakehouses, and file formats
Data Viewing & Editing
- Filter, sort, and group data with a few clicks
- Edit rows directly: insert, update, delete without writing SQL
- Changes verified before execution so you don't have a production horror story
AI & Copilot Integration
Query your data with natural language. Ask schema questions, generate queries, create tables.
Your editor's AI agent gets full database access through DBCode's built-in MCP tools - registered automatically in VS Code (Copilot) and Cursor, one click in Antigravity, Windsurf, and Kiro, and available to external agents like Claude Code via DBCode: Connect an AI Agent. Agents use your existing connections, with AI permissions you control per connection. Learn more
Entity Relationship Diagrams (ERD)
Auto-generated diagrams from your live database schema. Export as PDF, HTML or PNG.
Foreign Key Navigation
Click any foreign key value to jump to the referenced row. Navigate relationships without writing JOINs.
SQL Editor with IntelliSense & Autocomplete
Full SQL editor with database-specific syntax highlighting, autocomplete, and inline signature help.
- Database-specific SQL keywords and syntax
- Table, view, and procedure autocomplete with column types
Secure Report Sharing
Share query results as encrypted reports. No credentials or raw data exposed.
SQL Notebooks
SQL and Python cells in VS Code Notebooks. Query, analyze, and document in one place with Jupyter kernel integration.
Stored Procedures & Functions
Edit and deploy database logic directly from VS Code. Full syntax support for PL/pgSQL, T-SQL, PL/SQL, and more.
Data Visualization
Transform query results into charts and graphs. Bar, line, pie, scatter, and more.
Data Compare
Compare data between tables, databases, or connections. See differences side-by-side, generate sync scripts, or apply changes directly. Learn more
Zero Config Connections
Automatically discovers database connections from your project's .env, application.properties, database.yml, settings.py, and other config files. Supports Laravel, Django, Spring Boot, Node.js, Rails, and more. Learn more
Query Execution Plans (EXPLAIN)
Visualize EXPLAIN and ANALYZE output as interactive node graphs. Identify slow operations, see row estimates vs actuals, and drill into cost breakdowns. Supported for PostgreSQL, MySQL, SQL Server, and more. Learn more
More Features
Data
- Import/Export: CSV, Excel, JSON, Parquet, Avro
- Backup/Restore: Native tools for PostgreSQL, MySQL, SQLite, SQL Server, MongoDB
- File Formats: Open and edit CSV, Excel, Parquet, Avro files directly
- Data Formatters: Lookup values from other tables, expand JSON columns
- Inferred Relationships: Define relationships for databases without foreign keys (MongoDB, DynamoDB)
- Data Search: Search across all columns in a table
Query & Analysis
- Transaction Control: Manual commit/rollback with auto-commit toggle
- SQL Filters: WHERE clause filtering with saved filters
- Query Parameters: Reuse queries with different inputs
- Query History: Full history with search, re-execute, and sync across devices
Connectivity
- Auth Profiles: OAuth, AWS SSO, 1Password, HashiCorp Vault
- SSL Auto Config: Automatic SSL for known hosts
- SSH Tunnels: Manual config or auto-discovery from SSH config
- Command Tunnels: Local proxy tools (cloud-sql-auth-proxy, kubectl port-forward, AWS SSM)
AI
- Copilot Chat: Drag tables into Copilot, natural language queries
- MCP Integration: Model Context Protocol for AI tools with full schema context
- Inline Completion: AI-powered SQL code completion
VS Code Integration
- Theme Support: Full compatibility with VS Code themes
- Localization: Available in all VS Code supported languages
Supported Databases
- SQL databases: PostgreSQL, MySQL, SQL Server, SQLite, MariaDB, Oracle, Azure SQL, IBM DB2, IBM i (AS/400), CockroachDB, TiDB, TimescaleDB, YugabyteDB, SingleStore, H2, Firebird, Apache Derby, Microsoft Access, SAP ASE (Sybase), Dameng, KingbaseES, libSQL, PGlite, Cloudflare D1, Google Cloud Spanner
- Warehouses & analytics: Snowflake, BigQuery, Redshift, Databricks, ClickHouse, DuckDB, MotherDuck, Amazon Athena, Azure Synapse, Microsoft Fabric, Teradata, Vertica, Netezza, Exasol, Greenplum, Apache Doris, StarRocks, Apache Druid, Apache Pinot, Apache Hive, Apache Impala, Trino, Cube
- Lakehouses: Apache Iceberg, DuckLake
- NoSQL & document: MongoDB, Amazon DocumentDB, Apache CouchDB, Couchbase, RavenDB, Firebase, DynamoDB, Cassandra, ScyllaDB, Aerospike, Elasticsearch, OpenSearch, SurrealDB, TypeDB, Redis, Memcached
- Graph & vector: Neo4j, Memgraph, Pinecone, Chroma, Milvus, Qdrant, Weaviate, LanceDB
- Streaming & time series: InfluxDB, QuestDB, RisingWave, Apache Kafka, RabbitMQ
- SaaS & app platforms: Salesforce, Microsoft Dataverse, Bunny
- Files: CSV, Excel, Parquet, Avro
Works with VS Code, Cursor & Windsurf
DBCode runs anywhere VS Code does. Install from the VS Code Marketplace, or from OpenVSX for Cursor, Windsurf, VSCodium, and other VS Code forks. Your connections, saved queries, and AI integration work the same in every editor.
Coming from DBeaver, DataGrip, TablePlus, or SQLTools?
- From DBeaver? The same multi-database coverage - Postgres, MySQL, SQL Server, Oracle, and 90+ more - with native AI built in, and no separate Java app to run.
- From DataGrip? Power-user features like execution plans, data compare, and stored procedure editing, without leaving your editor or JetBrains' commercial pricing.
- From TablePlus? Cross-platform and integrated: no separate app to alt-tab to, with Copilot and MCP built in.
- From SQLTools? Everything you use it for, plus inline data editing, ER diagrams, NoSQL support, and native AI - one extension, no per-database driver installs.
Pricing
Free for everyone, including commercial use and teams of any size: browsing, querying, and editing data, notebooks, ER diagrams and charts, transaction control, read-only connections and roles, missing WHERE detection, unlimited query history, favorites, the library, schema-aware Copilot tools, the MCP server for your AI agent, and more.
Pro adds AI assistance, data tooling, sync and sharing, and cloud provider integrations. Team adds role-based feature control and centralized seat management. See Pricing.
Telemetry
Anonymous usage data is collected when VS Code telemetry is enabled. Telemetry respects your VS Code settings if disabled there, we collect nothing. See our privacy policy.
Frequently asked questions
What is DBCode?
Query and explore 100+ databases through your DBCode connections.
How do I install DBCode?
It runs on your machine. In Claude Code: claude mcp add dbcode -- npx -y @dbcode/mcp@1.0.1. For other clients, paste the JSON configuration from this page into their MCP settings.
Does DBCode need an API key?
Its registry entry lists no required key or secret. Some features may still need an account with the service it connects to.
Is DBCode open source?
Its code is public on GitHub, but the repository does not declare a standard license.
Who maintains DBCode?
It is published by dbcodeio. AI.tn lists it but does not maintain or endorse it.
From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.