io.github.schemacrawler/schemacrawler-ai
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
التثبيت
أضف هذا إلى إعدادات MCP في عميلك (Claude Desktop: claude_desktop_config.json، وCursor: .cursor/mcp.json، ويستخدم VS Code وغيره الصيغة نفسها «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>"
}
}
}
}
متغيرات البيئة
SCHCRWLR_MCP_SERVER_TRANSPORTMCP 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_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.
التوثيق
مأخوذ من ملف README للمشروع على GitHub ويُحدَّث أسبوعيًا. تفتح الروابط على 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.
الأسئلة الشائعة
ما هو io.github.schemacrawler/schemacrawler-ai؟
Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
كيف أثبّت io.github.schemacrawler/schemacrawler-ai؟
يعمل على جهازك. في 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. وفي العملاء الآخرين، الصق إعداد JSON من هذه الصفحة في إعدادات MCP الخاصة بهم.
هل يحتاج io.github.schemacrawler/schemacrawler-ai إلى مفتاح API؟
نعم. يتطلب SCHCRWLR_DATABASE_USER, SCHCRWLR_DATABASE_PASSWORD، وتضبطها في إعداداته.
هل io.github.schemacrawler/schemacrawler-ai مفتوح المصدر؟
شيفرته علنية على GitHub، لكن المستودع لا يعلن ترخيصًا قياسيًا.
من يصون io.github.schemacrawler/schemacrawler-ai؟
ينشره schemacrawler. يدرجه AI.tn لكنه لا يصونه ولا يوصي به.
من سجل MCP الرسمي. الإدراج ليس توصية: راجع شيفرة الخادم وصلاحياته قبل منحه الوصول إلى بياناتك.