SchemaCrawler-AI
Verified Safeby schemacrawler
Overview
Enables AI agents to query and understand database schemas, facilitating natural language interaction and SQL generation.
Installation
docker run -p 8080:8080 -e SCHCRWLR_MCP_SERVER_TRANSPORT=http -e SCHCRWLR_JDBC_URL="jdbc:hsqldb:mem:testdb" -e SCHCRWLR_DATABASE_USER="sa" -e SCHCRWLR_DATABASE_PASSWORD="" docker.io/schemacrawler/schemacrawler-ai:v17.1.7-1Environment Variables
- SCHCRWLR_MCP_SERVER_TRANSPORT
- SCHCRWLR_DATABASE_USER
- SCHCRWLR_DATABASE_PASSWORD
- SCHCRWLR_JDBC_URL
- SCHCRWLR_SERVER
- SCHCRWLR_HOST
- SCHCRWLR_PORT
- SCHCRWLR_DATABASE
- SCHCRWLR_INFO_LEVEL
- SCHCRWLR_LOG_LEVEL
- SCHCRWLR_EXCLUDE_TOOLS
- SCHCRWLR_ADDITIONAL_CONFIG
- SCHCRWLR_OFFLINE_DATABASE
Security Notes
The `TempFileController` exposes an endpoint that writes fixed content ('HELLO, WORLD!') to a file path derived from user input in the system's temporary directory. While the content is fixed, this pattern of using user-supplied path segments, even with `Path.resolve`, could be a minor concern for path traversal if not fully hardened. The default `allowed-origin: '*'` for HTTP transport is permissive.
Similar Servers
db-mcp-server
Provides AI assistants with structured access to multiple databases, enabling them to execute SQL queries, manage transactions, explore schemas, and analyze performance through a unified interface.
tmcp
Build Model Context Protocol (MCP) servers for AI agents to interact with external tools and data sources, enabling LLMs to access context and perform actions.
scrapegraph-mcp
Provides a Model Context Protocol (MCP) server that integrates with ScrapeGraph AI, enabling language models to perform advanced AI-powered web scraping and structured data extraction across single pages, multiple pages, and search results.
SchemaCrawler-AI-MCP-Server-Usage
The SchemaCrawler AI MCP Server enables AI-powered querying and analysis of database schemas, generating SQL, and identifying design issues, primarily through Visual Studio Code's MCP client.