Governed AI database access for dbt and SQL — sandboxed queries, schema discovery, and intelligent model building powered by SignalPilot
Pre-write research agent for dbt projects. Reads YML contracts, queries source cardinalities, reads sibling SQL, and returns a structured brief so the main agent can write SQL without burning turns on exploration.
Value verification: call verify_model_values MCP tool, then reason about column name vs aggregation alignment. Read-only - returns report only.
Structure verification: table existence, column completeness via map-columns, row counts, fan-out, cardinality. Read-only - returns report only.
BigQuery-specific SQL patterns: UNNEST for array expansion, STRUCT, ARRAY_AGG, DATE_DIFF/DATE_ADD, backtick-quoted table references, EXCEPT/REPLACE in SELECT, approximate aggregation, partitioned and wildcard tables.
Load when dbt run or dbt parse fails. Covers YML duplicate patches, ref errors, passthrough model warnings, current_date fixes, DuckDB error messages, and zero-row diagnosis.
Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.
Load when task involves dbt snapshots, SCD Type 2, or tracking data changes over time. Covers strategy selection, column casing, verification, and common pitfalls.
Load when task involves adding, writing, or fixing dbt unit tests. Covers unit_tests YAML format, given/expect blocks, edge-case coverage, and the difference between unit tests and schema tests.
Uses power tools
Uses Bash, Write, or Edit tools
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimBased on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
Governed AI database access for dbt and SQL with sandboxed queries, schema discovery, and intelligent model building powered by SignalPilot.
# Cloud
codex mcp add --transport http signalpilot https://gateway.signalpilot.ai/mcp \
--header "Authorization: Bearer sp_YOUR_API_KEY"
# Local / self-hosted
codex mcp add --transport http signalpilot http://localhost:3300/mcp
codex plugin marketplace add SignalPilot-Labs/codex-signalpilot-plugin
codex plugin add signalpilot@signalpilot
One-line install:
codex plugin marketplace add SignalPilot-Labs/codex-signalpilot-plugin && codex plugin add signalpilot@signalpilot
Step 1 gives you the SignalPilot MCP tools. Step 2 adds Codex skills on top.
| Category | Tools |
|---|---|
| Schema Discovery | schema_overview, list_tables, describe_table, explore_table, explore_column, explore_columns, get_relationships, schema_ddl, schema_link |
| Querying | query_database, validate_sql, explain_query, estimate_query_cost |
| Analysis | analyze_grain, schema_statistics, find_join_path, compare_join_types, get_date_boundaries, schema_diff |
| Governance | check_budget, query_history, audit_model_sources, validate_model_output |
| Infrastructure | list_database_connections, connection_health, connector_capabilities |
| Skill | Description |
|---|---|
signalpilot | Main entry point for schema discovery and governed queries |
sql-workflow | Structured SQL query building with verification |
dbt-workflow | Full dbt project workflow for scan, map, validate, write, and verify |
dbt-write | dbt model writing with column naming and type rules |
dbt-debugging | Fix dbt run and parse failures |
| DB-specific | bigquery-sql, snowflake-sql, duckdb-sql, sqlite-sql |
Apache-2.0
npx claudepluginhub signalpilot-labs/codex-signalpilot-plugin --plugin signalpilot-dbtGoverned AI database access for dbt and SQL — sandboxed queries, schema discovery, and intelligent model building powered by SignalPilot
Intelligent draw.io diagramming plugin with AI-powered diagram generation, multi-platform embedding (GitHub, Confluence, Azure DevOps, Notion, Teams, Harness), conditional formatting, live data binding, and MCP server integration for programmatic diagram creation and management.
TypeScript/JavaScript full-stack development with NestJS, React, and React Native
Complete creative writing suite with 10 specialized agents covering the full writing process: research gathering, character development, story architecture, world-building, dialogue coaching, editing/review, outlining, content strategy, believability auditing, and prose style/voice analysis. Includes genre-specific guides, templates, and quality checklists.
Complete AI coding workflow system. Self-correcting memory + persistent FTS5-indexed research wikis + auto-research loop + multi-LLM council on a single SQLite store. 33 skills, 8 agents, 22 commands, 37 hook scripts across 24 events. Cross-agent via SkillKit.
Open-source, local-first Claude Code plugin for token reduction, context compression, and cost optimization using hybrid RAG retrieval (BM25 + vector search), reranking, AST-aware chunking, and compact context packets.
Comprehensive skill pack with 66 specialized skills for full-stack developers: 12 language experts (Python, TypeScript, Go, Rust, C++, Swift, Kotlin, C#, PHP, Java, SQL, JavaScript), 10 backend frameworks, 6 frontend/mobile, plus infrastructure, DevOps, security, and testing. Features progressive disclosure architecture for 50% faster loading.