SchemaCrawler AI
The SchemaCrawler AI MCP Server enables natural language interaction with your database schema using an MCP client in "Agent" mode. It allows users to explore tables, columns, foreign keys, triggers, stored procedures and more simply by asking questions like "Explain the code for the interest calculation stored procedure". You can also ask it to help with SQL, since it knows your schema. This is ideal for developers, DBAs, and data analysts who want to streamline schema comprehension and query development without diving into dense documentation.
683
8 Tools
Packaged by
Requires Configuration
Requires Secrets
Add to Docker Desktop
Version 4.43 or later needs to be installed to add the server automatically
Tools
| Name | Description |
|---|---|
describe-routines | Get the details and description of database routine (stored procedures or functions), including parameters and return types. This could return a lot of information if not limited by a parameter specifying one or more routines. Returns data as a JSON object. |
describe-tables | Get the details and description of database tables or views, including columns, primary key, foreign keys, indexes and triggers. This could return a lot of information if not limited by a parameter specifying one or more tables. Returns data as a JSON object. |
get-schemacrawler-version | Gets the version of SchemaCrawler |
lint | Lint database schemas. Find design issues with specific tables, or with the entire database. Find problems with database design, such as no indexes on foreign keys. |
list | List names of database objects like tables, routines (that is, functions and stored procedures), sequences, or synonyms. Returns JSON data. |
list-across-tables | List names of names of database objects like columns, indexes, triggers, and foreign keys for tables across the whole database. The corresponding tables are identified, and details can be obtained later by describing those tables. Returns JSON data. |
server-information | Provides more information about the database server, for example the product version, collation and so on. Details will vary based on the type of the server, for example, if it is Oracle, SQL Server, PostgreSQL, MySQL, etc. Returns JSON data. |
table-sample | Gets a few sample rows of data from a table. These rows are selected at random, and so different rows may be returned each time they are requested. Do not use this as a substitute for running a query on a table, but rather to infer what the table may contain. |
Manual installation
You can install the MCP server using:
Installation for