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/.
Related Servers
Epicor Kinetic MCP Server by CData
A read-only MCP server by CData that enables LLMs to query live data from Epicor Kinetic.
Michelin MCP
Access structured Michelin restaurant data, including cities, countries, cuisines, awards, and facilities.
Hologres
Connect to a Hologres instance, get table metadata, query and analyze data.
Prometheus MCP Server
A Prometheus MCP server with full API support for comprehensive management and deep interaction with Prometheus beyond basic query support. Written in go, it is a single binary install that is capable of STDIO, SSE, and HTTP transports for complex deployments.
MCP Alchemy
Explore, query, and analyze SQLAlchemy-compatible databases directly from your desktop.
AKShare One
Access Chinese stock market data, including historical prices, real-time quotes, news, and financial statements.
Redis MCP Server
An MCP server for interacting with Redis databases, enabling LLMs to access key-value stores.
Toronto Open Data Tools
Query, analyze, and retrieve datasets from Toronto's CKAN-powered open data portal.
Dremio
Integrate Large Language Models (LLMs) with Dremio, a data lakehouse platform.
Microsoft Fabric Analytics
An analytics server providing tools for interacting with the Microsoft Fabric data platform.