create_connection
Register a new database connection with encrypted credentials to enable subsequent schema introspection and querying.
Instructions
Register a new target database connection (credentials encrypted at rest).
Use once per database before introspecting or querying it. This only stores the connection — it does NOT verify connectivity or read the schema; follow with test_connection, then introspect_connection. Returns the created connection's id and metadata.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Unique, human-friendly name used to reference this connection later. | |
| connector_type | Yes | One of: postgresql, bigquery, databricks, mysql, snowflake. | |
| connection_string | Yes | Driver URL (PostgreSQL/MySQL) or connector-specific JSON config (BigQuery/Databricks). Stored encrypted at rest. | |
| default_schema | No | Default schema to introspect and query when none is specified. | public |
| max_rows | No | Maximum number of rows any query on this connection may return. | |
| max_query_timeout_seconds | No | Per-query timeout, in seconds, for this connection. |