# damms005/devdb-vscode

A zero-config VS Code database extension with affordances to aid development and debugging.

Repository: https://github.com/damms005/devdb-vscode
Canonical: https://ross.abutalabs.com/products/devdb-vscode
Homepage: https://marketplace.visualstudio.com/items?itemName=damms005.devdb
Language: TypeScript
License: MIT
License Family: permissive
Last push: 2026-08-20T10:48:43+00:00

## Health v2 (maintenance only)
Score: 85/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 98, release rhythm 72, longevity 79
- inputs: {"age_days": 1119, "days_push": 13, "days_rel": 111, "gap_med": 0, "n_releases_24m": 64}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1429, forks 40 (observed 2026-08-28T04:04:42.199600+00:00)

## What it is
DevDb is a zero-config VS Code extension that auto-discovers your project's database and displays its records and schema directly inside the editor to aid development and debugging. It supports engines like MySQL, MariaDB, PostgreSQL, SQLite, MongoDB, Redis, ClickHouse, and DuckDB, and can expose database context to AI IDEs through an MCP server.

## Use cases
- view and browse database tables inside vscode without switching apps
- zero-config database extension for vs code
- inspect mysql database in a laravel sail or ddev project while coding
- generate eloquent models from the database schema
- open a specific table quickly with a keyboard shortcut
- give my database schema to cursor or windsurf via mcp
- search similar rows with pgvector embeddings from the editor

## When to choose
- You develop locally against MySQL, PostgreSQL, SQLite, MongoDB, or Redis and want data visible in VS Code with no manual configuration
- You use Laravel, DDEV, Adonis, Supabase, or containerized setups and want automatic database discovery plus framework-specific affordances
- You want an MCP server that hands database schema and records to AI-powered IDEs

## When to avoid
- You need a full standalone database GUI with administration, user management, or advanced import/export tooling
- You do not use VS Code or an MCP-capable editor, since DevDb is built as a VS Code extension
- You only need to run complex ad-hoc SQL analytics rather than inspect and debug app data during development

## Facets
- artifact type: plugin
- maturity: active
- function: database, developer-tools, mcp
- domain: databases, developer-tools
- platform: editor-plugin
- tags: vscode-extension, database-client, database-gui, sql, mysql, postgresql, sqlite, mongodb, redis, zero-config, laravel, ddev, supabase, mcp-server, local-development

## Member repositories
- damms005/devdb-vscode (main) score 85

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:42.199600+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:37:15.132814+00:00, confidence not recorded.
  - readme: https://github.com/damms005/devdb-vscode (fetched 2026-08-28T04:04:42.199600+00:00, sha 196207dd00e2)
  - homepage: https://marketplace.visualstudio.com/items?itemName=damms005.devdb (fetched 2026-08-29T11:49:12.280494+00:00, sha da4f0c6f7854)
  - site_page: https://code.visualstudio.com/docs/devcontainers/containers (fetched 2026-08-29T11:49:12.290837+00:00, sha 7917fb21c496)
  - site_page: https://code.visualstudio.com/docs/editor/multi-root-workspaces (fetched 2026-08-29T11:49:12.294139+00:00, sha 4c183cbef945)
  - site_page: https://code.visualstudio.com/docs/copilot/customization/mcp-servers (fetched 2026-08-29T11:49:12.296529+00:00, sha 73ece74e9e5a)
- Data as of 2026-08-30T08:39:29.467469+00:00.
