schemacrawler-ai MCP Setup & Guide

{
  "id": "io.github.schemacrawler/schemacrawler-ai",
  "type": "mcp-server",
  "version": "v17.15.7-1",
  "displayName": "schemacrawler-ai",
  "description": "Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast",
  "repository": {
    "url": "https://github.com/schemacrawler/SchemaCrawler-AI",
    "source": "github"
  },
  "homepage": "https://schemacrawler.github.io",
  "distribution": {
    "packages": [
      {
        "registryType": "oci",
        "identifier": "schemacrawler/schemacrawler-ai:17.15.7-1",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "SCHCRWLR_MCP_SERVER_TRANSPORT",
            "description": "MCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'."
          },
          {
            "name": "SCHCRWLR_DATABASE_USER",
            "description": "Database user name. Can be optional depending on the database connection type.",
            "isSecret": true
          },
          {
            "name": "SCHCRWLR_DATABASE_PASSWORD",
            "description": "Database user password. Can be optional depending on the database connection type.",
            "isSecret": true
          },
          {
            "name": "SCHCRWLR_JDBC_URL",
            "description": "JDBC URL for database connection. If this is provided, the server, host, port and database are not used."
          },
          {
            "name": "SCHCRWLR_SERVER",
            "description": "SchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided."
          },
          {
            "name": "SCHCRWLR_HOST",
            "description": "Database host. Defaults to localhost. Used only if the JDBC URL is not provided."
          },
          {
            "name": "SCHCRWLR_PORT",
            "description": "Database port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided."
          },
          {
            "name": "SCHCRWLR_DATABASE",
            "description": "Database to connect to (optional). Used only if the JDBC URL is not provided."
          },
          {
            "name": "SCHCRWLR_DATABASE_ALIAS",
            "description": "Optional stable alias used to identify this database server in MCP instructions and tool results."
          },
          {
            "name": "SCHCRWLR_DATABASE_DESCRIPTION",
            "description": "Optional description of this database server, included in MCP instructions and the about_database response."
          },
          {
            "name": "SCHCRWLR_INFO_LEVEL",
            "description": "How much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'."
          },
          {
            "name": "SCHCRWLR_LOG_LEVEL",
            "description": "Logging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'."
          },
          {
            "name": "SCHCRWLR_EXCLUDE_TOOLS",
            "description": "MCP Server tools to exclude, as a comma-separated list."
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.schemacrawler/schemacrawler-ai",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.schemacrawler%2Fschemacrawler-ai/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}