Verify connection encryption
verify_connection_encryptionCheck whether the PostgreSQL connection is TLS-encrypted, showing protocol, cipher, key strength, and a cluster-wide tally of encrypted vs unencrypted backends.
Instructions
Report whether MCPg's own connection to PostgreSQL is TLS-encrypted, including the negotiated protocol version, cipher, and key bits (from pg_stat_ssl). Also returns a cluster-wide tally of encrypted vs unencrypted backends (a lower bound under non-superuser privileges). Complements the startup TLS-enforcement check by confirming the live connection actually came up encrypted.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ssl | Yes | ||
| bits | Yes | ||
| cipher | Yes | ||
| version | Yes | ||
| total_connections | Yes | ||
| encrypted_connections | Yes | ||
| unencrypted_connections | Yes |