db-introspector-mcp
Allows introspection of PostgreSQL databases, providing tools to list tables, describe tables, list foreign keys, summarize the schema, and generate Graphviz DOT ER diagrams.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@db-introspector-mcp generate an ER diagram of my database"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
@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 faltanpm install && npm run buildpara que el bin local exista. Sin eso,npxfalla condb-introspector-mcp: not foundy el MCP se queda cargando.
Related MCP server: PostgreSQL MCP Server
Install / run
npx -y @0pvalencia/db-introspector-mcpLocal
npm install
npm run build
npm startTools
list_tables/describe_table/list_foreign_keysschema_summaryer_dot→ pasar a diagram-studio-mcp (engine=graphviz)
Requiere DATABASE_URL.
Requiere DATABASE_URL.
License
MIT
Available Tools
5 toolsdescribe_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
Scored across 5 tools
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.
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.
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.
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
Related MCP Connectors
Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.
MCP server for interacting with the Supabase platform
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Managed Postgres MCP: projects, SQL, docs search, and storage buckets via OAuth.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceAn 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 npmMIT
- AlicenseNot gradedqualityDmaintenanceA 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
- AlicenseNot gradedqualityCmaintenanceA Python MCP server that enables schema discovery, read-only SQL queries, table previews, and index/relationship analysis on PostgreSQL databases.1MIT
- AlicenseAqualityDmaintenanceMCP server for PostgreSQL that enables schema exploration, safe SQL execution, EXPLAIN analysis, health checks, and index recommendations across multiple databases.10123 npmMIT