Skip to content
@culpritsql

Culprit SQL

Evidence-based database root-cause analysis. Desktop, CLI, MCP, and fleet telemetry.

Culprit SQL Studio: Find the root cause. Prove the fix.

Open-source performance diagnostics and root-cause analysis for relational databases.

SQL Server Azure SQL PostgreSQL TimescaleDB YugabyteDB MySQL MariaDB SQLite

culpritsql.com · Guide · Architecture · Coding Agents (MCP) · Collector & ADX · Releases

Two ways to run it

Mode How it works
Direct
Desktop · CLI · MCP
Connect directly to a database (or open a saved snapshot offline) to inspect top queries, ranked findings, execution plans, live blocking, virtual indexes, and SQL migrations in CI or coding agents.
Fleet Collector
ADX · ClickHouse
Deploy a bounded container in your database network and push verified telemetry and synthesized root-cause findings to Azure Data Explorer (ADX) or ClickHouse (with Blob or S3 recovery).

What it diagnoses

  • Top queries by database time, wait attribution & ranked findings
  • Execution plan regressions, parameter sensitivity & side-by-side plan diffs
  • @TVP cardinality skew, memory-grant starvation & disk spills
  • Page-latch (PAGELATCH) hot pages & tempdb allocation contention
  • Blocking chains, DDL metadata-lock sandwiches & deadlocks
  • Worker-thread (THREADPOOL) & compiler-gateway starvation
  • PostgreSQL subtransaction (SubtransSLRU) & XID wraparound cliffs
  • Transaction-log stalls, slow client consumers & replica redo blocks
  • Version-store (PVS / vacuum) retention & cloud tier throttling
  • Missing/unused indexes & unsafe SQL migrations in pull requests

Alert on root causes directly from ADX

Point an Azure Monitor Scheduled Query Rule or Grafana alert at ADX to page on-call with the culprit and fix already attached:

// Runs every 1m in Azure Monitor / Grafana -> PagerDuty, Slack, or Teams
CulpritIncidentsV1
| where UpdatedAt > ago(5m) and Status == "active" and Severity == "high"
| project StartedAt, DatabaseName, CulpritKind, Headline, CulpritSql, DeveloperAction

Pinned Loading

  1. culprit-sql-studio culprit-sql-studio Public

    Find what's slowing your database down: a free desktop app, CLI and MCP server for SQL Server, PostgreSQL, YugabyteDB, TimescaleDB, MySQL, MariaDB and SQLite performance (slow queries, execution pl…

    Rust 28 3

Repositories

Showing 3 of 3 repositories

People

This organization has no public members. You must be a member to see who’s a part of this organization.

Top languages

Loading…

Most used topics

Loading…