Skip to main content
Glama
db-introspector-mcp

db-introspector-mcp

by 0PValencia

@0pvalencia/db-introspector-mcp

MCP introspector PostgreSQL (tablas, FKs, DOT ER).

Cursor / Claude / VS Code

Local (recomendado si clonas el repo)

{
  "mcpServers": {
    "db-introspector": {
      "command": "node",
      "args": ["/ABSOLUTE/PATH/TO/db-introspector-mcp/dist/cli.js"]
    }
  }
}

Tras clonar: npm install && npm run build.

npx (sin clonar)

{
  "mcpServers": {
    "db-introspector": {
      "command": "npx",
      "args": ["-y", "@0pvalencia/db-introspector-mcp"]
    }
  }
}

Si abres este repo en Cursor y usas npx, hace falta npm install && npm run build para que el bin local exista. Sin eso, npx falla con db-introspector-mcp: not found y el MCP se queda cargando.

Related MCP server: PostgreSQL MCP Server

Install / run

npx -y @0pvalencia/db-introspector-mcp

Local

npm install
npm run build
npm start

Tools

  • list_tables / describe_table / list_foreign_keys

  • schema_summary

  • er_dot → pasar a diagram-studio-mcp (engine=graphviz)

Requiere DATABASE_URL.

Requiere DATABASE_URL.

License

MIT

Available Tools

5 tools
describe_tableDescribir tablaC

Columnas, tipos y nullability.

Inputs: table (required), schema.

er_dotGenerar DOT (ER)B

Graphviz DOT a partir de tablas + FKs. Pásalo a diagram-studio render_diagram engine=graphviz.

Inputs: schema.

list_foreign_keysListar FKsC

Foreign keys del schema.

Inputs: schema.

list_tablesListar tablasC

Tablas de un schema (default public).

Inputs: schema.

schema_summaryResumen de schemaB

Conteo de tablas, FKs y lista compacta.

Inputs: schema.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.1/5.0

    Scored across 5 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: listing tables, describing a table's columns, listing foreign keys, generating an ER diagram in DOT format, and providing a schema summary. There is no overlap or ambiguity between them.

    Naming Consistency4/5

    Most tools follow a verb_noun pattern (list_tables, describe_table, list_foreign_keys), while er_dot and schema_summary use noun phrases. The style is still consistent (lowercase with underscores) and the deviations are minor and understandable.

    Tool Count5/5

    Five tools is a well-scoped count for a database introspector. Each tool covers a specific aspect of schema discovery and diagram generation without unnecessary bloat or missing essentials.

    Completeness4/5

    The tool set covers core introspection needs: tables, columns, foreign keys, ER diagram generation, and a summary. Minor gaps like indexes or views are missing, but the current surface is sufficient for typical schema exploration and diagram workflows.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      An open-source MCP server for PostgreSQL schema introspection and guarded read-only queries. It enables MCP clients to discover schemas, tables, columns, indexes, relationships, and safe queryable data from a configured PostgreSQL database.
      11 npm
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server that enables connecting to PostgreSQL databases and executing queries, listing tables, retrieving schema, and obtaining database statistics through MCP tools.
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      A Python MCP server that enables schema discovery, read-only SQL queries, table previews, and index/relationship analysis on PostgreSQL databases.
      1
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      MCP server for PostgreSQL that enables schema exploration, safe SQL execution, EXPLAIN analysis, health checks, and index recommendations across multiple databases.
      10
      123 npm
      MIT