SchemaCrawler
Connect to any relational database, and be able to get valid SQL, and ask questions like what does a certain column prefix mean.
⭐ Star it ⤴️ if you love it!
SchemaCrawler AI MCP Server: Usage
Note
- Please see the SchemaCrawler website for more details.
About
SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format.
This is a bare project that acts as an MCP client for the SchemaCrawler AI MCP Server for use in "Agent" mode. You can find documentation on how to use the server here.
The SchemaCrawler AI MCP Server is available as a Docker image schemacrawler/schemacrawler-ai. It is also available from the the Docker MCP Catalog as a Docker-verified image.
Prerequisites
- Install supporting software
- Docker
- Docker Compose
- Visual Studio Code
- Read Use MCP servers in VS Code
- Clone this project, and open it in Visual Studio Code
Getting Started
Refer to the getting started documentation, and more documentation in docs/.
相關伺服器
Quickbase MCP Server
An MCP server for Quickbase, enabling seamless integration with AI assistants like Claude Desktop.
Milvus
Search, Query and interact with data in your Milvus Vector Database.
MySQL Server
A server for accessing and managing MySQL databases.
MongoDB Mongoose MCP
An MCP server for MongoDB with optional Mongoose schema support.
Federal Reserve Economic Data
Access financial datasets from the Federal Reserve Economic Data (FRED) API.
GoldRush
Exposes Covalent's GoldRush blockchain data APIs as MCP resources and tools.
Couchbase
Interact with Couchbase databases using natural language. Perform CRUD operations, query buckets, and execute N1QL queries.
Rails PG Extras MCP
An MCP interface for the rails-pg-extras gem, providing PostgreSQL metadata and performance analysis through LLM prompts.
LanceDB Node.js Vector Search
Vector search using the LanceDB vector database and Ollama embedding models.
Singapore LTA MCP Server
Access real-time transportation data from Singapore's LTA DataMall API, including bus arrivals and traffic conditions.