JDBC MCP Server
OCI · GHCR.IO/IGOROLV/JDBC-MCP-SERVER:0.2.0
Read-only SQL, plans, schema for AI agents: PostgreSQL, Oracle, SQL Server, Firebird, SQLite, JDBC
Available components
Last scanned (17 hours ago)
Scores higher than 76% of OCI servers
Category Databases
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security0
- No malware scan is available for this kind of package: the supply-chain vendors we use do not cover it. This is a permanent gap in our coverage, not a finding about the package.Unverified
- Known CVEs could not be checked: this artifact ships no SBOM or dependency manifest, so there is no dependency list to read.Unverified
- Install-script risk not yet assessed.Unverified
- Dependency health could not be checked: this artifact ships no SBOM or dependency manifest, so there is no dependency list to read.Unverified
Provenance & Transparency48
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (Apache-2.0).Pass
- Actively maintained (last published 56 days ago).Pass
- Publishes a security disclosure policy (SECURITY.md).Pass
Schema Quality & AI Usability67
- AI-judged instruction clarity (good).Pass
- Context-footprint check failed: tool/resource definitions use about 5429 tokens (~110/item across 49 items; 49 tools + 0 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management100
- No destabilizing schema changes in the last 30 days.Pass
Tool Coverage91
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 67% of tool parameters carry a description.Partial
- Structured output schemas are declared (88% of tools); any adoption earns full credit.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "executeQuery" implies "execute" and declares readOnlyHint instead, contradicting what its own name says it does. See how to fix → Fail
- An AI judge read all 49 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
Unverified: 1 category
A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.
Checks we ran (12)
- Source repository
- Provenance
- License
- Maintenance
- Security disclosure
- Schema quality
- Stability
- Tool coverage
- Injection markers
- Destructive annotations
- Judged manipulation
- MCP protocol
Checks we could not complete (4)
These are gaps on our side, not findings about this package. We only credit what we can confirm, so a category made up entirely of them scores 0.
- Malware scan in Supply Chain Security (scores 0 for this)No malware scan is available for this kind of package: the supply-chain vendors we use do not cover it. This is a permanent gap in our coverage, not a finding about the package.
- Known CVEs in Supply Chain Security (scores 0 for this)Known CVEs could not be checked: this artifact ships no SBOM or dependency manifest, so there is no dependency list to read.
- Install scripts in Supply Chain Security (scores 0 for this)Install-script risk not yet assessed.
- Dependency health in Supply Chain Security (scores 0 for this)Dependency health could not be checked: this artifact ships no SBOM or dependency manifest, so there is no dependency list to read.
Does not apply to this package (2)
- Endpoint SecurityScored on hosted endpoints only. A package has no live endpoint of its own for us to probe.
- Transport & ReachabilityScored on hosted endpoints only. A package has no live endpoint of its own for us to probe.
The score does not measure everything. What the score does not measure →
Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 16 Nov 26 0
- Stability: 0.97 → pass security
- 15 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 93 to 97. That category is still filling its 30-day observation window: 28 days of observed history at the previous scan, 29 at this one. The score rises as the window fills, whether or not the server changes.
- 12 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 10 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 77 to 80. That category is still filling its 30-day observation window: 23 days of observed history at the previous scan, 24 at this one. The score rises as the window fills, whether or not the server changes.
- 8 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 70 to 73. That category is still filling its 30-day observation window: 21 days of observed history at the previous scan, 22 at this one. The score rises as the window fills, whether or not the server changes.
- 6 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 63 to 67. That category is still filling its 30-day observation window: 19 days of observed history at the previous scan, 20 at this one. The score rises as the window fills, whether or not the server changes.
- 4 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 57 to 60. That category is still filling its 30-day observation window: 17 days of observed history at the previous scan, 18 at this one. The score rises as the window fills, whether or not the server changes.
- 3 Nov 26 −6
- Stability: pass → 0.57 functional
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 21 Nov 2026 · Analysed oci/ghcr.io/igorolv/jdbc-mcp-server:0.2.0
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | oci |
| Reason | No attestation published |
Background: How many MCP packages publish verified provenance →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
analyzePlan ~164
Diagnose query-plan performance with compact structured findings: expensive nodes, large-table full scans, estimation errors, risky nested loops and disk-sort spills. Use explainQuery when the full textual plan is required. Bind '?'->params, ':name'->namedParams; never mix. E.g. :status -> namedParams={status:'PAID'} — key is the bare name.
| Name | Type | Req | Description |
|---|---|---|---|
| analyze | boolean | – | Execute the query to collect runtime stats where supported (default false). |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| namedParams | object | – | Values for ':name' placeholders, keyed by name. |
| params | array | – | Values for '?' placeholders, in order. |
| sql | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| analyzed | boolean|null | yes | True when the plan includes actual execution metrics, not only estimates. |
| diskSpills | array|null | – | Sort or hash nodes that appear to spill to disk. |
| engine | string|null | – | Database engine that produced the result, such as PostgreSQL, Oracle, SQL Server, Firebird, or SQLite. |
| estimationErrors | array|null | – | Plan nodes where actual rows differ materially from estimated rows. |
| executionTimeMs | number|null | – | Execution time reported by the database, in milliseconds when available. |
| fullScans | array|null | – | Plan nodes that perform full table or index scans and may deserve attention. |
| nodeCount | integer|null | yes | Number of table nodes in the schema graph. |
| planningTimeMs | number|null | – | Planner time reported by the database, in milliseconds when available. |
| riskyNestedLoops | array|null | – | Nested-loop nodes that may be expensive because the outer side is large. |
| root | – | – | Root node of the execution plan. |
| topExpensiveNodes | array|null | – | Plan nodes ranked as most expensive by cost or actual time. |
No examples provided.
benchmarkQuery ~224
Measure repeatable query latency with separate cold runs and min/median/max warm-run timings. Use for comparing query rewrites, not retrieving data; timedQuery is the one-run alternative that returns rows. Bind '?'->params, ':name'->namedParams; never mix. E.g. :status -> namedParams={status:'PAID'} — key is the bare name. Returns the size of the last result (rows, columns, truncated), not the rows.
| Name | Type | Req | Description |
|---|---|---|---|
| coldRuns | integer | – | Cold runs (default 1); executed first. |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| limit | integer | yes | Row limit per run (> 0). |
| namedParams | object | – | Values for ':name' placeholders, keyed by name. |
| params | array | – | Values for '?' placeholders, in order. |
| sql | string | yes | – |
| timeoutSeconds | integer | yes | Timeout per run in seconds (> 0). |
| warmRuns | integer | – | Warm runs (default 3). |
| Name | Type | Req | Description |
|---|---|---|---|
| allMs | array|null | – | Individual elapsed times for all benchmark executions, in milliseconds. |
| coldMs | – | – | Timing statistics for cold benchmark runs in milliseconds. |
| coldRuns | integer|null | yes | Number of cold runs executed before warm measurements. |
| engine | string|null | – | Database engine that produced the result, such as PostgreSQL, Oracle, SQL Server, Firebird, or SQLite. |
| limit | integer|null | yes | Row limit applied to the query or page size requested by the caller. |
| note | string|null | – | Additional context about support, limits, interpretation, or engine-specific behavior. |
| resultSize | – | – | – |
| runs | integer|null | yes | Number of measured runs included in these timing statistics. |
| timeoutSeconds | integer|null | yes | Per-statement timeout applied during execution, in seconds. |
| warmMs | – | – | Timing statistics for warm benchmark runs in milliseconds. |
| warmRuns | integer|null | yes | Number of warm runs used for the primary benchmark statistics. |
No examples provided.
columnDistribution ~116
Measure value frequency and skew for one known column by returning top-N values, counts and row shares. Use columnStats for only cardinality/extremes; runs GROUP BY + COUNT and may be expensive on large tables.
| Name | Type | Req | Description |
|---|---|---|---|
| column | string | yes | – |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | yes | – |
| topN | integer | – | Top values to return (default 20, max 1000). |
| Name | Type | Req | Description |
|---|---|---|---|
| column | string|null | – | Column whose value frequencies were measured. |
| otherRatio | number|null | yes | Share of all rows outside the returned top-N buckets, from 0.0 to 1.0. |
| otherRows | integer|null | yes | Rows not represented by the returned top-N value buckets. |
| schema | string|null | – | – |
| table | string|null | – | – |
| topN | integer|null | yes | Maximum number of most-frequent values requested for the distribution. |
| topRatio | number|null | yes | Share of all rows covered by the returned top-N buckets, from 0.0 to 1.0. |
| topRows | integer|null | yes | Rows covered by the returned top-N value buckets. |
| totalRows | integer|null | yes | Total number of rows considered for this statistic. |
| values | array|null | – | Most frequent values and their frequencies for the column. |
No examples provided.
columnHistogram ~95
Measure percentile distribution for one orderable numeric, date, timestamp or text column: min/max, P25/P50/P75/P90/P95/P99 and null counts. Use columnDistribution for top frequent values instead.
| Name | Type | Req | Description |
|---|---|---|---|
| column | string | yes | – |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| column | string|null | – | Column whose percentile distribution was measured. |
| columnType | string|null | – | Database type of the column used to choose percentile behavior. |
| max | – | – | Maximum observed non-null column value. |
| min | – | – | Minimum observed non-null column value. |
| nonNullRows | integer|null | yes | Number of rows where the column value is not NULL. |
| nullRatio | number|null | yes | Share of rows where the column value is NULL, from 0.0 to 1.0. |
| nullRows | integer|null | yes | Number of rows where the column value is NULL. |
| p25 | – | – | 25th percentile value for the column. |
| p50 | – | – | Median, or 50th percentile, value for the column. |
| p75 | – | – | 75th percentile value for the column. |
| p90 | – | – | 90th percentile value for the column. |
| p95 | – | – | 95th percentile value for the column. |
| p99 | – | – | 99th percentile value for the column. |
| percentileFunction | string|null | – | Database percentile function used, such as continuous or discrete percentile. |
| schema | string|null | – | – |
| table | string|null | – | – |
| totalRows | integer|null | yes | Total number of rows considered for this statistic. |
No examples provided.
columnStats ~86
Measure basic extremes and cardinality for one known column: total/non-null rows, distinct count and min/max. Use columnDistribution for frequent values or columnHistogram for percentiles.
| Name | Type | Req | Description |
|---|---|---|---|
| column | string | yes | – |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| column | string|null | – | Column whose basic statistics were measured. |
| distinctValues | integer|null | yes | Estimated or exact number of distinct non-null values. |
| maxValue | – | – | Maximum observed non-null value for the column. |
| minValue | – | – | Minimum observed non-null value for the column. |
| nonNullRows | integer|null | yes | Number of rows where the column value is not NULL. |
| schema | string|null | – | – |
| table | string|null | – | – |
| totalRows | integer|null | yes | Total number of rows considered for this statistic. |
No examples provided.
describeTable ~95
Inspect one known table or view. Use for its fields/columns, types, nullability, defaults, comments, keys, indexes, constraints or triggers. Returns full metadata for that object only; use tableContext when nearby relationships or joins are also needed.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| checkConstraints | array|null | – | CHECK constraints declared on the table, with raw expression and parsed allowed values when available. |
| columns | array|null | – | Column list in database order; for keys, indexes, and joins the order is significant. |
| foreignKeys | array|null | – | Outgoing foreign keys declared by the table. |
| indexes | array|null | – | Indexes available on the table or returned by an index-statistics scan. |
| name | string|null | – | – |
| primaryKey | – | – | – |
| referencedBy | array|null | – | Incoming foreign keys from other tables that reference this table (opaque). |
| remarks | string|null | – | Database comment or description attached to the object, when the driver exposes it. |
| schema | string|null | – | – |
| triggers | array|null | – | Triggers attached to the table, usually without full body unless requested (opaque). |
| type | string|null | – | Described object type, such as TABLE, VIEW, or MATERIALIZED VIEW. |
| uniqueConstraints | array|null | – | Unique constraints declared on the table. |
No examples provided.
estimateSelectivity ~96
Estimate how selective one proposed table predicate is without executing the query. Returns planner-estimated rows, the unfiltered baseline and their ratio; use when evaluating filters or composite-index column order.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| predicate | string | yes | Raw boolean SQL without WHERE or ';'. |
| schema | string | – | – |
| table | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| baselineRows | integer|null | – | Planner row estimate for the table without the predicate. |
| estimatedRows | integer|null | – | Planner or catalog estimate of rows for this object or operation. |
| note | string|null | – | Additional context about support, limits, interpretation, or engine-specific behavior. |
| predicate | string|null | – | Raw SQL predicate without the WHERE keyword used for selectivity estimation. |
| schema | string|null | – | – |
| selectivity | number|null | – | Estimated predicate selectivity, calculated as estimated rows divided by baseline rows. |
| table | string|null | – | Table on which the predicate selectivity was estimated. |
No examples provided.
executeQuery ~188
Run a read-only SQL SELECT / WITH / EXPLAIN when actual result rows are needed. Use timedQuery for one timed execution or benchmarkQuery for repeated latency measurements. Bind '?'->params, ':name'->namedParams; never mix. E.g. :status -> namedParams={status:'PAID'} — key is the bare name. Sets 'truncated' when the row cap is hit.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| limit | integer | – | Row limit (default: the connection's maxRows). |
| namedParams | object | – | Values for ':name' placeholders, keyed by name. |
| params | array | – | Values for '?' placeholders, in order. |
| sql | string | yes | – |
| timeoutSeconds | integer | – | Timeout in seconds (default: the connection's queryTimeoutSeconds). |
| Name | Type | Req | Description |
|---|---|---|---|
| columnTypes | array|null | – | Column Types. |
| columns | array|null | – | Columns. |
| rowCount | integer|null | yes | Row Count. |
| rows | array|null | – | Rows. |
| truncated | boolean|null | yes | Truncated. |
No examples provided.
explainQuery ~156
Return the full engine-specific textual execution plan for a SELECT / WITH statement. Use when raw plan detail is needed; prefer analyzePlan for compact performance findings. Bind '?'->params, ':name'->namedParams; never mix. E.g. :status -> namedParams={status:'PAID'} — key is the bare name.
| Name | Type | Req | Description |
|---|---|---|---|
| analyze | boolean | – | Execute the query to collect runtime stats where supported (default false). |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| namedParams | object | – | Values for ':name' placeholders, keyed by name. |
| params | array | – | Values for '?' placeholders, in order. |
| sql | string | yes | – |
No output schema declared.
No examples provided.
findJoinPaths ~175
Find join paths when both endpoint tables are known but the intermediate relationships are not. Traverses declared FK and optional observed join edges in both directions; for one table's immediate neighborhood, use tableContext.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| fromSchema | string | – | – |
| fromTable | string | yes | – |
| includeObserved | boolean | – | Include usage-catalog equi-joins (default: catalog enabled). |
| maxDepth | integer | – | Maximum FK hops. Default 4. |
| maxPaths | integer | – | Maximum paths to return. Default 5, max 25. |
| scanLimit | integer | – | Maximum tables to scan (default 300). |
| toSchema | string | – | – |
| toTable | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| fromSchema | string|null | – | – |
| fromTable | string|null | – | – |
| includeObserved | boolean|null | yes | True when usage-catalog observed joins were included as relationship evidence. |
| maxDepth | integer|null | yes | Maximum relationship traversal depth that was applied. |
| pathCount | integer|null | yes | Number of join paths returned after caps were applied. |
| paths | array|null | – | Join paths from the source table to the target table; each path is an ordered list of steps. |
| schemaTablesScanned | integer|null | yes | Number of schema tables inspected while searching the relationship graph. |
| toSchema | string|null | – | – |
| toTable | string|null | – | – |
No examples provided.
findQueriesByColumn ~99
Find stored application/report queries that actually reference one column and show whether it appears in SELECT, WHERE, JOIN, ORDER BY or HAVING. Use describeTable to discover declared columns; schema/table filters are optional and case-insensitive.
| Name | Type | Req | Description |
|---|---|---|---|
| column | string | yes | – |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| column | string|null | – | – |
| count | integer|null | yes | Number of matching catalog queries returned for the column. |
| matches | array|null | – | Usage-catalog matches returned for the requested table, column, or filter. |
| schema | string|null | – | – |
| table | string|null | – | Table containing the searched column. |
No examples provided.
findQueriesByTable ~86
Find stored application/report queries that actually reference one known table. Use to learn observed filters, joins and business usage, not to inspect declared table structure; resolved names are matched case-insensitively.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| count | integer|null | yes | Number of matching catalog queries returned for the table. |
| matches | array|null | – | Usage-catalog matches returned for the requested table, column, or filter. |
| schema | string|null | – | – |
| table | string|null | – | Table searched in the usage catalog. |
No examples provided.
fkIndexCoverage ~96
Audit child-side foreign keys for missing supporting indexes. Returns only FKs not covered by an index starting with the FK columns in order, plus suggested index columns; use describeTable to inspect all keys and indexes of one table.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | – | Omit to scan the schema. |
| Name | Type | Req | Description |
|---|---|---|---|
| foreignKeysTotal | integer|null | yes | Total number of foreign keys inspected for index coverage. |
| schema | string|null | – | – |
| table | string|null | – | – |
| tablesScanned | integer|null | yes | Number of tables inspected by the tool before caps were applied. |
| uncovered | array|null | – | Foreign keys that lack a supporting child-side index. |
| uncoveredCount | integer|null | yes | Number of foreign keys without a supporting child-side index. |
No examples provided.
getQuery ~135
Retrieve the complete stored record for one query whose source identity is already known. Returns SQL, parameters, parsed tables/columns/joins, outputs and field usages; use listQueries, findQueriesByTable or findQueriesByColumn to discover matching records first.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| sourceKind | string | yes | Source kind, e.g. dao, report, database-view. |
| sourcePath | string | yes | Stable source path, e.g. file path. |
| sourceUnit | string | – | Optional sub-unit, e.g. method name. |
| Name | Type | Req | Description |
|---|---|---|---|
| businessDomain | string|null | – | Business domain assigned to the catalog query or usage record. |
| businessLabel | string|null | – | – |
| columns | array|null | – | Resolved column references extracted from the known query. |
| fieldUsages | array|null | – | Semantic field usages attached to the query outputs or expressions. |
| joinPairs | array|null | – | Join pairs extracted from the query and stored in the usage catalog. |
| normalizedSql | string|null | – | Normalized SQL text produced by parser or usage-catalog indexing. |
| outputs | array|null | – | Documented output fields produced by the query. |
| parameters | array|null | – | Documented parameters for this known query. |
| parseStatus | string|null | – | SQL parse status for a catalog query, such as parsed or failed. |
| rawSql | string|null | – | Original SQL text stored in the usage catalog. |
| sourceKind | string|null | – | Kind of source that produced the catalog query, such as file, view, routine, or configured import. |
| sourcePath | string|null | – | Path or database object name where the catalog query came from. |
| sourceUnit | string|null | – | Stable unit identifier inside the source, such as query id, method name, view name, or routine name. |
| tables | array|null | – | Tables included in this context, graph, query inspection, or usage record. |
| tags | array|null | – | Business tags attached to the usage-catalog query. |
No examples provided.
getRoutineDefinition ~73
Return the source code of one known function, procedure or package, including its body where available. Use listRoutines to discover routine names.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| name | string | yes | – |
| schema | string | – | – |
No output schema declared.
No examples provided.
getTriggerDefinition ~75
Return the full definition/body of one known table trigger. For trigger names and compact metadata, use describeTable first.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | yes | – |
| trigger | string | yes | – |
No output schema declared.
No examples provided.
getViewDefinition ~74
Return the SQL text that defines one known view or materialized view. For its exposed fields, keys and other object metadata, use describeTable.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| name | string | yes | – |
| schema | string | – | – |
No output schema declared.
No examples provided.
indexStats ~84
Inspect index definitions together with operational size, usage and cardinality counters for one table or a schema. Use describeTable for structural metadata of one table without live index statistics.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | – | Omit to scan the schema. |
| Name | Type | Req | Description |
|---|---|---|---|
| indexes | array|null | – | Indexes available on the table or returned by an index-statistics scan. |
No examples provided.
inspectQuery ~84
Inspect SQL syntax and structure without accessing a database. Returns a parser-derived AST summary of tables, aliases, expressions, joins, predicates, ordering, columns and parameters; use validateQuery for driver validation or queryLint for metadata-aware advice.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| sql | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| aliases | object|null | – | Map of SQL alias to referenced table or expression. |
| columns | array|null | – | Column references extracted from all inspectable SQL clauses. |
| cteNames | array|null | – | Common table expression names declared by the query. |
| error | string|null | – | – |
| explain | boolean|null | – | True when the inspected statement is an EXPLAIN statement. |
| features | – | – | – |
| joins | array|null | – | Join clauses detected in the query. |
| normalizedSql | string|null | – | Normalized SQL text produced by parser or usage-catalog indexing. |
| orderBy | array|null | – | ORDER BY expressions in the query. |
| parameters | array|null | – | SQL placeholders or documented query parameters. |
| parseable | boolean|null | – | True when SQL parsing succeeded well enough to produce structured inspection data. |
| predicates | array|null | – | Predicate expressions extracted from WHERE, JOIN, HAVING, and related scopes. |
| selectItems | array|null | – | Expressions in the SELECT list, in output order. |
| statementType | string|null | – | Top-level SQL statement type detected by the parser. |
| tables | array|null | – | Table references extracted from the query, including CTEs and subqueries where possible. |
| warnings | array|null | – | Warnings produced while parsing and inspecting the query. |
No examples provided.
invalidateUsageCatalogCache ~72
Force the server-local usage index to be rebuilt after its configured sources change. Invalidates only the runtime/local index; the next usage lookup rebuilds it synchronously and no inspected database data is modified.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| Name | Type | Req | Description |
|---|---|---|---|
| catalogEnabled | boolean|null | yes | False when the usage catalog is disabled; true when indexing and lookups are allowed. |
| connection | string|null | – | Name of the connection this catalog belongs to. |
| indexing | boolean|null | yes | True while the usage catalog index is being built. |
| sources | array|null | – | Configured usage-catalog source paths and database-native sources considered for indexing. |
| state | string|null | – | Current usage-catalog index state, such as not_started, indexing, ready, or failed. |
No examples provided.
joinCardinality ~153
Estimate the output size and selectivity of a proposed equi-join between two known tables without executing it. Returns planner estimates for both sides and versus the Cartesian product; use findJoinPaths when the join route itself is unknown.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| fromSchema | string | – | – |
| fromTable | string | yes | – |
| joinType | string | – | Join type: INNER (default), LEFT, RIGHT, FULL |
| leftColumn | string | yes | Column in fromTable. |
| rightColumn | string | yes | Column in toTable. |
| toSchema | string | – | – |
| toTable | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| cartesianRows | integer|null | – | Product of the two side row estimates before applying join selectivity. |
| estimatedRows | integer|null | – | Planner or catalog estimate of rows for this object or operation. |
| fromRowEstimate | integer|null | – | Planner row estimate for the source table before joining. |
| fromSchema | string|null | – | – |
| fromTable | string|null | – | Left or preserved source table for the join estimate. |
| joinType | string|null | – | Join type used for the estimate or parsed join, such as INNER, LEFT, RIGHT, or FULL. |
| leftColumn | string|null | – | Column from the source table used on the left side of the join estimate. |
| note | string|null | – | Additional context about support, limits, interpretation, or engine-specific behavior. |
| rightColumn | string|null | – | Column from the target table used on the right side of the join estimate. |
| selectivityVsCartesian | number|null | – | Estimated join output divided by cartesian row count, from 0.0 to 1.0 when known. |
| toRowEstimate | integer|null | – | Planner row estimate for the target table before joining. |
| toSchema | string|null | – | – |
| toTable | string|null | – | Right or joined target table for the join estimate. |
No examples provided.
listConnections ~51
Discover the databases served here and the valid name to pass as 'connection'. Call when the target connection is not already established; returns purpose, engine, default schema and local-catalog availability without opening a database connection.
Input schema present but exposes no named parameters.
| Name | Type | Req | Description |
|---|---|---|---|
| connections | array|null | – | Configured connections, in configuration order. |
No examples provided.
listKnownDomains ~47
Discover the existing business-domain vocabulary and query counts for reuse in listQueries filters.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| Name | Type | Req | Description |
|---|---|---|---|
| domains | array|null | – | Known business domains and their usage counts. |
No examples provided.
listKnownKinds ~50
Discover valid usage-catalog source-kind values and their query counts for reuse in listQueries filters.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| Name | Type | Req | Description |
|---|---|---|---|
| kinds | array|null | – | Known source-kind values and their usage counts. |
No examples provided.
listKnownTags ~47
Discover the existing business-tag vocabulary and query counts for reuse in listQueries filters.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| Name | Type | Req | Description |
|---|---|---|---|
| tags | array|null | – | Business tags attached to the usage-catalog query. |
No examples provided.
listQueries ~196
Browse or search stored usage-catalog queries by source, business metadata, parse status or free text. Returns summaries newest-ingest first; use getQuery for the complete SQL and evidence of one selected record.
| Name | Type | Req | Description |
|---|---|---|---|
| businessDomain | string | – | Exact business domain. |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| limit | integer | – | Rows to return (default 100, max 1000). |
| offset | integer | – | Paging offset (default 0). |
| parseStatus | string | – | Parse status: parsed or failed. |
| searchText | string | – | Case-insensitive full-text search over SQL, labels, domains and source paths. |
| sourceKind | string | – | Source kind, e.g. bi-publisher-report or dao. |
| sourcePath | string | – | Source path LIKE pattern ('%'/'_'). |
| tag | string | – | Exact tag. |
| Name | Type | Req | Description |
|---|---|---|---|
| count | integer|null | yes | Number of query entries returned in this page. |
| limit | integer|null | yes | Row limit applied to the query or page size requested by the caller. |
| offset | integer|null | yes | Zero-based result offset for pagination, or true when SQL contains OFFSET depending on context. |
| queries | array|null | – | Usage-catalog query entries returned by the current filter or disabled-catalog response. |
No examples provided.
listRoutines ~86
Discover function, procedure and package names in a schema, optionally by name pattern. Use getRoutineDefinition when the source of one known routine is needed.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| namePattern | string | – | JDBC name pattern, e.g. '%calculate%'. |
| schema | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| routines | array|null | – | Function, procedure, and package entries. |
No examples provided.
listSchemas ~70
Discover schema names visible to the current user when the target schema is unknown. Use listTables next to enumerate objects in one schema.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| includeSystem | boolean | – | Include system schemas. Default false. |
| Name | Type | Req | Description |
|---|---|---|---|
| schemas | array|null | – | Schema names. |
No examples provided.
listSequences ~55
Discover sequence names and metadata in one schema, or across all schemas when schema is omitted.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| sequences | array|null | – | Sequence entries. |
No examples provided.
listTables ~148
Enumerate table and view names in a known schema, optionally filtered by name or type. Does not return fields/columns; use describeTable for one object's structure.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| namePattern | string | – | JDBC pattern ('%' any, '_' one character). |
| schema | string | – | Omit to use the connection's defaultSchema or the current schema. |
| types | string | – | JDBC table types CSV (default TABLE,VIEW,MATERIALIZED VIEW): TABLE,VIEW,MATERIALIZED VIEW,SYSTEM TABLE,GLOBAL TEMPORARY,LOCAL TEMPORARY,ALIAS,SYNONYM |
| Name | Type | Req | Description |
|---|---|---|---|
| tables | array|null | – | Table and view entries. |
No examples provided.
nullRatio ~84
Find sparse or mostly-null fields across every column of one table in a single scan. Returns null/non-null counts and ratios sorted by sparsity; use describeTable when only declared nullability is needed.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| columns | array|null | – | Per-column null-ratio entries, sorted by descending null ratio. |
| schema | string|null | – | – |
| table | string|null | – | – |
| totalRows | integer|null | yes | Total number of rows considered for this statistic. |
No examples provided.
observedRelationships ~112
Discover empirically observed equi-join column pairs from stored queries, with support counts and contributing query IDs. Use findJoinPaths for declared/combined paths between endpoints; non-equi joins are excluded.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| minSupport | integer | – | Minimum supporting queries (default 1). |
| schema | string | – | Case-insensitive filter. |
| table | string | – | Require either join side to use this table. |
| Name | Type | Req | Description |
|---|---|---|---|
| count | integer|null | yes | Number of observed relationships returned after filtering. |
| minSupport | integer|null | yes | Minimum observed support threshold applied to relationship aggregation. |
| relationships | array|null | – | Relationship edges relevant to the context, graph, or observed-relationships result. |
| schema | string|null | – | – |
| table | string|null | – | Optional table filter used when aggregating observed relationships. |
No examples provided.
queryContext ~151
Build multi-table SQL-authoring context from natural-language terms or an explicit table list. Use when relevant tables are unknown or a request spans several tables; for one known table's fields or structure, use describeTable.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| includeSamples | boolean | – | Include up to 3 rows per table (default false). |
| maxTables | integer | – | Tables to include (default 12). |
| schema | string | – | – |
| tables | string | – | Force-include tables (CSV), e.g. customers,orders. |
| terms | string | – | User terms, e.g. 'customers order totals'. |
| Name | Type | Req | Description |
|---|---|---|---|
| includeSamples | boolean|null | yes | True when small sample rows were requested for selected tables. |
| joinPaths | array|null | – | Shortest or suggested join paths between selected tables. |
| relationships | array|null | – | Relationship edges relevant to the context, graph, or observed-relationships result. |
| requestedTables | array|null | – | Explicit table names requested by the caller for query context. |
| schema | string|null | – | – |
| semanticMatches | array|null | – | Tables matched by semantic usage-catalog terms before final context assembly (opaque). |
| tableCount | integer|null | yes | Number of tables selected into the query context. |
| tables | array|null | – | Tables included in this context, graph, query inspection, or usage record. |
| terms | string|null | – | Natural-language terms used to select relevant schema context. |
No examples provided.
queryLint ~89
Review authored SQL for advisory metadata and indexing problems without executing it. Reports unknown objects, SELECT *, conditionless joins, unindexed FKs and non-leading predicate/order columns; use validateQuery when database-driver acceptance is the question.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| sql | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| inspection | object|null | – | Parsed query inspection that underpins lint (opaque; the inspectQuery tool returns the typed form). |
| lintable | boolean|null | yes | True when query lint could combine parsed SQL with metadata checks. |
| tablesChecked | array|null | – | Tables whose metadata was checked during query lint. |
| warningCount | integer|null | – | Number of warnings produced by inspection or lint. |
| warnings | array|null | – | Warnings produced by SQL inspection and metadata-aware lint checks. |
No examples provided.
rebuildCatalog ~96
Create or refresh the persistent local catalog for offline/repeated metadata and usage lookups. Captures configured schema metadata, rebuilds the usage index and returns the distributable catalog file; writes only server-local data, never the inspected database.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schemas | string | – | Schemas to capture (CSV); omit for configured/default scope. |
| Name | Type | Req | Description |
|---|---|---|---|
| catalogFile | string | yes | Absolute path of the built catalog file on disk; copy this file to distribute the catalog. |
| connection | string|null | – | Name of the connection whose catalog was rebuilt. |
| structureSchemaCount | integer|null | yes | Number of schemas captured into the structure snapshot. |
| structureSchemas | array|null | – | Schemas captured into the structure snapshot. |
| usageCatalogEnabled | boolean|null | yes | False when the usage catalog is disabled. |
| usageCatalogState | string|null | – | Usage-index state after the rebuild, e.g. not_started, indexing, ready, failed. |
| usageSourceCount | integer|null | yes | Number of usage-catalog sources considered for indexing. |
No examples provided.
redundantIndexes ~84
Find structurally overlapping non-unique indexes whose leading columns are a strict prefix of another same-type index. Unlike unusedIndexes, this does not depend on workload scan counters.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| table | string | – | Omit to scan the schema. |
| Name | Type | Req | Description |
|---|---|---|---|
| count | integer|null | yes | Number of redundant-index findings returned. |
| findings | array|null | – | Schema lint or redundant-index findings. |
| schema | string|null | – | – |
| table | string|null | – | – |
No examples provided.
resolveQueryLineage ~160
Trace a query's data lineage from direct FROM/JOIN objects through views and optionally routines to underlying physical tables. Use inspectQuery for direct AST references only; routine expansion is best-effort and may miss dynamic SQL.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| expandRoutines | boolean | – | Expand database functions/procedures referenced by the query, best-effort. Default true. |
| expandViews | boolean | – | Expand database views and materialized views recursively. Default true. |
| maxDepth | integer | – | Maximum recursive expansion depth. Default 5, max 20. |
| schema | string | – | Default schema for unqualified names |
| sql | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| cycles | array|null | – | Possible relationship or lineage cycles found during traversal. |
| directObjects | array|null | – | Objects directly referenced by the query before recursive expansion. |
| expandedObjects | array|null | – | All resolved objects visited during lineage expansion. |
| expandedPhysicalTables | array|null | – | Physical tables reached by recursively expanding views and routines. |
| inspection | object|null | – | Parsed query inspection that underpins lineage (opaque; the inspectQuery tool returns the typed form). |
| maxDepth | integer|null | yes | Maximum relationship traversal depth that was applied. |
| unresolvedObjects | array|null | – | Objects that could not be resolved against metadata during lineage analysis. |
| warnings | array|null | – | Non-fatal warnings produced while resolving or expanding lineage. |
No examples provided.
sampleRows ~98
Preview a small number of actual rows from one known table or view to understand data shape and example values. For fields, types and constraints without reading row data, use describeTable.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| limit | integer | – | Rows to return (default 10, max 100). |
| schema | string | – | – |
| table | string | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| columnTypes | array|null | – | Column Types. |
| columns | array|null | – | Columns. |
| rowCount | integer|null | yes | Row Count. |
| rows | array|null | – | Rows. |
| truncated | boolean|null | yes | Truncated. |
No examples provided.
schemaBrief ~122
Discover candidate tables and views across a schema when their names are unknown. Returns a broad plain-text map with column counts, PKs and relationship summaries; follow with queryContext for multi-table authoring detail or describeTable for one known object.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| maxTables | integer | – | Tables/views to include (default 2000). |
| schema | string | – | – |
| terms | string | – | Terms to narrow discovery; falls back to full schema on no match. |
No output schema declared.
No examples provided.
schemaGraph ~132
Analyze schema-wide relationship topology: graph nodes/edges, central or isolated tables, components, cycle hints and an optional shortest path. Use findJoinPaths when only paths between two known tables are needed.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| fromTable | string | – | Optional shortest-path start. |
| maxDepth | integer | – | Shortest-path hops (default 4). |
| maxTables | integer | – | Tables to scan (default 50). |
| schema | string | – | – |
| toTable | string | – | Optional shortest-path target. |
| Name | Type | Req | Description |
|---|---|---|---|
| centralTables | array|null | – | Highest-degree tables that are likely hubs in the schema. |
| connectedComponents | array|null | – | Connected components discovered in the schema relationship graph. |
| cycles | array|null | – | Possible relationship or lineage cycles found during traversal. |
| declaredEdgeCount | integer|null | yes | Number of graph edges backed by declared foreign keys. |
| edgeCount | integer|null | yes | Total number of relationship edges in the graph response. |
| edges | array|null | – | Relationship edges included in the graph response. |
| isolatedTables | array|null | – | Tables with no visible relationships in the scanned schema graph. |
| nodeCount | integer|null | yes | Number of table nodes in the schema graph. |
| nodes | array|null | – | Table nodes included in the schema graph response. |
| schema | string|null | – | – |
| shortestPath | – | – | – |
| tablesScanned | integer|null | yes | Number of tables inspected by the tool before caps were applied. |
No examples provided.
schemaGraphDot ~94
Export a schema or selected tables as DOT/Graphviz ERD text with columns, types, PK/FK markers and join edges. Use schemaGraph for graph metrics rather than renderable diagram source.
| Name | Type | Req | Description |
|---|---|---|---|
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| schema | string | – | – |
| tables | string | – | Tables to include (CSV); omit for all. |
No output schema declared.
No examples provided.
schemaLint ~157
Audit one table or a schema for modeling and indexing risks: missing PKs, unindexed or mismatched FKs, nullable unique columns, missing CHECKs/remarks, orphan *_id columns, isolation and wide tables. Returns findings, not general table metadata.
| Name | Type | Req | Description |
|---|---|---|---|
| checks | string | – | Checks CSV, e.g. missingPrimaryKey,fkWithoutIndex; omit for defaults. |
| connection | string | yes | Database to run against. Call listConnections for valid names; do not guess. |
| maxFindings | integer | – | Findings to return (default 200). |
| maxTables | integer | – | Tables to scan (default 50). |
| schema | string | – | – |
| table | string | – | Omit to scan the schema. |
| Name | Type | Req | Description |
|---|---|---|---|
| checks | array|null | – | Schema lint checks that were enabled for this audit. |
| findingCount | integer|null | yes | Number of lint findings returned or counted. |
| findings | array|null | – | Schema lint or redundant-index findings. |
| schema | string|null | – | – |
| table | string|null | – | – |
| tablesScanned | integer|null | yes | Number of tables inspected by the tool before caps were applied. |
| truncated | boolean|null | yes | True when the configured row or finding cap was reached and more data may exist. |
No examples provided.
How do I install the JDBC MCP Server server?
JDBC MCP Server runs locally as a container image, launched with docker run --rm -i -e JDBC_MCP_RESOURCES_ENABLED ghcr.io/igorolv/jdbc-mcp-server:0.2.0, plus the required --mount, which you supply. Ready-made configuration for Claude, Cursor, VS Code, Codex and 3 more is on this page, copied from each client's own documentation.
oci · ghcr.io/igorolv/jdbc-mcp-server:0.2.0
claude mcp add igorolv-jdbc-mcp-server -- docker run --rm -i -e JDBC_MCP_RESOURCES_ENABLED ghcr.io/igorolv/jdbc-mcp-server:0.2.0
This image reads JDBC_MCP_RESOURCES_ENABLED. Set it in your client's env block for this server; docker run -e passes it through to the container. Incomplete: the registry marks --mount as required and gives no value we can show, so it is not in this command. Add it before you run it.
What is the JDBC MCP Server server?
JDBC MCP Server is listed in the public MCP registry as io.github.igorolv/jdbc-mcp-server. Read-only SQL, plans, schema for AI agents: PostgreSQL, Oracle, SQL Server, Firebird, SQLite, JDBC. This page covers its container image (ghcr.io/igorolv/jdbc-mcp-server:0.2.0).
Is the JDBC MCP Server server safe to use?
JDBC MCP Server scores 51 out of 100 on VerifyMCP. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the JDBC MCP Server server expose?
JDBC MCP Server exposes 49 tools: rebuildCatalog, benchmarkQuery, timedQuery, listConnections, columnDistribution, and 44 more. Their descriptions and schemas cost roughly 5,429 tokens of context every time the server is loaded.
Is the JDBC MCP Server server still maintained?
JDBC MCP Server is still listed as active in the MCP registry. We last reached this channel on 21 November 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the JDBC MCP Server server under?
JDBC MCP Server declares the Apache-2.0 licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.
What did VerifyMCP test on the JDBC MCP Server server?
VerifyMCP ran 12 checks on JDBC MCP Server, covering Source repository, Provenance, License, Maintenance and 8 more. 4 items could not be completed, a gap on our side rather than a finding about JDBC MCP Server: Malware scan, Known CVEs, Install scripts and Dependency health. One category scores 0 for that reason, because we only credit what we can confirm. Endpoint Security and Transport & Reachability do not apply to a container image, so they were not tested. The score does not measure everything, and the scoring documentation lists what it leaves out.