io.github.schemacrawler/schemacrawler-ai
OCI · SCHEMACRAWLER/SCHEMACRAWLER-AI:17.12.2-1 · SCANNED AUG 3
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
Available components
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 →
Supply Chain Security0
- Malware scan not yet available for this package.Unverified
- CVE data not yet available for this package.Unverified
- Install-script risk not yet assessed.Unverified
- Dependency-health data not yet available.Unverified
Provenance & Transparency32
- 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
- License check failed: the license (NOASSERTION) isn't a recognized OSI-approved license. See how to fix → Fail
- Actively maintained (last published 13 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability76
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (good).Pass
- 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. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management0
- Stability not yet verified: not enough scan history yet (needs a 30-day window).Unverified
Tool Coverage96
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 87% of tool parameters carry a description.Partial
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
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.
Add this component to your MCP client. Where a client-specific snippet is available, pick your client below and copy it straight into your config; otherwise use the connection detail shown.
oci · schemacrawler/schemacrawler-ai:17.12.2-1
claude mcp add schemacrawler-schemacrawler-ai -- docker run --rm -i schemacrawler/schemacrawler-ai:17.12.2-1
codex mcp add schemacrawler-schemacrawler-ai -- docker run --rm -i schemacrawler/schemacrawler-ai:17.12.2-1
{
"$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
}
}
} mcp_servers:
schemacrawler-schemacrawler-ai:
command: "docker"
args: ["run", "--rm", "-i", "schemacrawler/schemacrawler-ai:17.12.2-1"] {
"mcpServers": {
"schemacrawler-schemacrawler-ai": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"schemacrawler/schemacrawler-ai:17.12.2-1"
]
}
}
} 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.
- 31 Jul 26 −5
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 27 Jul 26 +33
- Tool coverage: unverified → 100 ▲ functional
- 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 functional
- 26 Jul 26 8
First indexed and scored.
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → 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 3 Aug 2026 · Analysed oci/schemacrawler/schemacrawler-ai:17.12.2-1
Provenance none
Ecosystem: oci · Outcome: none
Reason: no_attestation
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.
database_server_information Show database server information ~68
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.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
describe_entities Describe entities in the ER model ~159
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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… |
No output schema declared.
No examples provided.
describe_relationships Describe relationships in the ER model ~162
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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… |
No output schema declared.
No examples provided.
describe_routines Describe stored procedures and functions ~192
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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… |
No output schema declared.
No examples provided.
describe_tables Describe tables and views ~228
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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… |
No output schema declared.
No examples provided.
list List database objects ~177
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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… |
No output schema declared.
No examples provided.
list_across_tables List dependent database objects across tables ~265
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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 | yes | 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… |
No output schema declared.
No examples provided.
mcp-server-health Show SchemaCrawler AI MCP Server health ~38
Gets the SchemaCrawler AI MCP Server version and uptime status.
| Name | Type | Req | Description |
|---|---|---|---|
| clientId | string | yes | — |
| eventId | string | yes | — |
No output schema declared.
No examples provided.