dbcodeio/public

What it solves

DBCode provides a unified database management interface directly within VS Code and its forks (like Cursor and Windsurf), eliminating the need to switch between a code editor and a standalone database client. It specifically addresses the gap between database administration and AI-assisted development by allowing AI agents to interact with database schemas and data securely.

How it works

It functions as a VS Code extension that connects to over 90 types of databases, warehouses, and lakehouses. It integrates with the Model Context Protocol (MCP) and GitHub Copilot to provide AI agents with schema context and the ability to execute queries. It also includes built-in tools for data visualization, ER diagram generation, and SQL notebook integration.

Who it’s for

Developers and data engineers who want to manage their databases, write SQL, and collaborate with AI agents without leaving their primary IDE.

Highlights

• AI Agent Integration: Built-in MCP tools allow AI agents (like Claude Code or Copilot) to access database connections with user-controlled permissions.
• Broad Compatibility: Supports 90+ databases including SQL, NoSQL, Vector DBs (Pinecone, Milvus), and file formats like Parquet and Avro.
• Visual Tooling: Includes auto-generated ER diagrams, interactive query execution plans (EXPLAIN), and data visualization charts.
• Developer Experience: Features zero-config connection discovery from .env or config files and a full SQL editor with IntelliSense.
• Data Management: Supports inline table editing, secure encrypted report sharing, and SQL/Python notebooks.