Schemacrawler-ai MCP Server

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

Local serverstdio

What is the Schemacrawler-ai MCP Server?

Schemacrawler-ai is an MCP integration. Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast.

Packages and local setup

The published oci package is schemacrawler/schemacrawler-ai:17.15.7-1. Its declared MCP transport is stdio.

The package declares SCHCRWLR_MCP_SERVER_TRANSPORT: MCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.; SCHCRWLR_DATABASE_USER: Database user name. Can be optional depending on the database connection type.; SCHCRWLR_DATABASE_PASSWORD: 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_DATABASE_ALIAS: Optional stable alias used to identify this database server in MCP instructions and tool results.; SCHCRWLR_DATABASE_DESCRIPTION: Optional description of this database server, included in MCP instructions and the about_database response.; 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..

Before connecting

Check the maintainer’s instructions for account access, authentication and the supported client configuration. Once connected, inspect the tools your client receives and try a small task that matches the server’s stated purpose. The registry description does not include a verified, complete tool list.

Project and source

View the publisher’s registry entry · Project repository · Project website. This profile uses version v17.15.7-1 from the registry. Registration identifies the publisher namespace; it does not establish that this is a first-party integration for every service it connects.

Browse related developer tools MCP servers for tools that cover the same kind of work.

Configuration

VariableDescriptionRequired
SCHCRWLR_MCP_SERVER_TRANSPORTMCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.Optional
SCHCRWLR_DATABASE_USERDatabase user name. Can be optional depending on the database connection type.Optional
SCHCRWLR_DATABASE_PASSWORDDatabase user password. Can be optional depending on the database connection type.Optional
SCHCRWLR_JDBC_URLJDBC URL for database connection. If this is provided, the server, host, port and database are not used.Optional
SCHCRWLR_SERVERSchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided.Optional
SCHCRWLR_HOSTDatabase host. Defaults to localhost. Used only if the JDBC URL is not provided.Optional
SCHCRWLR_PORTDatabase port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided.Optional
SCHCRWLR_DATABASEDatabase to connect to (optional). Used only if the JDBC URL is not provided.Optional
SCHCRWLR_DATABASE_ALIASOptional stable alias used to identify this database server in MCP instructions and tool results.Optional
SCHCRWLR_DATABASE_DESCRIPTIONOptional description of this database server, included in MCP instructions and the about_database response.Optional
SCHCRWLR_INFO_LEVELHow much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'.Optional
SCHCRWLR_LOG_LEVELLogging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'.Optional
SCHCRWLR_EXCLUDE_TOOLSMCP Server tools to exclude, as a comma-separated list.Optional