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.
- Explore the SchemaCrawler command-line with a live online tutorial.
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.
Related Servers
DeepMemory
DeepMemory MCP is a small Model Context Protocol (MCP) server that provides long-term memory storage for conversational agents.
Amazon Neptune
Query Amazon Neptune databases using openCypher, Gremlin, and SPARQL. Supports both Neptune Database and Neptune Analytics.
NCBI Entrez MCP Server
Access NCBI's suite of APIs, including E-utilities, BLAST, PubChem, and PMC services.
CData Reckon Accounts Hosted
A read-only MCP server by CData that enables LLMs to query live data from Reckon Accounts Hosted. Requires a separate CData JDBC Driver.
MCP Variance Log
Logs statistical variations and unusual events in conversation structures to a SQLite database.
Couchbase
Interact with Couchbase databases using natural language. Perform CRUD operations, query buckets, and execute N1QL queries.
CData Bing Ads
A read-only MCP server to query live Bing Ads data using CData's JDBC driver.
Kollektiv MCP
Build and access a personal LLM knowledge base from your editor or client without any infrastructure setup.
KuzuMem-MCP
A distributed memory bank MCP tool that stores memories in a KùzuDB graph database, with repository and branch filtering capabilities.
Redis Cloud
Interact with the Redis Cloud API to manage your Redis databases.