# io.github.schemacrawler/schemacrawler-ai (oci · schemacrawler/schemacrawler-ai:17.12.2-1)

Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast

- Trust score: 36/100 (low)
- Change this week: −5
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-03

## Components

- oci · `schemacrawler/schemacrawler-ai:17.12.2-1`: 36/100 (this document), [markdown](https://verifymcp.io/servers/schemacrawler-schemacrawler-ai/schemacrawler-schemacrawler-ai-17-12-2-1.md), [page](https://verifymcp.io/servers/schemacrawler-schemacrawler-ai/schemacrawler-schemacrawler-ai-17-12-2-1)

## Channel facts

- Registry: `oci`
- Package: `schemacrawler/schemacrawler-ai:17.12.2-1`
- Transport: `stdio`

## Trust breakdown

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. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-03.

- **Supply Chain Security**: 0/100
  - Malware scan not yet available for this package.
  - CVE data not yet available for this package.
  - Install-script risk not yet assessed.
  - Dependency-health data not yet available.
- **Provenance & Transparency**: 32/100
  - Source repository is publicly reachable at the declared URL.
  - Provenance check failed: no build-provenance attestation is published.
  - License check failed: the license (NOASSERTION) isn't a recognized OSI-approved license.
  - Actively maintained (last published 13 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 76/100
  - 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).
  - AI-judged instruction clarity (good).
  - Context-footprint check failed: tool/resource definitions use about 1289 tokens (~161/item across 8 items; 8 tools + 0 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: not enough scan history yet (needs a 30-day window).
- **Tool Coverage**: 96/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 87% of tool parameters carry a description.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**Unverified: 2 categories.** Categories scored 0 because we could not verify them: 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.

## Install

### Claude

```bash
claude mcp add schemacrawler-schemacrawler-ai -- docker run --rm -i schemacrawler/schemacrawler-ai:17.12.2-1
```

### Codex

```bash
codex mcp add schemacrawler-schemacrawler-ai -- docker run --rm -i schemacrawler/schemacrawler-ai:17.12.2-1
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "schemacrawler-schemacrawler-ai": {
      "type": "local",
      "command": [
        "docker",
        "run",
        "--rm",
        "-i",
        "schemacrawler/schemacrawler-ai:17.12.2-1"
      ],
      "enabled": true
    }
  }
}
```

### Hermes

```yaml
mcp_servers:
  schemacrawler-schemacrawler-ai:
    command: "docker"
    args: ["run", "--rm", "-i", "schemacrawler/schemacrawler-ai:17.12.2-1"]
```

### Other

```json
{
  "mcpServers": {
    "schemacrawler-schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "schemacrawler/schemacrawler-ai:17.12.2-1"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-07-31 (score 36, −5)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-27 (score 41, +33)

- [functional improvement] Tool coverage: unverified → 100
- [functional improvement] Schema quality: unverified → 100
- [functional] First check of Tool coverage: 87
- [functional] First check of Schema quality: fail
- [functional] First check of Schema quality: good
- [functional] First check of Schema quality: fail

### 2026-07-26 (score 8)

First indexed and scored.

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

## MCP tools (8)

### `describe_routines` (~192 tokens)

Describe stored procedures and functions

Generates detailed documentation for database routines (stored procedures and functions), including parameter metadata (input/ output parameters, data types, default values), return types, dependencies (on tables, views, or other routines), and full DDL definitions. Supports regex-based routine name filtering and configurable detail levels to optimize tool performance. Returns data as a JSON object.

Input parameters:

- `description_scope` (array): Indicates what details of the database stored procedure or function to return - parameters (including return types), attributes, and routine definition. Parameters, return types, and remarks or comme…
- `routine_name` (string): Name of database routine (stored procedure or function) to describe. May be specified as a regular expression matching the fully qualified stored procedure or function names (including the schema). T…

### `database_server_information` (~68 tokens)

Show database server information

Provides database environment and server configuration metadata, including engine type and version, collation, encoding, parameters, capabilities, and platform details. Adapts output to the specific database (such as Oracle, SQL Server, PostgreSQL and so on) to support platform-aware SQL generation and schema analysis.

### `describe_tables` (~228 tokens)

Describe tables and views

Generates detailed documentation for database tables and views, including column definitions (names, data types, constraints, nullability), primary and foreign key relationships, index and trigger information, table attributes, and complete DDL definitions. Supports regex-based table name filtering and configurable detail levels to optimize tool performance. Returns data as a JSON object.

Input parameters:

- `description_scope` (array): Indicates what details of the database table or view to return - columns, primary key, foreign keys, indexes, triggers, attributes, and table definition. Also returns which objects reference a given…
- `table_name` (string): Name of database table or view to describe. May be specified as a regular expression, matching the fully qualified table name (including the schema). Try not to match all tables, but instead use a re…

### `describe_entities` (~159 tokens)

Describe entities in the ER model

Generates detailed documentation for entities in the ER model, including entity type such as strong, weak and subtype entities, and attributes. Supports regex-based entity name filtering to optimize tool performance. Returns data as a JSON object.

Input parameters:

- `entity_kind` (string): Indicates the types of entities to return - for example, strong, weak or subtype entities. It can also return associations (or bridge or join tables).
- `entity_name` (string): Name of entity to describe, from the ER model. May be specified as a regular expression, matching the fully qualified entity name (including the schema). Try not to match all entities, but instead us…

### `describe_relationships` (~162 tokens)

Describe relationships in the ER model

Generates detailed documentation for relationships in the ER model, including 1..1, 1..M, M..N and optional relationships. Supports regex-based relationship name filtering  to optimize tool performance. Returns data as a JSON object.

Input parameters:

- `cardinality` (string): Indicates the types of relationships to return - for example, 1..1, 1..M, M..N and optional relationships.
- `relationship_name` (string): Name of relationships to describe, from the ER model. May be specified as a regular expression, matching the fully qualified relationship name (including the schema). Try not to match all relationshi…

### `list_across_tables` (~265 tokens)

List dependent database objects across tables

Makes an inventory of table-dependent objects across the database schema, including columns, indexes, foreign keys, triggers, and constraints. Enables impact analysis, dependency tracking, performance tuning, and refactoring without inspecting individual tables. The corresponding tables are identified, and their details can be obtained later by describing those tables. Supports regex-based table name filtering and configurable detail levels to optimize tool performance. Returns JSON data.

Input parameters:

- `dependant_object_name` (string): Name of table dependant object. May be a regular expression, matching the fully qualified dependant object name (including the schema and table). May match more than one dependant object. Use an empt…
- `dependant_object_type` (string, required): Type of database table dependant objects, like columns, indexes, foreign keys or triggers.
- `table_name` (string): Name of database table for which dependant objects are described. May be a regular expression, matching the fully qualified table name (including the schema), in which case, multiple tables may be re…

### `list` (~177 tokens)

List database objects

Makes an inventory of database schema objects such as tables, views, stored procedures, functions, sequences, synonyms, and more. This is an essential starting point for database exploration, database asset management, and schema analysis. The tool supports object type filtering and pattern-based searching. Returns JSON data.

Input parameters:

- `database_object_name` (string): Name of database object to list. Is a regular expression, matching the fully qualified database object name (including the schema). May match more than one database object. Use an empty string if all…
- `database_object_type` (string): Type of database object to list, like tables (including views), routines (that is, stored procedures and functions), schemas (that is, databases or catalogs), sequences, or synonyms. If the parameter…

### `mcp-server-health` (~38 tokens)

Show SchemaCrawler AI MCP Server health

Gets the SchemaCrawler AI MCP Server version and uptime status.

Input parameters:

- `clientId` (string, required)
- `eventId` (string, required)

## Diagnostics

Captured diagnostic sections: Provenance. The full working is on the page: https://verifymcp.io/servers/schemacrawler-schemacrawler-ai/schemacrawler-schemacrawler-ai-17-12-2-1#diagnostics

## Score history

- 2026-08-03: 36
- 2026-08-02: 36
- 2026-08-01: 36
- 2026-07-31: 36
- 2026-07-30: 41
- 2026-07-29: 41
- 2026-07-28: 41
- 2026-07-27: 41
- 2026-07-26: 8

## Links

- Repository: https://github.com/schemacrawler/SchemaCrawler-AI
- Website: https://schemacrawler.github.io/
- Changelog RSS feed: https://verifymcp.io/servers/schemacrawler-schemacrawler-ai/schemacrawler-schemacrawler-ai-17-12-2-1/changelog.xml
- Changelog JSON feed: https://verifymcp.io/servers/schemacrawler-schemacrawler-ai/schemacrawler-schemacrawler-ai-17-12-2-1/changelog.json
- HTML version of this page: https://verifymcp.io/servers/schemacrawler-schemacrawler-ai/schemacrawler-schemacrawler-ai-17-12-2-1