Skip to content
verify mcp Beta VerifyMCP is currently in beta. If you notice any issues, get in touch and we’ll put it right.

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

+1 this week 51 Trust /100

Last scanned (17 hours ago)

Scores higher than 76% of OCI servers

Category Databases

Trust breakdown (7 categories)

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.

What we tested

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 →

Changelog

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
Diagnostics

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 →

MCP tools · 49 exposed · ~5,429 tokens

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 →

Tool Tokens
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.

NameTypeReqDescription
analyzeboolean–Execute the query to collect runtime stats where supported (default false).
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
namedParamsobject–Values for ':name' placeholders, keyed by name.
paramsarray–Values for '?' placeholders, in order.
sqlstringyes–
NameTypeReqDescription
analyzedboolean|nullyesTrue when the plan includes actual execution metrics, not only estimates.
diskSpillsarray|null–Sort or hash nodes that appear to spill to disk.
enginestring|null–Database engine that produced the result, such as PostgreSQL, Oracle, SQL Server, Firebird, or SQLite.
estimationErrorsarray|null–Plan nodes where actual rows differ materially from estimated rows.
executionTimeMsnumber|null–Execution time reported by the database, in milliseconds when available.
fullScansarray|null–Plan nodes that perform full table or index scans and may deserve attention.
nodeCountinteger|nullyesNumber of table nodes in the schema graph.
planningTimeMsnumber|null–Planner time reported by the database, in milliseconds when available.
riskyNestedLoopsarray|null–Nested-loop nodes that may be expensive because the outer side is large.
root––Root node of the execution plan.
topExpensiveNodesarray|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.

NameTypeReqDescription
coldRunsinteger–Cold runs (default 1); executed first.
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
limitintegeryesRow limit per run (> 0).
namedParamsobject–Values for ':name' placeholders, keyed by name.
paramsarray–Values for '?' placeholders, in order.
sqlstringyes–
timeoutSecondsintegeryesTimeout per run in seconds (> 0).
warmRunsinteger–Warm runs (default 3).
NameTypeReqDescription
allMsarray|null–Individual elapsed times for all benchmark executions, in milliseconds.
coldMs––Timing statistics for cold benchmark runs in milliseconds.
coldRunsinteger|nullyesNumber of cold runs executed before warm measurements.
enginestring|null–Database engine that produced the result, such as PostgreSQL, Oracle, SQL Server, Firebird, or SQLite.
limitinteger|nullyesRow limit applied to the query or page size requested by the caller.
notestring|null–Additional context about support, limits, interpretation, or engine-specific behavior.
resultSize–––
runsinteger|nullyesNumber of measured runs included in these timing statistics.
timeoutSecondsinteger|nullyesPer-statement timeout applied during execution, in seconds.
warmMs––Timing statistics for warm benchmark runs in milliseconds.
warmRunsinteger|nullyesNumber 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.

NameTypeReqDescription
columnstringyes–
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestringyes–
topNinteger–Top values to return (default 20, max 1000).
NameTypeReqDescription
columnstring|null–Column whose value frequencies were measured.
otherRationumber|nullyesShare of all rows outside the returned top-N buckets, from 0.0 to 1.0.
otherRowsinteger|nullyesRows not represented by the returned top-N value buckets.
schemastring|null––
tablestring|null––
topNinteger|nullyesMaximum number of most-frequent values requested for the distribution.
topRationumber|nullyesShare of all rows covered by the returned top-N buckets, from 0.0 to 1.0.
topRowsinteger|nullyesRows covered by the returned top-N value buckets.
totalRowsinteger|nullyesTotal number of rows considered for this statistic.
valuesarray|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.

NameTypeReqDescription
columnstringyes–
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestringyes–
NameTypeReqDescription
columnstring|null–Column whose percentile distribution was measured.
columnTypestring|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.
nonNullRowsinteger|nullyesNumber of rows where the column value is not NULL.
nullRationumber|nullyesShare of rows where the column value is NULL, from 0.0 to 1.0.
nullRowsinteger|nullyesNumber 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.
percentileFunctionstring|null–Database percentile function used, such as continuous or discrete percentile.
schemastring|null––
tablestring|null––
totalRowsinteger|nullyesTotal 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.

