# Igorolv Jdbc MCP server

Source: https://glimind.com/server/mcp-registry%2Fio.github.igorolv%2Fjdbc-mcp-server
Registry id: `mcp-registry/io.github.igorolv/jdbc-mcp-server`
Status: unknown

## Tools (41)

- `analyzePlan`: Compact LLM-oriented plan summary instead of raw plan dump
- `benchmarkQuery`: Run query multiple times and return timing statistics
- `columnDistribution`: Top-N most frequent values of a column plus their share
- `columnHistogram`: Percentiles P25/P50/P75/P90/P95/P99 plus min, max, null count
- `columnStats`: Basic column statistics: total_rows, non_null_rows, distinct_values, min, max
- `describeTable`: Full object description: columns, keys, indexes, constraints, triggers
- `executeQuery`: Execute a SELECT, WITH, or EXPLAIN statement
- `explainQuery`: Return the execution plan for a query
- `findJoinPaths`: Find JOIN paths between two tables through FKs
- `findQueriesByColumn`: All catalog queries that reference a given column
- `findQueriesByTable`: All catalog queries that reference a given table
- `getQuery`: Full record selected by sourceKind, sourcePath, and optional sourceUnit
- `getRoutineDefinition`: Function or procedure source code
- `getTriggerDefinition`: Trigger body for one named trigger
- `getViewDefinition`: SQL definition of a view
- `inspectQuery`: Parse SQL and return AST summary without touching database
- `invalidateUsageCatalogCache`: Drop the runtime index; next lookup rebuilds synchronously
- `listConnections`: List databases this server serves
- `listKnownDomains`: BusinessDomain values currently used in the catalog
- `listKnownKinds`: Source-kinds currently used in the catalog with query counts
- `listKnownTags`: Tags currently used in the catalog with query counts
- `listQueries`: Paginated listing with optional filters
- `listRoutines`: List functions, procedures, and packages in a schema
- `listSchemas`: List schemas, hiding system schemas by default
- `listSequences`: List sequences in one schema or across schemas
- `listTables`: List tables and views in a schema
- `observedRelationships`: Aggregate observed equi-join pairs across stored queries
- `queryContext`: Build compact SQL-authoring context from search terms or tables
- `queryLint`: Parse SQL and return advisory warnings combining AST with metadata
- `rebuildCatalog`: Rebuild persistent structure snapshot and usage index
- `resolveQueryLineage`: Resolve direct objects and expand views/routines to underlying tables
- `sampleRows`: Return a few rows from a table or view
- `schemaBrief`: Plain-text full-schema map for SQL authoring
- `schemaGraph`: Schema relationship graph metrics and shortest path
- `schemaGraphDot`: DOT/Graphviz representation of schema relationship graph
- `schemaLint`: Schema lint audit for missing keys, indexes, constraints
- `searchObjects`: Case-insensitive substring search across database objects
- `tableContext`: Context around one table including FK parents and children
- `timedQuery`: Execute query with wall-clock elapsed time and pg_stat_statements diff
- `usageCatalogStatus`: Current catalog state, enabled flag, and configured sources
- `validateQuery`: Validate syntax without execution

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.
