Back to Directory/Other

DBCode

Query and explore 100+ databases through your DBCode connections.

OtherJavaScriptv1.0.1
View on GitHub

DBCode - SQL & Database Client for VS Code

Data Viewing & Editing

VS Code database GUI - filter, sort, group, and edit data
  • 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

GitHub Copilot database queries - natural language to SQL

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 ER diagrams from database schema

Auto-generated diagrams from your live database schema. Export as PDF, HTML or PNG.

Foreign Key Navigation

Navigate database foreign key relationships

Click any foreign key value to jump to the referenced row. Navigate relationships without writing JOINs.

SQL Editor with IntelliSense & Autocomplete

VS Code SQL editor with intellisense and autocomplete

Full SQL editor with database-specific syntax highlighting, autocomplete, and inline signature help.

SQL autocomplete with table and column intellisense
  • Database-specific SQL keywords and syntax
  • Table, view, and procedure autocomplete with column types

Secure Report Sharing

Encrypted database report sharing

Share query results as encrypted reports. No credentials or raw data exposed.

SQL Notebooks

VS Code database notebooks - SQL and Python

SQL and Python cells in VS Code Notebooks. Query, analyze, and document in one place with Jupyter kernel integration.

Stored Procedures & Functions

Edit stored procedures and functions in VS Code

Edit and deploy database logic directly from VS Code. Full syntax support for PL/pgSQL, T-SQL, PL/SQL, and more.

Data Visualization

Database query result charts and graphs

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

All Features · Documentation

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.

See the full comparison →

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.

Installation

Source-derived launch command. Check the maintainer’s required arguments and credentials before running:

bash
npx -y @dbcode/mcp

Set up in your AI client

Merge this template into ~/Library/Application Support/Claude/claude_desktop_config.json. Keep existing servers. Add any arguments, credentials, and permissions required by the maintainer; this template has not been install-tested.

json
{
  "mcpServers": {
    "io-dbcode-dbcode": {
      "command": "npx",
      "args": [
        "-y",
        "@dbcode/mcp"
      ]
    }
  }
}

Restart Claude Desktop completely for changes to take effect. Confirm the server appears connected in the client’s tool list, then try a read-only example from its documentation.

Claude Desktop setup reference

Package

@dbcode/mcpnpm

Compatible MCP Clients

DBCode works with any MCP-compatible client. Copy the config snippet from the Configuration section above and add it to the file shown for your client, then restart the application.

  • Claude Desktop~/Library/Application Support/Claude/claude_desktop_config.jsonRestart Claude Desktop completely for changes to take effect.
  • Cursor~/.cursor/mcp.jsonRestart Cursor for changes to take effect.
  • VS Code.vscode/mcp.jsonReload VS Code window for changes to take effect.
  • Windsurf~/.codeium/windsurf/mcp_config.jsonRestart Windsurf for changes to take effect.
  • Claude Code.mcp.jsonSave at the project root, then start Claude Code in that project and review the MCP server approval prompt. Keep real credentials out of shared files.

Learn More

MCP vs ACP: What's the Difference Between Agent Protocols?MCP connects an agent to tools and data. ACP connects an editor to an agent. They sound similar and get confused constantly, but the JetBrains-Zed backed ACP and Anthropic's MCP were built to stack on top of each other.Read articlePinterest vs Microsoft Advertising MCP ServersTwo ad platforms shipped MCP servers on the same day, one week ahead of Cannes Lions. Pinterest's is an invite-only alpha; Microsoft's is a broadly available pilot. Neither is indexed in MCPFind's directory yet. Here's the real difference between them.Read articleHome Assistant MCP Server: 4 Options Compared for ClaudeHome Assistant has no vendor-official MCP server, so four community projects fill the gap, each with a different architecture. This guide compares voska/hass-mcp, homeassistant-ai/ha-mcp, achetronic/hass-mcp, and a custom-component option so you can pick the one that matches your setup.Read article