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 an official Docker-verified image from the Docker MCP Catalog at mcp/schemacrawler-ai. Early release versions are published at schemacrawler/schemacrawler-ai.
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
mcp-dataverse
Microsoft Dataverse MCP server: 54 tools for CRUD, FetchXML, metadata, audit, batch, solutions and more.
CData Sage 200
A read-only MCP server for querying live Sage 200 data, powered by the CData JDBC Driver.
Noves MCP Server
Access blockchain transaction data in natural language, providing human-readable descriptions for AI assistants.
PostgreSQL
Provides read-only access to PostgreSQL databases, allowing LLMs to inspect schemas and execute queries.
Dremio
Integrate Large Language Models (LLMs) with the Dremio data lakehouse platform.
Financial Datasets
Stock market API made for AI agents
IQ.wiki
Access data and information from IQ.wiki, the world's largest crypto and blockchain encyclopedia.
OceanBase
MCP Server for OceanBase database and its tools
Mem0 MCP
Integrates with Mem0.ai to provide persistent memory capabilities for LLMs, supporting cloud, Supabase, and local storage.
Pinot MCP Server
An MCP server for interacting with Apache Pinot, a real-time distributed OLAP datastore.