io.github.schemacrawler/schemacrawler-ai
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
Installation
Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).
schemacrawler/schemacrawler-ai:17.16.0-1claude mcp add schemacrawler-ai -e 'SCHCRWLR_MCP_SERVER_TRANSPORT=<SCHCRWLR_MCP_SERVER_TRANSPORT>' -e 'SCHCRWLR_DATABASE_USER=<your schcrwlr_database_user>' -e 'SCHCRWLR_DATABASE_PASSWORD=<your schcrwlr_database_password>' -e 'SCHCRWLR_JDBC_URL=<SCHCRWLR_JDBC_URL>' -e 'SCHCRWLR_SERVER=<SCHCRWLR_SERVER>' -e 'SCHCRWLR_HOST=<SCHCRWLR_HOST>' -e 'SCHCRWLR_PORT=<SCHCRWLR_PORT>' -e 'SCHCRWLR_DATABASE=<SCHCRWLR_DATABASE>' -e 'SCHCRWLR_DATABASE_ALIAS=<SCHCRWLR_DATABASE_ALIAS>' -e 'SCHCRWLR_DATABASE_DESCRIPTION=<SCHCRWLR_DATABASE_DESCRIPTION>' -e 'SCHCRWLR_INFO_LEVEL=<SCHCRWLR_INFO_LEVEL>' -e 'SCHCRWLR_LOG_LEVEL=<SCHCRWLR_LOG_LEVEL>' -e 'SCHCRWLR_EXCLUDE_TOOLS=<SCHCRWLR_EXCLUDE_TOOLS>' -- docker run -i --rm schemacrawler/schemacrawler-ai:17.16.0-1
{
"mcpServers": {
"schemacrawler-ai": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"schemacrawler/schemacrawler-ai:17.16.0-1"
],
"env": {
"SCHCRWLR_MCP_SERVER_TRANSPORT": "<SCHCRWLR_MCP_SERVER_TRANSPORT>",
"SCHCRWLR_DATABASE_USER": "<your schcrwlr_database_user>",
"SCHCRWLR_DATABASE_PASSWORD": "<your schcrwlr_database_password>",
"SCHCRWLR_JDBC_URL": "<SCHCRWLR_JDBC_URL>",
"SCHCRWLR_SERVER": "<SCHCRWLR_SERVER>",
"SCHCRWLR_HOST": "<SCHCRWLR_HOST>",
"SCHCRWLR_PORT": "<SCHCRWLR_PORT>",
"SCHCRWLR_DATABASE": "<SCHCRWLR_DATABASE>",
"SCHCRWLR_DATABASE_ALIAS": "<SCHCRWLR_DATABASE_ALIAS>",
"SCHCRWLR_DATABASE_DESCRIPTION": "<SCHCRWLR_DATABASE_DESCRIPTION>",
"SCHCRWLR_INFO_LEVEL": "<SCHCRWLR_INFO_LEVEL>",
"SCHCRWLR_LOG_LEVEL": "<SCHCRWLR_LOG_LEVEL>",
"SCHCRWLR_EXCLUDE_TOOLS": "<SCHCRWLR_EXCLUDE_TOOLS>"
}
}
}
}
Variables d'environnement
SCHCRWLR_MCP_SERVER_TRANSPORTMCP 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_URLJDBC URL for database connection. If this is provided, the server, host, port and database are not used.SCHCRWLR_SERVERSchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided.SCHCRWLR_HOSTDatabase host. Defaults to localhost. Used only if the JDBC URL is not provided.SCHCRWLR_PORTDatabase port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided.SCHCRWLR_DATABASEDatabase to connect to (optional). Used only if the JDBC URL is not provided.SCHCRWLR_DATABASE_ALIASOptional stable alias used to identify this database server in MCP instructions and tool results.SCHCRWLR_DATABASE_DESCRIPTIONOptional description of this database server, included in MCP instructions and the about_database response.SCHCRWLR_INFO_LEVELHow much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'.SCHCRWLR_LOG_LEVELLogging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'.SCHCRWLR_EXCLUDE_TOOLSMCP Server tools to exclude, as a comma-separated list.
Documentation
Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.
:star: Star it :arrow_heading_up: if you love it!
SchemaCrawler AI
[!NOTE]
- Please see the SchemaCrawler website for more details.
- See SchemaCrawler AI MCP Server Usage for information on how to use the MCP Server
About
SchemaCrawler AI provides an MCP Server to allow AI agents to have an interactive way to interrogate your database schema metadata. It is based on SchemaCrawler, which is a free database schema discovery and comprehension tool.
Licensing
SchemaCrawler AI is licensed under the Business Source License 1.1 (BUSL-1.1) license.
This project may be distributed together with third-party components such as JDBC drivers and other libraries. Unless explicitly stated otherwise, the Business Source License 1.1 applies only to the SchemaCrawler AI MCP Server source code authored for this repository. All third-party components included in source or binary distributions are licensed separately by their respective copyright holders. See the documentation or the distribution package for third-party license information.
Under the Business Source License 1.1, you are free to read, modify, and redistribute the source code, subject to the license terms. However, production or commercial use of SchemaCrawler AI MCP Server is restricted except as permitted by a separate commercial agreement. If you are interested in production or commercial use please see the SchemaCrawler website.
Support
SchemaCrawler AI is not supported, unless you purchase a support incident. Please see Guidelines for Support for details.
Questions fréquentes
Qu'est-ce que io.github.schemacrawler/schemacrawler-ai ?
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
Comment installer io.github.schemacrawler/schemacrawler-ai ?
Il s'exécute sur votre machine. Dans Claude Code : claude mcp add schemacrawler-ai -e 'SCHCRWLR_MCP_SERVER_TRANSPORT=<SCHCRWLR_MCP_SERVER_TRANSPORT>' -e 'SCHCRWLR_DATABASE_USER=<your schcrwlr_database_user>' -e 'SCHCRWLR_DATABASE_PASSWORD=<your schcrwlr_database_password>' -e 'SCHCRWLR_JDBC_URL=<SCHCRWLR_JDBC_URL>' -e 'SCHCRWLR_SERVER=<SCHCRWLR_SERVER>' -e 'SCHCRWLR_HOST=<SCHCRWLR_HOST>' -e 'SCHCRWLR_PORT=<SCHCRWLR_PORT>' -e 'SCHCRWLR_DATABASE=<SCHCRWLR_DATABASE>' -e 'SCHCRWLR_DATABASE_ALIAS=<SCHCRWLR_DATABASE_ALIAS>' -e 'SCHCRWLR_DATABASE_DESCRIPTION=<SCHCRWLR_DATABASE_DESCRIPTION>' -e 'SCHCRWLR_INFO_LEVEL=<SCHCRWLR_INFO_LEVEL>' -e 'SCHCRWLR_LOG_LEVEL=<SCHCRWLR_LOG_LEVEL>' -e 'SCHCRWLR_EXCLUDE_TOOLS=<SCHCRWLR_EXCLUDE_TOOLS>' -- docker run -i --rm schemacrawler/schemacrawler-ai:17.16.0-1. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.
Faut-il une clé API pour io.github.schemacrawler/schemacrawler-ai ?
Oui. Il attend SCHCRWLR_DATABASE_USER, SCHCRWLR_DATABASE_PASSWORD, à renseigner dans sa configuration.
io.github.schemacrawler/schemacrawler-ai est-il open source ?
Son code est public sur GitHub, mais le dépôt ne déclare pas de licence standard.
Qui maintient io.github.schemacrawler/schemacrawler-ai ?
Il est publié par schemacrawler. AI.tn le référence sans le maintenir ni le recommander.
Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.