NameTypeReqDescription
columnstringyes–
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestringyes–
NameTypeReqDescription
columnstring|null–Column whose basic statistics were measured.
distinctValuesinteger|nullyesEstimated 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.
nonNullRowsinteger|nullyesNumber of rows where the column value is not NULL.
schemastring|null––
tablestring|null––
totalRowsinteger|nullyesTotal 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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestringyes–
NameTypeReqDescription
checkConstraintsarray|null–CHECK constraints declared on the table, with raw expression and parsed allowed values when available.
columnsarray|null–Column list in database order; for keys, indexes, and joins the order is significant.
foreignKeysarray|null–Outgoing foreign keys declared by the table.
indexesarray|null–Indexes available on the table or returned by an index-statistics scan.
namestring|null––
primaryKey–––
referencedByarray|null–Incoming foreign keys from other tables that reference this table (opaque).
remarksstring|null–Database comment or description attached to the object, when the driver exposes it.
schemastring|null––
triggersarray|null–Triggers attached to the table, usually without full body unless requested (opaque).
typestring|null–Described object type, such as TABLE, VIEW, or MATERIALIZED VIEW.
uniqueConstraintsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
predicatestringyesRaw boolean SQL without WHERE or ';'.
schemastring––
tablestringyes–
NameTypeReqDescription
baselineRowsinteger|null–Planner row estimate for the table without the predicate.
estimatedRowsinteger|null–Planner or catalog estimate of rows for this object or operation.
notestring|null–Additional context about support, limits, interpretation, or engine-specific behavior.
predicatestring|null–Raw SQL predicate without the WHERE keyword used for selectivity estimation.
schemastring|null––
selectivitynumber|null–Estimated predicate selectivity, calculated as estimated rows divided by baseline rows.
tablestring|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
limitinteger–Row limit (default: the connection's maxRows).
namedParamsobject–Values for ':name' placeholders, keyed by name.
paramsarray–Values for '?' placeholders, in order.
sqlstringyes–
timeoutSecondsinteger–Timeout in seconds (default: the connection's queryTimeoutSeconds).
NameTypeReqDescription
columnTypesarray|null–Column Types.
columnsarray|null–Columns.
rowCountinteger|nullyesRow Count.
rowsarray|null–Rows.
truncatedboolean|nullyesTruncated.

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.

NameTypeReqDescription
analyzeboolean–Execute the query to collect runtime stats where supported (default false).
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
namedParamsobject–Values for ':name' placeholders, keyed by name.
paramsarray–Values for '?' placeholders, in order.
sqlstringyes–

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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
fromSchemastring––
fromTablestringyes–
includeObservedboolean–Include usage-catalog equi-joins (default: catalog enabled).
maxDepthinteger–Maximum FK hops. Default 4.
maxPathsinteger–Maximum paths to return. Default 5, max 25.
scanLimitinteger–Maximum tables to scan (default 300).
toSchemastring––
toTablestringyes–
NameTypeReqDescription
fromSchemastring|null––
fromTablestring|null––
includeObservedboolean|nullyesTrue when usage-catalog observed joins were included as relationship evidence.
maxDepthinteger|nullyesMaximum relationship traversal depth that was applied.
pathCountinteger|nullyesNumber of join paths returned after caps were applied.
pathsarray|null–Join paths from the source table to the target table; each path is an ordered list of steps.
schemaTablesScannedinteger|nullyesNumber of schema tables inspected while searching the relationship graph.
toSchemastring|null––
toTablestring|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.

NameTypeReqDescription
columnstringyes–
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestring––
NameTypeReqDescription
columnstring|null––
countinteger|nullyesNumber of matching catalog queries returned for the column.
matchesarray|null–Usage-catalog matches returned for the requested table, column, or filter.
schemastring|null––
tablestring|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestringyes–
NameTypeReqDescription
countinteger|nullyesNumber of matching catalog queries returned for the table.
matchesarray|null–Usage-catalog matches returned for the requested table, column, or filter.
schemastring|null––
tablestring|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestring–Omit to scan the schema.
NameTypeReqDescription
foreignKeysTotalinteger|nullyesTotal number of foreign keys inspected for index coverage.
schemastring|null––
tablestring|null––
tablesScannedinteger|nullyesNumber of tables inspected by the tool before caps were applied.
uncoveredarray|null–Foreign keys that lack a supporting child-side index.
uncoveredCountinteger|nullyesNumber 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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
sourceKindstringyesSource kind, e.g. dao, report, database-view.
sourcePathstringyesStable source path, e.g. file path.
sourceUnitstring–Optional sub-unit, e.g. method name.
NameTypeReqDescription
businessDomainstring|null–Business domain assigned to the catalog query or usage record.
businessLabelstring|null––
columnsarray|null–Resolved column references extracted from the known query.
fieldUsagesarray|null–Semantic field usages attached to the query outputs or expressions.
joinPairsarray|null–Join pairs extracted from the query and stored in the usage catalog.
normalizedSqlstring|null–Normalized SQL text produced by parser or usage-catalog indexing.
outputsarray|null–Documented output fields produced by the query.
parametersarray|null–Documented parameters for this known query.
parseStatusstring|null–SQL parse status for a catalog query, such as parsed or failed.
rawSqlstring|null–Original SQL text stored in the usage catalog.
sourceKindstring|null–Kind of source that produced the catalog query, such as file, view, routine, or configured import.
sourcePathstring|null–Path or database object name where the catalog query came from.
sourceUnitstring|null–Stable unit identifier inside the source, such as query id, method name, view name, or routine name.
tablesarray|null–Tables included in this context, graph, query inspection, or usage record.
tagsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
namestringyes–
schemastring––

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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestringyes–
triggerstringyes–

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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
namestringyes–
schemastring––

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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestring–Omit to scan the schema.
NameTypeReqDescription
indexesarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
sqlstringyes–
NameTypeReqDescription
aliasesobject|null–Map of SQL alias to referenced table or expression.
columnsarray|null–Column references extracted from all inspectable SQL clauses.
cteNamesarray|null–Common table expression names declared by the query.
errorstring|null––
explainboolean|null–True when the inspected statement is an EXPLAIN statement.
features–––
joinsarray|null–Join clauses detected in the query.
normalizedSqlstring|null–Normalized SQL text produced by parser or usage-catalog indexing.
orderByarray|null–ORDER BY expressions in the query.
parametersarray|null–SQL placeholders or documented query parameters.
parseableboolean|null–True when SQL parsing succeeded well enough to produce structured inspection data.
predicatesarray|null–Predicate expressions extracted from WHERE, JOIN, HAVING, and related scopes.
selectItemsarray|null–Expressions in the SELECT list, in output order.
statementTypestring|null–Top-level SQL statement type detected by the parser.
tablesarray|null–Table references extracted from the query, including CTEs and subqueries where possible.
warningsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
NameTypeReqDescription
catalogEnabledboolean|nullyesFalse when the usage catalog is disabled; true when indexing and lookups are allowed.
connectionstring|null–Name of the connection this catalog belongs to.
indexingboolean|nullyesTrue while the usage catalog index is being built.
sourcesarray|null–Configured usage-catalog source paths and database-native sources considered for indexing.
statestring|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
fromSchemastring––
fromTablestringyes–
joinTypestring–Join type: INNER (default), LEFT, RIGHT, FULL
leftColumnstringyesColumn in fromTable.
rightColumnstringyesColumn in toTable.
toSchemastring––
toTablestringyes–
NameTypeReqDescription
cartesianRowsinteger|null–Product of the two side row estimates before applying join selectivity.
estimatedRowsinteger|null–Planner or catalog estimate of rows for this object or operation.
fromRowEstimateinteger|null–Planner row estimate for the source table before joining.
fromSchemastring|null––
fromTablestring|null–Left or preserved source table for the join estimate.
joinTypestring|null–Join type used for the estimate or parsed join, such as INNER, LEFT, RIGHT, or FULL.
leftColumnstring|null–Column from the source table used on the left side of the join estimate.
notestring|null–Additional context about support, limits, interpretation, or engine-specific behavior.
rightColumnstring|null–Column from the target table used on the right side of the join estimate.
selectivityVsCartesiannumber|null–Estimated join output divided by cartesian row count, from 0.0 to 1.0 when known.
toRowEstimateinteger|null–Planner row estimate for the target table before joining.
toSchemastring|null––
toTablestring|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.

NameTypeReqDescription
connectionsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
NameTypeReqDescription
domainsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
NameTypeReqDescription
kindsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
NameTypeReqDescription
tagsarray|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.

NameTypeReqDescription
businessDomainstring–Exact business domain.
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
limitinteger–Rows to return (default 100, max 1000).
offsetinteger–Paging offset (default 0).
parseStatusstring–Parse status: parsed or failed.
searchTextstring–Case-insensitive full-text search over SQL, labels, domains and source paths.
sourceKindstring–Source kind, e.g. bi-publisher-report or dao.
sourcePathstring–Source path LIKE pattern ('%'/'_').
tagstring–Exact tag.
NameTypeReqDescription
countinteger|nullyesNumber of query entries returned in this page.
limitinteger|nullyesRow limit applied to the query or page size requested by the caller.
offsetinteger|nullyesZero-based result offset for pagination, or true when SQL contains OFFSET depending on context.
queriesarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
namePatternstring–JDBC name pattern, e.g. '%calculate%'.
schemastring––
NameTypeReqDescription
routinesarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
includeSystemboolean–Include system schemas. Default false.
NameTypeReqDescription
schemasarray|null–Schema names.

No examples provided.

listSequences ~55

Discover sequence names and metadata in one schema, or across all schemas when schema is omitted.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
NameTypeReqDescription
sequencesarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
namePatternstring–JDBC pattern ('%' any, '_' one character).
schemastring–Omit to use the connection's defaultSchema or the current schema.
typesstring–JDBC table types CSV (default TABLE,VIEW,MATERIALIZED VIEW): TABLE,VIEW,MATERIALIZED VIEW,SYSTEM TABLE,GLOBAL TEMPORARY,LOCAL TEMPORARY,ALIAS,SYNONYM
NameTypeReqDescription
tablesarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestringyes–
NameTypeReqDescription
columnsarray|null–Per-column null-ratio entries, sorted by descending null ratio.
schemastring|null––
tablestring|null––
totalRowsinteger|nullyesTotal 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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
minSupportinteger–Minimum supporting queries (default 1).
schemastring–Case-insensitive filter.
tablestring–Require either join side to use this table.
NameTypeReqDescription
countinteger|nullyesNumber of observed relationships returned after filtering.
minSupportinteger|nullyesMinimum observed support threshold applied to relationship aggregation.
relationshipsarray|null–Relationship edges relevant to the context, graph, or observed-relationships result.
schemastring|null––
tablestring|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
includeSamplesboolean–Include up to 3 rows per table (default false).
maxTablesinteger–Tables to include (default 12).
schemastring––
tablesstring–Force-include tables (CSV), e.g. customers,orders.
termsstring–User terms, e.g. 'customers order totals'.
NameTypeReqDescription
includeSamplesboolean|nullyesTrue when small sample rows were requested for selected tables.
joinPathsarray|null–Shortest or suggested join paths between selected tables.
relationshipsarray|null–Relationship edges relevant to the context, graph, or observed-relationships result.
requestedTablesarray|null–Explicit table names requested by the caller for query context.
schemastring|null––
semanticMatchesarray|null–Tables matched by semantic usage-catalog terms before final context assembly (opaque).
tableCountinteger|nullyesNumber of tables selected into the query context.
tablesarray|null–Tables included in this context, graph, query inspection, or usage record.
termsstring|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
sqlstringyes–
NameTypeReqDescription
inspectionobject|null–Parsed query inspection that underpins lint (opaque; the inspectQuery tool returns the typed form).
lintableboolean|nullyesTrue when query lint could combine parsed SQL with metadata checks.
tablesCheckedarray|null–Tables whose metadata was checked during query lint.
warningCountinteger|null–Number of warnings produced by inspection or lint.
warningsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemasstring–Schemas to capture (CSV); omit for configured/default scope.
NameTypeReqDescription
catalogFilestringyesAbsolute path of the built catalog file on disk; copy this file to distribute the catalog.
connectionstring|null–Name of the connection whose catalog was rebuilt.
structureSchemaCountinteger|nullyesNumber of schemas captured into the structure snapshot.
structureSchemasarray|null–Schemas captured into the structure snapshot.
usageCatalogEnabledboolean|nullyesFalse when the usage catalog is disabled.
usageCatalogStatestring|null–Usage-index state after the rebuild, e.g. not_started, indexing, ready, failed.
usageSourceCountinteger|nullyesNumber 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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablestring–Omit to scan the schema.
NameTypeReqDescription
countinteger|nullyesNumber of redundant-index findings returned.
findingsarray|null–Schema lint or redundant-index findings.
schemastring|null––
tablestring|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
expandRoutinesboolean–Expand database functions/procedures referenced by the query, best-effort. Default true.
expandViewsboolean–Expand database views and materialized views recursively. Default true.
maxDepthinteger–Maximum recursive expansion depth. Default 5, max 20.
schemastring–Default schema for unqualified names
sqlstringyes–
NameTypeReqDescription
cyclesarray|null–Possible relationship or lineage cycles found during traversal.
directObjectsarray|null–Objects directly referenced by the query before recursive expansion.
expandedObjectsarray|null–All resolved objects visited during lineage expansion.
expandedPhysicalTablesarray|null–Physical tables reached by recursively expanding views and routines.
inspectionobject|null–Parsed query inspection that underpins lineage (opaque; the inspectQuery tool returns the typed form).
maxDepthinteger|nullyesMaximum relationship traversal depth that was applied.
unresolvedObjectsarray|null–Objects that could not be resolved against metadata during lineage analysis.
warningsarray|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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
limitinteger–Rows to return (default 10, max 100).
schemastring––
tablestringyes–
NameTypeReqDescription
columnTypesarray|null–Column Types.
columnsarray|null–Columns.
rowCountinteger|nullyesRow Count.
rowsarray|null–Rows.
truncatedboolean|nullyesTruncated.

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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
maxTablesinteger–Tables/views to include (default 2000).
schemastring––
termsstring–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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
fromTablestring–Optional shortest-path start.
maxDepthinteger–Shortest-path hops (default 4).
maxTablesinteger–Tables to scan (default 50).
schemastring––
toTablestring–Optional shortest-path target.
NameTypeReqDescription
centralTablesarray|null–Highest-degree tables that are likely hubs in the schema.
connectedComponentsarray|null–Connected components discovered in the schema relationship graph.
cyclesarray|null–Possible relationship or lineage cycles found during traversal.
declaredEdgeCountinteger|nullyesNumber of graph edges backed by declared foreign keys.
edgeCountinteger|nullyesTotal number of relationship edges in the graph response.
edgesarray|null–Relationship edges included in the graph response.
isolatedTablesarray|null–Tables with no visible relationships in the scanned schema graph.
nodeCountinteger|nullyesNumber of table nodes in the schema graph.
nodesarray|null–Table nodes included in the schema graph response.
schemastring|null––
shortestPath–––
tablesScannedinteger|nullyesNumber 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.

NameTypeReqDescription
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
schemastring––
tablesstring–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.

NameTypeReqDescription
checksstring–Checks CSV, e.g. missingPrimaryKey,fkWithoutIndex; omit for defaults.
connectionstringyesDatabase to run against. Call listConnections for valid names; do not guess.
maxFindingsinteger–Findings to return (default 200).
maxTablesinteger–Tables to scan (default 50).
schemastring––
tablestring–Omit to scan the schema.
NameTypeReqDescription
checksarray|null–Schema lint checks that were enabled for this audit.
findingCountinteger|nullyesNumber of lint findings returned or counted.
findingsarray|null–Schema lint or redundant-index findings.
schemastring|null––
tablestring|null––
tablesScannedinteger|nullyesNumber of tables inspected by the tool before caps were applied.
truncatedboolean|nullyesTrue when the configured row or finding cap was reached and more data may exist.

No examples provided.

Install

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

# add to Claude Code
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.

Common questions

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.