Query and manage databases directly from your IDE

DevDb is a VS Code extension that auto-loads a project's database and layers development/debugging affordances on top of it: a dedicated database client view, IDE-integrated Eloquent Model factory generation and CodeLens for Laravel, a right-click SQL query explainer, and an MCP server that exposes the connected database's schema and query execution to AI-powered IDEs and MCP clients.

Use DevDb when working inside VS Code (or a VS Code-based IDE such as Cursor or Windsurf) on a project backed by SQLite, MySQL, MariaDB, PostgreSQL, or Microsoft SQL Server - the free tier covers all of these plus Supabase, with zero-config auto-discovery for DDEV, Adonis, Django, Ruby on Rails, and Laravel projects. Reach for the Pro license specifically when the database is MongoDB, sits over an SSH tunnel, is Supabase Cloud, is Redis/Valkey, ClickHouse, DuckDB or Neon, or needs PostgreSQL vector (pgvector) search - the free tier does not include these. It requires VS Code 1.83 or newer and is not supported on Ubuntu 20.04 or older, since those distros are EOL on the GitHub Actions runners DevDb builds against.

Input is a live database connection - either auto-discovered zero-config from a supported framework's own config files, or declared explicitly in a project-root .devdbrc JSON file, which gets IntelliSense, JSON Schema validation, and quick-insert snippets per database type. Output is an interactive table browser with inline editing, deletion, null-setting, and JSON preview, plus data export to JSON or SQL INSERT statements; through the MCP server, output is instead structured tool responses (get-tables, get-schema, get-database-type, run-query) that an AI client can query directly.

An MCP server ships built in. For Claude Code, add it with the script path copied from DevDb's own UI (via its hammer icon):

claude mcp add --transport stdio devdb-mcp-server node "<paste-script-path-here>"

Other VS Code-based IDEs (Cursor, Windsurf, Cline) instead paste a copied MCP config JSON into their own config file (.vscode/mcp.json, ~/.cursor/mcp.json, or ~/.codeium/windsurf/mcp_config.json). DevDb also integrates directly with Laravel (Eloquent Model CodeLens and factory generation, MySQL query-plan explanation via MySQL Visual Explain), and provides a custom vscode://devdb/open/table URI handler for opening a specific table from an external link or tool.

Developers who want to inspect and edit their application's database without leaving VS Code, and teams building AI-assisted workflows - Laravel, Rails, Django, Adonis, or DDEV projects especially, given the zero-config support - that want an AI IDE to query the real database schema through MCP rather than guessing from code alone.