Guides for production databases.
Step-by-step answers to the problems that come up when you own a database in production, with the exact queries, and how Quorum handles the same job.
How to find what's blocking in SQL Server
Find the session at the root of a blocking chain in SQL Server, see what it holds, and decide whether to end it — with the exact DMV queries.
Read the guidePostgreSQLHow to find slow queries in PostgreSQL
Find what is slow right now and what has been slow over time in PostgreSQL, using pg_stat_activity, pg_stat_statements and EXPLAIN.
Read the guideData protectionHow to mask PII before using AI on your database
Keep personal and health data out of AI prompts when you ask an assistant about your database: classify columns, mask on every path, and fail closed.
Read the guidePostgreSQLHow to find blocking and deadlocks in PostgreSQL
Find which session is blocking others in PostgreSQL, read deadlock errors, end the right backend, and set timeouts so it happens less.
Read the guideMySQLHow to find slow queries in MySQL
Find slow queries in MySQL 8 with Performance Schema, the sys schema and the slow query log, then see why with EXPLAIN ANALYZE.
Read the guideSQL ServerHow to read a SQL Server execution plan
Capture the actual execution plan in SQL Server and read it: scans and seeks, key lookups, estimated against actual rows, warnings and Query Store history.
Read the guidePostgreSQLHow to find long-running transactions in PostgreSQL
Find old and idle-in-transaction sessions in PostgreSQL, understand how they block vacuum and cause bloat, and set timeouts that stop them.
Read the guideAI & MCPHow to connect Claude, OpenAI or Cursor to your database safely over MCP
Give an AI assistant access to your database over MCP without giving it production write access: read-only roles, limits, masking and a review gate for writes.
Read the guideSchemaHow to compare database schemas between staging and production
Find schema drift between environments in PostgreSQL, MySQL and SQL Server: what to compare, how to diff it, and how to reconcile safely.
Read the guide