# igorolv/jdbc-mcp-server

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

## Tools (46)

- `analyzePlan`: Compact LLM-oriented plan summary with cost and risk analysis
- `benchmarkQuery`: Run query multiple times and return timing statistics
- `columnDistribution`: Top-N most frequent values of a column with share
- `columnHistogram`: Percentiles P25-P99 plus min, max, and null count
- `columnStats`: Basic column statistics: total, non-null, distinct, min, max
- `describeTable`: Full object description: columns, keys, indexes, constraints
- `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`: Find catalog queries referencing a given column
- `findQueriesByTable`: Find catalog queries referencing a given table
- `fkIndexCoverage`: Check FK index coverage
- `getQuery`: Full record of a catalog query
- `getRoutineDefinition`: Get function or procedure source code
- `getTriggerDefinition`: Get trigger body for a named trigger
- `getViewDefinition`: Get SQL definition of a view
- `indexStats`: Index statistics
- `inspectQuery`: Parse SQL and return AST summary without touching database
- `invalidateUsageCatalogCache`: Drop runtime index, rebuild on next lookup
- `listConnections`: List databases this server serves
- `listKnownDomains`: List business domains used in catalog with counts
- `listKnownKinds`: List source kinds used in catalog with counts
- `listKnownTags`: List tags used in catalog with query counts
- `listQueries`: Paginated listing of catalog queries with 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 from metadata checks
- `rebuildCatalog`: Rebuild persistent structure snapshot and usage index
- `redundantIndexes`: Find redundant indexes
- `resolveQueryLineage`: Resolve objects referenced by query and expand views to base 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 common design issues
- `searchObjects`: Case-insensitive substring search across database objects
- `tableContext`: Context around one table with FK parents and children
- `tableStats`: Table statistics
- `timedQuery`: Execute query with wall-clock timing and pg_stat_statements diff
- `unusedIndexes`: Find unused indexes
- `usageCatalogStatus`: Current usage catalog state and configuration
- `validateQuery`: Validate syntax without execution, with read-only guard

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