Scherlok
This server connects Claude to your data warehouse for automated data quality monitoring. It exposes tools for profiling tables, detecting anomalies like volume drops or schema drift, and checking freshness without writing rules or YAML configs. Works with Postgres, BigQuery, Snowflake, MySQL, and DuckDB. The MCP interface gives Claude read-only access to investigate, watch, list_tables, status, history, and check commands. Useful when you want an AI agent to spot data issues during development or review warehouse health on demand. Credentials stay server-side via environment variables, so the model never handles your database connection strings directly. Pairs well with dbt projects if you're already running transformations and want anomaly detection as a follow-up step.
- GitHub stars
- 14
- tools
- 8
- auth
- Secret needed
- transport
- STDIO
- env var
- 1
- last updated
- Nov 12, 2026
Tools
8 toolsPublic tool metadata for what this MCP can expose to an agent.
list_tablesThe agent gets list_tables, investigate, watch, status, history, check, verify and reconcile as tools
The agent gets list_tables, investigate, watch, status, history, check, verify and reconcile as tools
No parameter schema in public metadata yet.
investigate
No parameter schema in public metadata yet.
watch
No parameter schema in public metadata yet.
status
No parameter schema in public metadata yet.
history
No parameter schema in public metadata yet.
check
No parameter schema in public metadata yet.
verifyverify is the read-only gate that never changes the baseline, so an agent that retries can't pass a broken table
verify is the read-only gate that never changes the baseline, so an agent that retries can't pass a broken table
No parameter schema in public metadata yet.
reconcilereconcile checks a table it built against the table it built it from
reconcile checks a table it built against the table it built it from
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageConfiguration
SCHERLOK_CONNECTION*secretWarehouse connection string (postgresql://, bigquery://, snowflake://, mysql://, duckdb:///path). Resolved server-side; never passed by the model.
Readme
Details
- Repository
- github.com/rbmuller/scherlok
- Category
- Data & Analytics
- Package
scherlok- Transport
- STDIO
- Auth
- Required
- Registry
- MCP registry, active
Related Data & Analytics MCP servers
View all
Markdown Formatterxjtlumedia/ai_answer_copierAI Answer Copier — Convert Markdown to PDF, DOCX, HTML, LaTeX, CSV, JSON, XML, XLSX, RTF, PNG0stars
Transform Rules MCP Servervinhphatfsg/transform-rules-rsMCP server for CSV/JSON data transformation using YAML rules2stars
Etld Mcp Serverpablixnieto2/etld-mcp-serverDeterministic B2B Data Middleware. Waterfall parsing for CSV, EDI, SEC & Finance. No hallucinations.2stars
Lakexpress Mcparpe-io/lakexpress-mcpMCP server for LakeXpress — automated database-to-cloud data pipeline as Parquet1stars
GoldenFlowbenseverndev-oss/goldenflowStandardize, reshape, and normalize messy data — CSV, Excel, Parquet, S3, databases.1stars
Chart Canvasgluip/chart-canvasCreate interactive visualizations and query data sources (SQLite, CSV, Parquet, JSON)1stars