MCPSERV.CLUB
damms005

DevDb

MCP Server

Auto‑load databases for instant development and debugging

Active(95)
1.1kstars
1views
Updated 12 days ago

About

DevDb is a lightweight VS Code extension that automatically discovers your local database and exposes it via an MCP server, enabling AI‑powered IDEs and tools like Cursor or Windsurf to access tables, generate models, and provide context‑aware affordances.

Capabilities

Resources
Access data sources
Tools
Execute functions
Prompts
Pre-built templates
Sampling
AI model interactions

DevDb – Your Database‑First MCP Server for Modern IDEs

DevDb solves a common pain point in full‑stack development: connecting an AI assistant or IDE to the live database that powers your application. Without a reliable bridge, developers must rely on ad‑hoc tools or manual queries to inspect data, generate migrations, or debug ORM issues. DevDb eliminates this friction by acting as a lightweight MCP server that automatically discovers, loads, and exposes the database schema to AI clients such as Cursor or Windsurf. This allows assistants to answer questions about tables, columns, relationships, and even generate code snippets on demand—all within the context of your running project.

At its core, DevDb provides a zero‑config database auto‑discovery feature. Whether you’re running a Laravel Sail container, a DDEV environment, or a standard Django project, the extension scans your application for database configuration files and establishes a connection without any manual setup. Once connected, the MCP server publishes rich database affordances that empower developers: one‑click generation of Eloquent model factories, automatic creation of seeders, and real‑time table previews. These affordances are delivered through the MCP protocol, making them consumable by any compliant AI assistant or IDE extension.

Key capabilities include:

  • MCP Server Interface – Exposes database connections, schema metadata, and affordances to any MCP client.
  • Quick Table Access – A single keybinding ( / ) opens a searchable table picker, letting you jump straight to the data you need.
  • IDE‑Level Integrations – CodeLens and context menu entries appear directly in your editor, allowing you to open tables from model files or invoke SQL query explainers with a click.
  • Zero‑Config Support for Popular Stacks – Built‑in detection for Laravel, Django, Rails, Adonis, and other containerized setups.
  • Developer‑Focused UX – A lightweight, intuitive UI that keeps your focus on coding while providing instant database insights.

Real‑world use cases span the entire development lifecycle. During debugging, a developer can ask an AI assistant to “show me the last 10 rows of ” and receive a formatted table instantly. When refactoring, the assistant can suggest appropriate column types or generate migration files. For performance tuning, an AI client can call a SQL explainer service and display the results directly in the IDE. Because DevDb operates as an MCP server, any tool that supports the protocol—whether a custom in‑house assistant or a community plugin—can tap into these features without reinventing the wheel.

In summary, DevDb transforms database interactions from a manual, fragmented process into an integrated, AI‑powered workflow. By automatically exposing schema information and affordances through MCP, it gives developers immediate, context‑aware access to their data layer—streamlining debugging, code generation, and performance analysis across a variety of modern web frameworks.