Summary
SchemaCrawler wraps database metadata exploration in a conversational interface, letting you ask questions about your schema in plain English instead of writing information_schema queries. It connects to your existing database and exposes operations to discover tables, foreign keys, stored procedures, and relationships without memorizing catalog syntax. Reach for this when you're working with an unfamiliar database, need to quickly understand legacy schemas, or want SQL generation help based on actual table structures. The command-line version has been around for years as a schema analysis tool, and this MCP server brings that same introspection capability directly into your AI workflow.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →Configuration
SCHCRWLR_MCP_SERVER_TRANSPORTMCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.
SCHCRWLR_DATABASE_USERsecretDatabase user name. Can be optional depending on the database connection type.
SCHCRWLR_DATABASE_PASSWORDsecretDatabase 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_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.
Categories
Registryactive
Packageschemacrawler/schemacrawler-ai:17.11.2-2
TransportSTDIO
AuthRequired
UpdatedJun 2, 2026
