SchemaCrawler AI

SchemaCrawler AI MCP Server

The SchemaCrawler AI MCP Server enables natural language interaction with your database schema using an MCP client in "Agent" mode. It allows users to explore tables, columns, foreign keys, triggers, stored procedures and more simply by asking questions like "Explain the code for the interest calculation stored procedure". You can also ask it to help with SQL, since it knows your schema. This is ideal for developers, DBAs, and data analysts who want to streamline schema comprehension and query development without diving into dense documentation.

What is an MCP Server?⁠

Characteristics

Attribute	Details
Docker Image	mcp/schemacrawler-ai⁠
Author	schemacrawler⁠
Repository	https://github.com/schemacrawler/SchemaCrawler-AI⁠
Dockerfile	https://github.com/schemacrawler/SchemaCrawler-AI/blob/docker-mcp-registry/Dockerfile⁠
Docker Image built by	Docker Inc.
Docker Scout Health Score
Verify Signature	COSIGN_REPOSITORY=mcp/signatures cosign verify mcp/schemacrawler-ai --key https://raw.githubusercontent.com/docker/keyring/refs/heads/main/public/mcp/latest.pub
Licence	Other

Available Tools (8)

Tools Details

Tool: describe-routines

Get the details and description of database routine (stored procedures or functions), including parameters and return types. This could return a lot of information if not limited by a parameter specifying one or more routines. Returns data as a JSON object.

Tool: describe-tables

Get the details and description of database tables or views, including columns, primary key, foreign keys, indexes and triggers. This could return a lot of information if not limited by a parameter specifying one or more tables. Returns data as a JSON object.

Tool: get-schemacrawler-version

Gets the version of SchemaCrawler

Tool: lint

Lint database schemas. Find design issues with specific tables, or with the entire database. Find problems with database design, such as no indexes on foreign keys.

Tool: list

List names of database objects like tables, routines (that is, functions and stored procedures), sequences, or synonyms. Returns JSON data.

Tool: list-across-tables

List names of names of database objects like columns, indexes, triggers, and foreign keys for tables across the whole database. The corresponding tables are identified, and details can be obtained later by describing those tables. Returns JSON data.

Tool: server-information

Provides more information about the database server, for example the product version, collation and so on. Details will vary based on the type of the server, for example, if it is Oracle, SQL Server, PostgreSQL, MySQL, etc. Returns JSON data.

Tool: table-sample

Gets a few sample rows of data from a table. These rows are selected at random, and so different rows may be returned each time they are requested. Do not use this as a substitute for running a query on a table, but rather to infer what the table may contain.

Use this MCP Server

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_JDBC_URL",
        "-e",
        "SCHCRWLR_SERVER",
        "-e",
        "SCHCRWLR_HOST",
        "-e",
        "SCHCRWLR_PORT",
        "-e",
        "SCHCRWLR_DATABASE",
        "-e",
        "SCHCRWLR_INFO_LEVEL",
        "-e",
        "SCHCRWLR_LOG_LEVEL",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "-v",
        "/local-directory:/local-directory",
        "mcp/schemacrawler-ai"
      ],
      "env": {
        "SCHCRWLR_JDBC_URL": "12.12.12.12",
        "SCHCRWLR_SERVER": "12.12.12.12",
        "SCHCRWLR_HOST": "12.12.12.12",
        "SCHCRWLR_PORT": "9999",
        "SCHCRWLR_DATABASE": "public",
        "SCHCRWLR_INFO_LEVEL": "standard",
        "SCHCRWLR_LOG_LEVEL": "ALL",
        "SCHCRWLR_DATABASE_USER": "SA",
        "SCHCRWLR_DATABASE_PASSWORD": "super_S3cret"
      }
    }
  }
}

Why is it safer to run MCP Servers with Docker?⁠