Index SQL codebases into a queryable graph for structural search.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "SQLPrism" yet — see the docs or source repo.
Use SQLPrism to find all queries, views, and stored procedures referencing the `orders` table in the indexed SQL codebase, grouped by file/object.
A grouped list of every place that references the `orders` table.
Use SQLPrism to trace the dependency chain for the `customer_id` column from source to downstream uses, and return a structured path.
A dependency path showing how the column flows across SQL objects.
Use SQLPrism to find repeated JOIN/filter patterns in the codebase and summarize the most common structures.
A summary of the most common SQL structure patterns in the codebase.
When an analyst or developer needs to know which queries, views, or procedures reference a table, they can use structural retrieval. It is more accurate than plain grep for dependency analysis.
In a large SQL project, the codebase can be indexed into a knowledge graph and queried by object relationships to clarify modules and dependencies.
Developers can search for recurring JOIN, filter, or column-usage patterns to reuse existing implementations or review structure.
SQLPrism is an MCP server backed by DuckDB that indexes SQL codebases into a queryable knowledge graph. Its focus is structural SQL queries rather than plain text search.
It does not rely on string matching; it queries SQL structure and object relationships instead. That makes it better for dependencies, references, and patterns.
You need to index the SQL codebase into its knowledge graph first. For installation and integration details, see the source repository.
Connect to SQL Server to query data, inspect schema, and analyze performance.
Connect to SQL Server, inspect schemas, run queries, and analyze OEE metrics.
Query, monitor, and analyze SQL Server and Azure SQL databases directly.
Safely explore and query SQLite databases using natural language.
Let AI query multiple SQL databases read-only and export results.
Connect to MySQL and PostgreSQL and run SQL queries dynamically.