Tools Reference
All 32 SignalPilot MCP tools, grouped by category. Click a category for full parameter and example documentation.
Data Exploration (9 tools)
See Schema & Exploration tools.
| Tool | Description |
|---|---|
list_tables | Compact one-line-per-table overview: columns, PKs, FKs, row counts |
describe_table | Full column details: types, nullability, PKs, annotations, PII flags |
explore_table | Deep-dive: column details + FK refs + sample values + referenced tables |
explore_column | Distinct values with counts, NULL stats, optional LIKE filter |
explore_columns | Multi-column stats: distinct counts, uniqueness, min/max/avg, samples |
schema_overview | Database-wide summary: table count, total rows, FK density, hub tables |
schema_ddl | Full schema as CREATE TABLE DDL with FK constraints |
schema_statistics | High-level stats: table sizes, FK connectivity (sorted by row count) |
schema_diff | Compare current schema against last cached version (DDL changes) |
Query Intelligence (11 tools)
| Tool | Description |
|---|---|
query_database | Execute governed, read-only SQL with auto-LIMIT, DDL blocking, dangerous function blocking, audit, PII redaction |
validate_sql | Syntax + semantic validation via EXPLAIN (no execution, no budget charge) |
explain_query | Execution plan with row estimates and cost warnings |
estimate_query_cost | Dry-run cost estimate before executing (BigQuery: exact bytes) |
debug_cte_query | Break CTE query into steps, validate each independently |
schema_link | Find tables relevant to a natural-language question (NL → schema) |
find_join_path | FK-based join path discovery between two tables (1–6 hops) |
get_relationships | Full ERD: all FK relationships as arrows or adjacency list |
compare_join_types | Compare row counts across INNER/LEFT/RIGHT/FULL OUTER JOIN |
get_date_boundaries | MIN/MAX dates across all DATE/TIMESTAMP columns |
query_history | Recent successful queries for a connection (session memory) |
dbt Intelligence (3 tools)
See dbt tools.
| Tool | Description |
|---|---|
generate_sql_skeleton | Generate a SQL template from YML column spec + ref tables |
dbt_error_parser | Parse raw dbt error output into structured diagnosis + fix suggestion |
analyze_grain | Cardinality analysis: per-key distinct counts, fan-out factors |
Model Verification (3 tools)
See dbt tools.
| Tool | Description |
|---|---|
check_model_schema | Compare materialized columns vs YML-declared columns |
validate_model_output | Row count validation + fan-out detection + empty model detection |
audit_model_sources | Upstream audit: source row counts, fan-out/over-filter ratios, NULL scan |
Operational (4 tools)
See Operational tools.
| Tool | Description |
|---|---|
list_database_connections | List all configured database connections |
connection_health | Latency percentiles (p50/p95/p99), error rates, status per connection |
connector_capabilities | Connector tier classification (Tier 1/2/3) and available features |
check_budget | Remaining query budget for a session |
Project Management (2 tools)
See Operational tools.
| Tool | Description |
|---|---|
list_projects | List all dbt projects |
get_project | Get details of a specific dbt project |
Removed tools
The following tools were removed because the gateway runs in Docker and cannot access local filesystems. Their functionality is available via standalone scripts in the plugin:
execute_code/sandbox_status— sandbox disabled in clouddbt_project_map/dbt_project_validate— usescan_project.pyandvalidate_project.pyin the pluginfix_date_spine_hazards/fix_nondeterminism_hazards— use thedbt-date-spinesskillcreate_project— use the web UI or API