A server that enables natural language schema queries to explore database structures. It helps users examine tables, keys, and procedures, providing fast SQL assistance and metadata-driven insights within the MCP ecosystem.

🛠️ Key Features

Natural language queries for database schemas
Exploration of tables, keys, and procedures
Quick SQL help and guidance
MCP/server-ready metadata extraction

🚀 Use Cases

Interactive schema discovery via chat-style queries
Documentation and SQL assistance for complex schemas
Metadata-driven reverse engineering workflows
Integration with MCP-based tooling and deployments

⚡ Developer Benefits

Grounded in SchemaCrawler AI capabilities for robust metadata handling
Docker-ready with MCP compatibility
Clear readme excerpt and project topics for discoverability
Facilitates automated schema queries within MCP environments

⚠️ Limitations

Based on provided readme excerpt; depth may vary with source completeness
Behavior tied to MCP server integration and surrounding tooling
Requires compatible database connections for live schema queries

Install

Configuration

Environment variables

SCHCRWLR_MCP_SERVER_TRANSPORT

MCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.

SCHCRWLR_DATABASE_USERsecret

Database user name. Can be optional depending on the database connection type.

SCHCRWLR_DATABASE_PASSWORDsecret

Database user password. Can be optional depending on the database connection type.

SCHCRWLR_JDBC_URL

JDBC URL for database connection. If this is provided, the server, host, port and database are not used.

SCHCRWLR_SERVER

SchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided.

SCHCRWLR_HOST

Database host. Defaults to localhost. Used only if the JDBC URL is not provided.

SCHCRWLR_PORT

Database port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided.

SCHCRWLR_DATABASE

Database to connect to (optional). Used only if the JDBC URL is not provided.

SCHCRWLR_INFO_LEVEL

How much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'.

SCHCRWLR_LOG_LEVEL

Logging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'.

SCHCRWLR_EXCLUDE_TOOLS

MCP Server tools to exclude, as a comma-separated list.

Add to VS Code Add to Cursor

claude_desktop_config.json

json

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "schemacrawler/schemacrawler-ai:17.14.1-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<YOUR_SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<YOUR_SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<YOUR_SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<YOUR_SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<YOUR_SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<YOUR_SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<YOUR_SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<YOUR_SCHCRWLR_DATABASE>",
        "SCHCRWLR_INFO_LEVEL": "<YOUR_SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<YOUR_SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<YOUR_SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}

io.github.schemacrawler/schemacrawler-ai

🛠️ Key Features

🚀 Use Cases

⚡ Developer Benefits

⚠️ Limitations

Topics

image SchemaCrawler AI

About

Licensing

Support

Install

Configuration

Related servers