scherlok
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SCHERLOK_CONNECTION | Yes | Database connection string for Scherlok MCP server |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_tablesA | List the tables visible to the configured warehouse connection. Returns the table names (capped) and a total count. Use this to discover
what can be profiled before calling |
| investigateA | Profile tables and store them as the baseline for future anomaly checks. Pass |
| watchA | Profile tables and detect anomalies against the stored baseline. Returns the anomalies found (type, severity, message per table), capped.
Pass |
| statusA | Report the current monitoring state. Returns the connection target (password redacted), how many tables the connection can see, and how many anomalies were recorded in the last 30 days. A quick health glance without profiling anything. |
| historyA | Return anomalies recorded in the last Reads from the local profile store — does not re-profile the warehouse. |
| checkA | Run a watch over all tables and return a CI-style pass/fail gate.
|
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 6 tools
Each tool has a distinct purpose: check is CI pass/fail, history retrieves past anomalies, investigate profiles and sets baseline, list_tables discovers tables, status gives health, watch detects anomalies against baseline. No overlap in functionality.
All tool names are short, imperative verbs except for 'history' which is a noun. However, the naming is consistent in style and easy to understand, with no mixing of conventions like camelCase or snake_case.
6 tools is appropriate for a data quality monitoring server. Each tool covers a necessary step in the workflow (discovery, profiling, detection, CI, history, status) without unnecessary bloat.
The tool set covers the core monitoring lifecycle: table discovery, profiling, baseline setting, anomaly detection, CI check, history, and status. Minor gaps exist, such as no tool for resetting baselines or managing anomalies, but these are manageable.