Databases
SignalPilot ships 11 database connectors. Each maps to a db_type value used in connection config, runs through the same SQL governance layer (DDL/DML blocking, LIMIT injection, dangerous-function denylist, PII-redacted audit logs), and is grouped into a capability tier.
All connectors
| Database | db_type | Cloud / Local | Tier | Page |
|---|---|---|---|---|
| PostgreSQL | postgres | Cloud + Local | 1 | PostgreSQL |
| MySQL | mysql | Cloud + Local | 1 | MySQL |
| Snowflake | snowflake | Cloud | 1 | Snowflake |
| BigQuery | bigquery | Cloud | 1 | BigQuery |
| Redshift | redshift | Cloud | 2 | Redshift |
| ClickHouse | clickhouse | Cloud + Local | 2 | ClickHouse |
| Databricks | databricks | Cloud | 2 | Databricks |
| Microsoft SQL Server | mssql | Cloud + Local | 2 | SQL Server |
| Trino | trino | Cloud + Local | 2 | Trino |
| DuckDB | duckdb | Local (+ MotherDuck) | 3 | DuckDB |
| SQLite | sqlite | Local | 3 | SQLite |
Tiers
Tiers describe the depth of metadata and governance features available per connector.
| Tier | Query | Schema introspection | FK discovery | EXPLAIN | Cost estimation | Schema stats |
|---|---|---|---|---|---|---|
| 1 | Full | Full | Yes | Yes | Yes (BigQuery exact; Snowflake estimated) | Yes |
| 2 | Full | Full | Yes | Yes | Limited | Partial |
| 3 | Full | Full | Yes | Yes | No | No |
Use the connector_capabilities MCP tool to see the detected tier and feature set for any connection. See the Dialect Support Matrix for per-dialect facts.