MCP Server MCP

io.github.schemacrawler/schemacrawler-ai

By github 👁 1 views ▲ 0 votes

Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast

Homepage Verified source GitHub

Install

oci:schemacrawler/schemacrawler-ai:17.12.2-1

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "oci",
      "identifier": "schemacrawler/schemacrawler-ai:17.12.2-1",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "MCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.",
          "format": "string",
          "name": "SCHCRWLR_MCP_SERVER_TRANSPORT"
        },
        {
          "description": "Database user name. Can be optional depending on the database connection type.",
          "format": "string",
          "isSecret": true,
          "name": "SCHCRWLR_DATABASE_USER"
        },
        {
          "description": "Database user password. Can be optional depending on the database connection type.",
          "format": "string",
          "isSecret": true,
          "name": "SCHCRWLR_DATABASE_PASSWORD"
        },
        {
          "description": "JDBC URL for database connection. If this is provided, the server, host, port and database are not used.",
          "format": "string",
          "name": "SCHCRWLR_JDBC_URL"
        },
        {
          "description": "SchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided.",
          "format": "string",
          "name": "SCHCRWLR_SERVER"
        },
        {
          "description": "Database host. Defaults to localhost. Used only if the JDBC URL is not provided.",
          "format": "string",
          "name": "SCHCRWLR_HOST"
        },
        {
          "description": "Database port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided.",
          "format": "string",
          "name": "SCHCRWLR_PORT"
        },
        {
          "description": "Database to connect to (optional). Used only if the JDBC URL is not provided.",
          "format": "string",
          "name": "SCHCRWLR_DATABASE"
        },
        {
          "description": "How much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'.",
          "format": "string",
          "name": "SCHCRWLR_INFO_LEVEL"
        },
        {
          "description": "Logging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'.",
          "format": "string",
          "name": "SCHCRWLR_LOG_LEVEL"
        },
        {
          "description": "MCP Server tools to exclude, as a comma-separated list.",
          "format": "string",
          "name": "SCHCRWLR_EXCLUDE_TOOLS"
        }
      ]
    }
  ]
}

mcp model-context-protocol oci