mcpField
S
schemacrawler-ai

schemacrawler-ai

Local
schemacrawler.github.ioDatabases13Updated 2d ago
RepositoryVisit website

About schemacrawler-ai

SchemaCrawler AI is an MCP server for AI agents to explore database schema metadata interactively. It builds on SchemaCrawler, a database schema discovery and comprehension tool.

Key features

  1. 01Explore database schema metadata
  2. 02Interactively query schema information

Use cases

  1. 01Inspect database schema metadata
  2. 02Explore schema details through an AI agent

MCP support

It exposes interactive access to database schema metadata to AI agents through an MCP server.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "schemacrawler-schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_MCP_SERVER_TRANSPORT",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "-e",
        "SCHCRWLR_JDBC_URL",
        "-e",
        "SCHCRWLR_SERVER",
        "-e",
        "SCHCRWLR_HOST",
        "-e",
        "SCHCRWLR_PORT",
        "-e",
        "SCHCRWLR_DATABASE",
        "-e",
        "SCHCRWLR_DATABASE_ALIAS",
        "-e",
        "SCHCRWLR_DATABASE_DESCRIPTION",
        "-e",
        "SCHCRWLR_INFO_LEVEL",
        "-e",
        "SCHCRWLR_LOG_LEVEL",
        "-e",
        "SCHCRWLR_EXCLUDE_TOOLS",
        "schemacrawler/schemacrawler-ai:17.16.0-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<SCHCRWLR_DATABASE>",
        "SCHCRWLR_DATABASE_ALIAS": "<SCHCRWLR_DATABASE_ALIAS>",
        "SCHCRWLR_DATABASE_DESCRIPTION": "<SCHCRWLR_DATABASE_DESCRIPTION>",
        "SCHCRWLR_INFO_LEVEL": "<SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}
Run commanddocker run -i --rm -e SCHCRWLR_MCP_SERVER_TRANSPORT -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD -e SCHCRWLR_JDBC_URL -e SCHCRWLR_SERVER -e SCHCRWLR_HOST -e SCHCRWLR_PORT -e SCHCRWLR_DATABASE -e SCHCRWLR_DATABASE_ALIAS -e SCHCRWLR_DATABASE_DESCRIPTION -e SCHCRWLR_INFO_LEVEL -e SCHCRWLR_LOG_LEVEL -e SCHCRWLR_EXCLUDE_TOOLS schemacrawler/schemacrawler-ai:17.16.0-1
Environment variables to set
SCHCRWLR_MCP_SERVER_TRANSPORTMCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.
SCHCRWLR_DATABASE_USERSecretDatabase user name. Can be optional depending on the database connection type.
SCHCRWLR_DATABASE_PASSWORDSecretDatabase user password. Can be optional depending on the database connection type.
SCHCRWLR_JDBC_URLJDBC URL for database connection. If this is provided, the server, host, port and database are not used.
SCHCRWLR_SERVERSchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided.
SCHCRWLR_HOSTDatabase host. Defaults to localhost. Used only if the JDBC URL is not provided.
SCHCRWLR_PORTDatabase port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided.
SCHCRWLR_DATABASEDatabase to connect to (optional). Used only if the JDBC URL is not provided.
SCHCRWLR_DATABASE_ALIASOptional stable alias used to identify this database server in MCP instructions and tool results.
SCHCRWLR_DATABASE_DESCRIPTIONOptional description of this database server, included in MCP instructions and the about_database response.
SCHCRWLR_INFO_LEVELHow much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'.
SCHCRWLR_LOG_LEVELLogging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'.
SCHCRWLR_EXCLUDE_TOOLSMCP Server tools to exclude, as a comma-separated list.

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
ocischemacrawler/schemacrawler-ai:17.16.0-1

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

:star: Star it :arrow_heading_up: if you love it!

Build Docker Pulls Docker MCP Pulls GitHub Repo stars

README image SchemaCrawler AI

Note

About

SchemaCrawler AI provides an MCP Server to allow AI agents to have an interactive way to interrogate your database schema metadata. It is based on SchemaCrawler, which is a free database schema discovery and comprehension tool.

Licensing

SchemaCrawler AI is licensed under the Business Source License 1.1 (BUSL-1.1) license.

This project may be distributed together with third-party components such as JDBC drivers and other libraries. Unless explicitly stated otherwise, the Business Source License 1.1 applies only to the SchemaCrawler AI MCP Server source code authored for this repository. All third-party components included in source or binary distributions are licensed separately by their respective copyright holders. See the documentation or the distribution package for third-party license information.

Under the Business Source License 1.1, you are free to read, modify, and redistribute the source code, subject to the license terms. However, production or commercial use of SchemaCrawler AI MCP Server is restricted except as permitted by a separate commercial agreement. If you are interested in production or commercial use please see the SchemaCrawler website.

Support

SchemaCrawler AI is not supported, unless you purchase a support incident. Please see Guidelines for Support for details.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.