The SchemaCrawler AI MCP Server enables natural language interaction with your database schema using an MCP client in "Agent" mode. It allows users to explore tables, columns, foreign keys, triggers, stored procedures and more simply by asking questions like "Explain the code for the interest calculation stored procedure". You can also ask it to help with SQL, since it knows your schema. This is ideal for developers, DBAs, and data analysts who want to streamline schema comprehension and query development without diving into dense documentation.
683
8 Tools
Version 4.43 or later needs to be installed to add the server automatically
Connect the MCP Toolkit gateway to Claude Desktop using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Restart Claude Desktop for the changes to take effect.
schemacrawler-ai to the mcpServers section:{
"mcpServers": {
"schemacrawler-ai": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"SCHCRWLR_JDBC_URL",
"-e",
"SCHCRWLR_SERVER",
"-e",
"SCHCRWLR_HOST",
"-e",
"SCHCRWLR_PORT",
"-e",
"SCHCRWLR_DATABASE",
"-e",
"SCHCRWLR_INFO_LEVEL",
"-e",
"SCHCRWLR_LOG_LEVEL",
"-e",
"SCHCRWLR_DATABASE_USER",
"-e",
"SCHCRWLR_DATABASE_PASSWORD",
"-v",
"/local-directory:/local-directory",
- mcp/schemacrawler-ai@sha256:529bcf70c268d5763dc817effcdd4561c6f9c53a08dc6884bee35b5df1659941
],
"env": {
"SCHCRWLR_JDBC_URL": "{{schemacrawler-ai.url_connection.jdbc_url}}",
"SCHCRWLR_SERVER": "{{schemacrawler-ai.server_connection.server}}",
"SCHCRWLR_HOST": "{{schemacrawler-ai.server_connection.host}}",
"SCHCRWLR_PORT": "{{schemacrawler-ai.server_connection.port}}",
"SCHCRWLR_DATABASE": "{{schemacrawler-ai.server_connection.database}}",
"SCHCRWLR_INFO_LEVEL": "{{schemacrawler-ai.general.info_level}}",
"SCHCRWLR_LOG_LEVEL": "{{schemacrawler-ai.general.log_level}}",
"SCHCRWLR_DATABASE_USER": "SA",
"SCHCRWLR_DATABASE_PASSWORD": "super_S3cret"
}
}
}
}Connect the MCP Toolkit gateway to Continue.dev using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
name: Docker MCP SchemaCrawler AI
version: 1.0.1
schema: v1
mcpServers:
- name: SchemaCrawler AI
command: docker
args:
- run
- --rm
- -i
- -e
- SCHCRWLR_JDBC_URL
- -e
- SCHCRWLR_SERVER
- -e
- SCHCRWLR_HOST
- -e
- SCHCRWLR_PORT
- -e
- SCHCRWLR_DATABASE
- -e
- SCHCRWLR_INFO_LEVEL
- -e
- SCHCRWLR_LOG_LEVEL
- -e
- SCHCRWLR_DATABASE_USER
- -e
- SCHCRWLR_DATABASE_PASSWORD
- -v
- /local-directory:/local-directory
- mcp/schemacrawler-ai@sha256:529bcf70c268d5763dc817effcdd4561c6f9c53a08dc6884bee35b5df1659941
env:
SCHCRWLR_JDBC_URL: "{{schemacrawler-ai.url_connection.jdbc_url}}"
SCHCRWLR_SERVER: "{{schemacrawler-ai.server_connection.server}}"
SCHCRWLR_HOST: "{{schemacrawler-ai.server_connection.host}}"
SCHCRWLR_PORT: "{{schemacrawler-ai.server_connection.port}}"
SCHCRWLR_DATABASE: "{{schemacrawler-ai.server_connection.database}}"
SCHCRWLR_INFO_LEVEL: "{{schemacrawler-ai.general.info_level}}"
SCHCRWLR_LOG_LEVEL: "{{schemacrawler-ai.general.log_level}}"
SCHCRWLR_DATABASE_USER: "SA"
SCHCRWLR_DATABASE_PASSWORD: "super_S3cret"Connect the MCP Toolkit gateway to Cursor using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
schemacrawler-ai to the mcpServers section:{
"mcpServers": {
"schemacrawler-ai": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"SCHCRWLR_JDBC_URL",
"-e",
"SCHCRWLR_SERVER",
"-e",
"SCHCRWLR_HOST",
"-e",
"SCHCRWLR_PORT",
"-e",
"SCHCRWLR_DATABASE",
"-e",
"SCHCRWLR_INFO_LEVEL",
"-e",
"SCHCRWLR_LOG_LEVEL",
"-e",
"SCHCRWLR_DATABASE_USER",
"-e",
"SCHCRWLR_DATABASE_PASSWORD",
"-v",
"/local-directory:/local-directory",
- mcp/schemacrawler-ai@sha256:529bcf70c268d5763dc817effcdd4561c6f9c53a08dc6884bee35b5df1659941
],
"env": {
"SCHCRWLR_JDBC_URL": "{{schemacrawler-ai.url_connection.jdbc_url}}",
"SCHCRWLR_SERVER": "{{schemacrawler-ai.server_connection.server}}",
"SCHCRWLR_HOST": "{{schemacrawler-ai.server_connection.host}}",
"SCHCRWLR_PORT": "{{schemacrawler-ai.server_connection.port}}",
"SCHCRWLR_DATABASE": "{{schemacrawler-ai.server_connection.database}}",
"SCHCRWLR_INFO_LEVEL": "{{schemacrawler-ai.general.info_level}}",
"SCHCRWLR_LOG_LEVEL": "{{schemacrawler-ai.general.log_level}}",
"SCHCRWLR_DATABASE_USER": "SA",
"SCHCRWLR_DATABASE_PASSWORD": "super_S3cret"
}
}
}
}Define the MCP Toolkit gateway as a server in the MCP Visual Studio Code user settings. Learn more
"mcp": {
"servers": {
"MCP_DOCKER": {
"command": "docker",
"args": [
"mcp",
"gateway",
"run"
],
"type": "stdio"
}
}
}Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Connect the MCP Toolkit gateway to Gordon using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Manual installation
You can install the MCP server using:
Installation for