Summation connects to PostgreSQL and any compatible flavor (Amazon RDS, Aurora Postgres, Cloud SQL, Azure Database for PostgreSQL, Supabase, Neon, etc.) using standard host/port credentials.
What you’ll need
A reachable host and port (default 5432).
A database name.
A user with CONNECT on the database, USAGE on the schemas, and SELECT on the tables you want exposed. See GRANT in the Postgres docs.
For most managed providers, an SSL mode that matches the server’s TLS configuration. See SSL Support.
Create a dedicated read-only role for Summation. Its queries are then auditable and there’s no way for the connector to modify data.
Where to find host/port for your provider
Provider
Where to look
Amazon RDS / Aurora
RDS console → your DB instance → Connectivity & security → Endpoint and port. See Connecting to a DB instance.
One of disable, prefer, require, verify-ca, verify-full. Default prefer. See SSL Mode descriptions.
CA Certificate
Optional
Secret
pg_sslrootcert
Upload or paste a PEM CA bundle for verify-ca / verify-full. Required when SSL Mode is verify-ca or verify-full. See SSL Client File Usage.
Connection Pool Size
Optional
Config
N/A
Max concurrent connections from Summation. Default 10. Set in the app; not part of the connector’s API field set.
The field names on the left are form labels; the API takes the keys in the fourth column. Sending host or database in a config object does not work, and because config accepts unknown keys, the connection is created and reports ACTIVE anyway. The failure surfaces later at connections test, as “Postgres database and username are required”, naming the labels, not the keys. Always test straight after creating.
SSL modes
Mode
What it does
disable
No SSL. Don’t use over the public internet.
prefer
Use TLS if the server offers it, otherwise fall back to plaintext; certificate not verified. The default when SSL Mode is left unset.
require
TLS on; certificate not verified.
verify-ca
TLS on; certificate verified against a trusted CA.
verify-full
TLS on; certificate verified and hostname checked. Recommended.
verify-ca and verify-full always require a CA bundle in CA Certificate, including with managed providers that use a well-known public root. Without one, the connection is created and reports ACTIVE, and connections test then fails with “Postgres CA certificate is required.”To get the right bundle, read the chain the server actually presents and take its root:
When verify-full fails, the tempting fix is dropping to require. Don’t. require encrypts the connection but verifies no certificate at all, so it succeeds instantly and silently gives up the protection you were configuring. Supply the CA instead.
Setup SQL
CREATE ROLE summation LOGIN PASSWORD '<strong-password>';GRANT CONNECT ON DATABASE analytics TO summation;GRANT USAGE ON SCHEMA public TO summation;GRANT SELECT ON ALL TABLES IN SCHEMA public TO summation;ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO summation;
Adding datasets
Source references use the form:
postgres:my_database.my_schema.my_table
Common problems
Error or symptom
Likely cause
connection refused
Wrong host/port, or your firewall doesn’t allow Summation’s egress IPs.
SSL connection is required
The server requires TLS. Set SSL Mode to require or stricter.
server certificate ... does not match host name
The cert’s CN/SAN doesn’t include the host. Fix the cert or use verify-ca.
permission denied for relation ...
Grant SELECT on the table to the Summation role.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Summation","colors":{"primary":"#000000","light":"#888888","dark":"#000000"},"logo":{"light":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685","dark":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685"},"favicon":{"light":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368","dark":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368"},"appearance":{"default":"light"},"navbar":{"primary":{"type":"button","label":"Get Started","href":"https://app.summation.com/signup"}},"fonts":{"family":"Inter"},"contextual":{"options":["copy","view","claude","chatgpt"],"display":"header"},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"summation-676748f5","hasAudioNarration":false,"actualSubdomain":"summation-676748f5","customDomains":["docs.summation.com"],"gitSource":{"type":"github","owner":"summationai","repo":"code","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af5cda8b51d0e31167b5abb","clientVersion":"0.0.4205","searchFilterCounts":[{"language":"default","tag":"API","count":156},{"language":"default","tag":"Endpoints","count":144},{"language":"default","tag":"Documentation","count":49},{"language":"default","tag":"Tables","count":31},{"language":"default","tag":"Connectors","count":21},{"language":"default","tag":"Key concepts","count":20},{"language":"default","tag":"Data Connectors","count":17},{"language":"default","tag":"Grid","count":13},{"language":"default","tag":"Conversations","count":12},{"language":"default","tag":"Use cases","count":11}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"a[href=\"https://app.summation.com/signup\"]{border:0!important;box-shadow:none!important}a[href=\"https://app.summation.com/signup\"]>*{background:#000000!important;color:#ffffff!important;box-shadow:none!important;padding-right:1rem!important;padding-left:1rem!important;gap:0!important}a[href=\"https://app.summation.com/signup\"] span,a[href=\"https://app.summation.com/signup\"] svg{color:#ffffff!important}a[href=\"https://app.summation.com/signup\"] svg{display:none!important}a[href=\"https://app.summation.com/signup\"]:hover>*{background:#27272a!important}html[data-current-path=\"/home\"] .eyebrow{display:none}html[data-current-path^=\"/features/\"] .eyebrow{display:none}html[data-current-path=\"/home\"] #header{max-width:41rem;margin-top:3rem}html[data-current-path=\"/home\"] .mdx-content{margin-top:1.5rem}html[data-current-path=\"/home\"] #content-area{width:100%;max-width:64rem}html[data-current-path=\"/home\"] #header>p{margin-top:0.75rem;color:#52525b;font-size:1.125rem;line-height:1.75rem}.home-get-started{display:inline-flex;min-width:10rem;height:2.75rem;align-items:center;justify-content:center;gap:0.5rem;padding-inline:1rem;border-radius:0.75rem;background:#000000;box-shadow:none!important;color:#ffffff!important;font-size:0.875rem;font-weight:500;line-height:1;text-decoration:none!important;transition:background-color 120ms ease}.home-get-started:hover{background:#27272a;box-shadow:none!important}.home-get-started:focus-visible{outline:2px solid #000000;outline-offset:3px}.home-get-started img{width:1rem;height:1rem}.home-section-divider{width:100%;height:0.5px;margin-block:2.5rem;background:#e7e7e7}.home-section-divider+.card-group{margin-top:0!important}html[data-current-path=\"/home\"] .card-group{width:100%;max-width:64rem;grid-template-columns:repeat(3, minmax(0, 1fr))!important;justify-content:center;gap:1.5rem!important}html[data-current-path=\"/home\"] .card-group>.card{--primary: 228 228 231;display:flex;width:100%;min-height:9.5rem;padding:1.3125rem 1.5rem;align-items:center;box-sizing:border-box;margin-block:0!important;border:var(--border-width-border-half, 0.5px) solid\n var(--border-layout-divider, #e7e7e7)!important;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:var(--color-neutral-white, #ffffff);box-shadow:0 1px 2px 0 rgb(0 0 0 / 5%);transition:background-color 120ms ease,\n box-shadow 120ms ease}html[data-current-path=\"/home\"] .card-group>.card:hover{background:#f4f4f5;border-color:#e4e4e7!important}html[data-current-path=\"/home\"] .card-group>.card>div{height:100%;width:100%;padding:0}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-title\"]{font-size:0.9375rem!important}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-content\"]{color:var(--home-card-description, #52525b)!important;font-size:0.875rem!important;line-height:1.25rem!important}html[data-current-path=\"/home\"] .card-group>.card svg{color:#000000!important}html.dark[data-current-path=\"/home\"] .card-group>.card{--primary-light: 63 63 70;--home-card-description: #888888;border-color:#3f3f46!important;background:#18181b}html.dark[data-current-path=\"/home\"] .card-group>.card svg{color:#f4f4f5!important}html.dark[data-current-path=\"/home\"] .card-group>.card:hover{background:#27272a;border-color:#3f3f46!important}html.dark[data-current-path=\"/home\"] .home-section-divider{background:#27272a}.card{background-color:#fafafa!important;transition:background-color 120ms ease,\n border-color 120ms ease}.card:hover{background-color:#f4f4f5!important}html.dark .card{background-color:#18181b!important}html.dark .card:hover{background-color:#232326!important}#content-area{box-sizing:content-box;width:auto;max-width:700px;margin-inline:auto}#page-title{font-size:2rem!important;line-height:2.5rem!important}#page-context-menu-button{border-radius:8px 0 0 8px!important}#page-context-menu>button[aria-label=\"More actions\"]{border-radius:0 8px 8px 0!important}html[data-current-path=\"/home\"] #page-context-menu{display:none!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:first-child{border-color:transparent!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:nth-child(2)>div:first-child>svg{display:none!important}.mdx-content{font-size:15px;letter-spacing:-0.1px}.mdx-content a.link{border-bottom:0;font-weight:400;text-decoration-line:underline;text-decoration-style:dotted;text-decoration-color:#a1a1aa;text-decoration-thickness:from-font;text-decoration-skip-ink:none;text-underline-position:from-font;transition:text-decoration-color 120ms ease-out}.mdx-content a.link:hover{text-decoration-style:solid;text-decoration-color:currentColor}@media (prefers-reduced-motion: reduce){.mdx-content a.link{transition:none}}.mdx-content>h2{margin-top:3rem!important}#table-of-contents-content{--toc-indicator-height: 1.5rem;--toc-indicator-y: 0px;position:relative;border-left:1px solid #e4e4e7}nav:has(>div>#table-of-contents-content)>h2{display:none}#table-of-contents-content::before{position:absolute;top:0;left:-2px;width:3px;height:var(--toc-indicator-height);border-radius:0;background:#27272a;content:\"\";opacity:0;pointer-events:none;transform:translateY(var(--toc-indicator-y));transition:transform 240ms cubic-bezier(0.4, 0, 0.2, 1),\n height 240ms cubic-bezier(0.4, 0, 0.2, 1),\n opacity 120ms ease-out}#table-of-contents-content[data-has-active=\"true\"]::before{opacity:1}@media (prefers-reduced-motion: reduce){#table-of-contents-content::before{transition:opacity 120ms ease-out}}#table-of-contents-content .toc-item>a{padding-left:calc(\n var(--toc-padding-left) + var(--toc-focus-padding, 0rem) + 1rem\n )!important}#table-of-contents-content .toc-item[data-active=\"true\"]>a{font-weight:400;text-shadow:none!important}#table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#4f4f4f}#table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#000000}.dark #table-of-contents-content{border-left-color:#3f3f46}.dark #table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#9e9e9e}.dark #table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#888888}.dark #table-of-contents-content::before{background:#f4f4f5}#navigation-items .sidebar-group>li+li{margin-top:4px}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{width:calc(100% - 0.5rem)!important;margin-left:0.5rem}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{padding-top:0.25rem!important;padding-bottom:0.25rem!important;line-height:1.25rem!important}#sidebar a[aria-current=\"page\"]{background-color:#f4f4f5!important;border-radius:8px!important;color:#000000!important;font-weight:500!important;text-shadow:none!important}#navigation-items a:not([aria-current=\"page\"]):hover{background-color:#fafafa!important}.dark #navigation-items a:not([aria-current=\"page\"]):hover{background-color:#18181b!important}.dark #sidebar a[aria-current=\"page\"]{background-color:#27272a!important;color:#ffffff!important}#sidebar button[aria-expanded]>div:last-child{margin-left:auto}#navigation-items .sidebar-group a span,#navigation-items .sidebar-group button span{hyphens:none}div:has(>form #search-input){padding:0!important;border:0!important;background:transparent!important;box-shadow:none!important}#theme-preference-menu-trigger{width:2.25rem;height:2.25rem;padding:0!important;border:0.5px solid #e4e4e7;border-radius:0.625rem!important}#theme-preference-menu-trigger [data-theme-preference-icon]{display:none!important}#theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:inline-flex!important}html[data-summation-theme-toggle=\"ready\"] #theme-preference-menu-content{display:none!important}.dark #theme-preference-menu-trigger{border-color:#27272a}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:none!important}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"light\"]{display:inline-flex!important}#header-ask-ai,#assistant-entry{display:none!important}.chat-assistant-floating-input{display:none!important}#pagination{display:grid;grid-template-columns:repeat(2, minmax(0, 1fr));gap:1.5rem;padding:0}#footer{border-top:0!important}html[data-current-path=\"/home\"] #pagination{display:none!important}#pagination>a{display:grid;box-sizing:border-box;min-width:0;height:5rem;align-content:center;padding:1rem 1.5rem;column-gap:0.75rem;row-gap:0.5rem;border:1px solid #e4e4e7;border-radius:0.75rem;background:transparent;font-weight:400;transition:border-color 120ms ease,\n background-color 120ms ease}#pagination>a:hover{border-color:#d4d4d8;background:#fafafa}#pagination>a::before{color:#71717a;font-size:0.8125rem;font-weight:400;line-height:1.25rem}#pagination .pagination-prev{grid-template-columns:auto minmax(0, 1fr)}#pagination .pagination-prev::before{grid-column:2;grid-row:1;content:\"Previous\"}#pagination .pagination-next{grid-template-columns:minmax(0, 1fr) auto;margin-left:0;text-align:right}#pagination .pagination-next::before{grid-column:1;grid-row:1;content:\"Next\"}#pagination [data-component-part=\"pagination-chevron\"]{grid-row:1;width:0.25rem;height:0.5rem;align-self:center;stroke-width:1}#pagination [data-component-part=\"pagination-chevron\"] path{stroke-width:1!important}#pagination [data-component-part=\"pagination-title\"]{grid-column:1 / -1;grid-row:2;color:#27272a;font-size:0.9375rem;font-weight:400;line-height:1.5rem}.dark #pagination>a{border-color:#3f3f46}.dark #pagination>a:hover{border-color:#52525b;background:#18181b}.dark #pagination [data-component-part=\"pagination-title\"]{color:#f4f4f5}header .max-w-8xl{max-width:none!important;margin-inline:0!important}#navbar a[href=\"/\"]:has(.nav-logo){display:flex;align-items:center}#navbar a[href=\"/\"] .nav-logo{height:1.25rem!important}.dark #navbar a[href=\"/\"] .nav-logo{filter:invert(1)}#navbar .max-w-8xl>div>div>.flex.items-center{padding-inline:1.5rem!important}@media (max-width: 639px){#navbar a[href=\"/\"] .nav-logo{height:1.125rem!important}}#navbar>div:first-child{border-bottom-color:#f0f0f0!important}:root{--topbar-tabs-height: 0rem !important}@media (min-width: 1024px){#navbar div.hidden.lg\\:flex.px-12.h-12{position:absolute!important;top:0!important;left:183px!important;height:4rem!important;padding:0!important;width:auto!important}#navbar .nav-tabs{column-gap:2rem}#navbar .nav-tabs-item{gap:0.5rem;white-space:nowrap}#navbar .nav-tabs-item:hover>div.absolute.bottom-0{background-color:currentColor}#navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#27272a!important}.dark #navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#888888!important}#navbar .nav-tabs-item[aria-current=\"location\"]{text-shadow:none!important}}@media (min-width: 1024px){#navbar div:has(>#search-bar-entry){flex:0 1 16rem;min-width:12rem}#navbar div:has(>nav[aria-label=\"Main\"]){flex:0 0 auto;margin-left:0}}#search-bar-entry:focus-visible{outline:2px solid currentColor;outline-offset:2px}.sidebar-group-header--collapsible{cursor:pointer;user-select:none}.sidebar-group-header--collapsible:hover{color:#18181b}.dark .sidebar-group-header--collapsible:hover{color:#f4f4f5}.sidebar-group-header--collapsible:focus-visible{outline:2px solid #a1a1aa;outline-offset:2px;border-radius:4px}.sidebar-group-chevron{margin-left:auto;transform:rotate(90deg);transition:transform 120ms ease}.sidebar-group-header--collapsible[data-sidebar-collapsed=\"true\"] .sidebar-group-chevron{transform:rotate(0deg)}ul.sidebar-group[data-sidebar-collapsed=\"true\"]{display:none}header div:has(>#theme-preference-menu-trigger){margin-left:0.5rem!important}#navbar nav:has(a[href=\"https://app.summation.com/signup\"]){margin-right:0!important}header a[href=\"https://app.summation.com/signup\"]{padding-inline:0.75rem!important}header a[href=\"https://app.summation.com/signup\"]>div{padding-inline:0!important;background:#000000!important}@media (min-width: 1024px){html[data-current-path=\"/home\"] #content-container{position:relative;left:7.5rem}#sidebar{width:280px!important;max-width:280px;transform:translateX(min(-2rem, calc((92rem - 100vw) / 2 - 2rem)));border-right:1px solid #f0f0f0}html:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #sidebar{transform:translateX(min(-2rem, calc((115rem - 100vw) / 2 - 2rem)))}#sidebar>#sidebar-content{top:0!important;left:1.5rem!important}#sidebar-content>[class~=\"pr-8\"]{padding-right:1.5rem!important}#sidebar-content .sticky.top-0.h-8{height:1.5rem}#sidebar-content>[data-component-part=\"scroll-area-scrollbar\"][data-orientation=\"vertical\"]{inset-inline-end:-2.5px!important;margin-inline:0!important}.dark #sidebar{border-right-color:rgba(255, 255, 255, 0.18)}}@media (min-width: 1280px){html[data-current-path=\"/home\"] #header,html[data-current-path=\"/home\"] .mdx-content{transform:translateX(-1.625rem)}html[data-current-path=\"/home\"] .mdx-content{width:calc(100% + 5.25rem)}}@media (min-width: 1024px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:0}}@media (min-width: 1280px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #header,html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{transform:none}html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{width:100%}}@media (min-width: 1600px) and (max-width: 1839px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:calc(50vw - 50rem)}}@media (max-width: 767px){#pagination{grid-template-columns:minmax(0, 1fr)}html[data-current-path=\"/home\"] #header{margin-top:2rem}html[data-current-path=\"/home\"] #header>p{font-size:1rem;line-height:1.5rem}.home-section-divider{margin-block:1.5rem}html[data-current-path=\"/home\"] .card-group{grid-template-columns:minmax(0, 1fr)!important}}figure[data-name=\"frame\"]{padding:1.25rem!important;margin-top:0!important;margin-bottom:1.5rem!important;border-radius:var(--border-radius-rounded-xl, 0.75rem)!important;background:#fafafa!important}.columns figure[data-name=\"frame\"]{margin-bottom:0!important}.columns{margin-top:0!important;margin-bottom:1.5rem!important;row-gap:1.5rem!important}html.dark figure[data-name=\"frame\"]{background:#18181b!important}figure[data-name=\"frame\"]>div[class*=\"bg-grid\"]{display:none}figure[data-name=\"frame\"]>div[class*=\"justify-center\"]{overflow:visible;border-radius:0}figure[data-name=\"frame\"] img{border-radius:0.375rem;box-shadow:0 0 0 0.5px #d4d4d8,\n 0 1px 2px 0 rgb(0 0 0 / 5%)}html.dark figure[data-name=\"frame\"] img{box-shadow:0 0 0 0.5px #3f3f46,\n 0 1px 2px 0 rgb(0 0 0 / 30%)}figure[data-name=\"frame\"]>div[class*=\"pointer-events-none\"]{border-color:transparent}@media (max-width: 767px){figure[data-name=\"frame\"]{padding:0.75rem!important}}html[data-current-path=\"/introduction\"] .card-group,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center){row-gap:0.5rem!important}html[data-current-path=\"/introduction\"] .card-group>.card,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center)>.card{margin-block:0!important}.template-meta{display:grid;grid-template-columns:7.5rem minmax(0, 1fr);gap:0.5rem 1rem;margin:0 0 1.5rem;padding:1.25rem;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:#fafafa}.template-meta-label{margin:0;font-weight:500;color:#71717a}.template-meta-value{margin:0}html.dark .template-meta{background:#18181b}html.dark .template-meta-label{color:#a1a1aa}@media (max-width: 639px){.template-meta{grid-template-columns:minmax(0, 1fr);gap:0.25rem;padding:1rem}.template-meta-value:not(:last-child){margin-bottom:0.5rem}}"}],"page":{"pagePath":"features/connectors/postgres","slug":"/features/connectors/postgres","pageMetadata":{"title":"Postgres","description":"Connect Summation to a PostgreSQL database.","href":"/features/connectors/postgres"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Connect Summation to a PostgreSQL database.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Table,Tip,Warning}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Summation connects to PostgreSQL and any compatible flavor (Amazon RDS, Aurora Postgres, Cloud SQL, Azure Database for PostgreSQL, Supabase, Neon, etc.) using standard host/port credentials.`}),`\n`,_jsx(Heading,{level:`2`,id:`what-you’ll-need`,children:`What you’ll need`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`A reachable `,_jsx(_components.strong,{children:`host`}),` and `,_jsx(_components.strong,{children:`port`}),` (default `,_jsx(_components.code,{children:`5432`}),`).`]}),`\n`,_jsxs(_components.li,{children:[`A `,_jsx(_components.strong,{children:`database`}),` name.`]}),`\n`,_jsxs(_components.li,{children:[`A `,_jsx(_components.strong,{children:`user`}),` with `,_jsx(_components.code,{children:`CONNECT`}),` on the database, `,_jsx(_components.code,{children:`USAGE`}),` on the schemas, and `,_jsx(_components.code,{children:`SELECT`}),` on the tables you want exposed. See `,_jsx(_components.a,{href:`https://www.postgresql.org/docs/current/sql-grant.html`,children:`GRANT`}),` in the Postgres docs.`]}),`\n`,_jsxs(_components.li,{children:[`For most managed providers, an `,_jsx(_components.strong,{children:`SSL mode`}),` that matches the server’s TLS configuration. See `,_jsx(_components.a,{href:`https://www.postgresql.org/docs/current/libpq-ssl.html`,children:`SSL Support`}),`.`]}),`\n`]}),`\n`,_jsx(Tip,{children:_jsx(_components.p,{children:`Create a dedicated read-only role for Summation. Its queries are then auditable and there’s no way for the connector to modify data.`})}),`\n`,_jsx(Heading,{level:`3`,id:`where-to-find-host/port-for-your-provider`,children:`Where to find host/port for your provider`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Provider`}),_jsx(_components.th,{children:`Where to look`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Amazon RDS / Aurora`})}),_jsxs(_components.td,{children:[`RDS console → your DB instance → `,_jsx(_components.strong,{children:`Connectivity \u0026 security`}),` → `,_jsx(_components.strong,{children:`Endpoint and port`}),`. See `,_jsx(_components.a,{href:`https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html`,children:`Connecting to a DB instance`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Google Cloud SQL`})}),_jsxs(_components.td,{children:[`Cloud SQL console → your instance → `,_jsx(_components.strong,{children:`Connections`}),`. See `,_jsx(_components.a,{href:`https://cloud.google.com/sql/docs/postgres/connect-overview`,children:`About connection options`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Azure Database for PostgreSQL`})}),_jsxs(_components.td,{children:[`Azure portal → your server → `,_jsx(_components.strong,{children:`Overview`}),`. See `,_jsx(_components.a,{href:`https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/connect-azure-cli`,children:`Connect with Azure CLI`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Supabase`})}),_jsxs(_components.td,{children:[`Project dashboard → `,_jsx(_components.strong,{children:`Project Settings`}),` → `,_jsx(_components.strong,{children:`Database`}),` → `,_jsx(_components.strong,{children:`Connection info`}),`. See `,_jsx(_components.a,{href:`https://supabase.com/docs/guides/database/connecting-to-postgres`,children:`Connect to Postgres`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Neon`})}),_jsxs(_components.td,{children:[`Project dashboard → `,_jsx(_components.strong,{children:`Connection Details`}),`. See `,_jsx(_components.a,{href:`https://neon.tech/docs/connect/connect-from-any-app`,children:`Connect to your database`}),`.`]})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`form-fields`,children:`Form fields`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Field`}),_jsx(_components.th,{children:`Required`}),_jsx(_components.th,{children:`Stored as`}),_jsx(_components.th,{children:`API key`}),_jsx(_components.th,{children:`Notes`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Host`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`pg_host`})}),_jsxs(_components.td,{children:[`DNS name or IP, e.g. `,_jsx(_components.code,{children:`db.example.com`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Port`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`pg_port`})}),_jsxs(_components.td,{children:[`Default `,_jsx(_components.code,{children:`5432`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Database`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`pg_db`})}),_jsx(_components.td,{children:`The Postgres database name (not a schema).`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Username`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`pg_user`})}),_jsx(_components.td,{children:`Login role.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Password`})}),_jsx(_components.td,{children:`Yes`}),_jsx(_components.td,{children:`Secret`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`pg_pass`})}),_jsx(_components.td,{})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`SSL Mode`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`pg_sslmode`})}),_jsxs(_components.td,{children:[`One of `,_jsx(_components.code,{children:`disable`}),`, `,_jsx(_components.code,{children:`prefer`}),`, `,_jsx(_components.code,{children:`require`}),`, `,_jsx(_components.code,{children:`verify-ca`}),`, `,_jsx(_components.code,{children:`verify-full`}),`. Default `,_jsx(_components.code,{children:`prefer`}),`. See `,_jsx(_components.a,{href:`https://www.postgresql.org/docs/current/libpq-ssl.html#LIBPQ-SSL-PROTECTION`,children:`SSL Mode descriptions`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`CA Certificate`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Secret`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`pg_sslrootcert`})}),_jsxs(_components.td,{children:[`Upload or paste a PEM CA bundle for `,_jsx(_components.code,{children:`verify-ca`}),` / `,_jsx(_components.code,{children:`verify-full`}),`. Required when SSL Mode is `,_jsx(_components.code,{children:`verify-ca`}),` or `,_jsx(_components.code,{children:`verify-full`}),`. See `,_jsx(_components.a,{href:`https://www.postgresql.org/docs/current/libpq-ssl.html#LIBPQ-SSL-FILEUSAGE`,children:`SSL Client File Usage`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Connection Pool Size`})}),_jsx(_components.td,{children:`Optional`}),_jsx(_components.td,{children:`Config`}),_jsx(_components.td,{children:`N/A`}),_jsxs(_components.td,{children:[`Max concurrent connections from Summation. Default `,_jsx(_components.code,{children:`10`}),`. Set in the app; not part of the connector’s API field set.`]})]})]})]}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`The field names on the left are form labels; the API takes the keys in the fourth column.`}),` Sending `,_jsx(_components.code,{children:`host`}),` or `,_jsx(_components.code,{children:`database`}),` in a `,_jsx(_components.code,{children:`config`}),` object does not work, and because `,_jsx(_components.code,{children:`config`}),` accepts unknown keys, the connection is created and reports `,_jsx(_components.code,{children:`ACTIVE`}),` anyway. The failure surfaces later at `,_jsx(_components.a,{href:`/features/connectors#manage-a-connection`,children:_jsx(_components.code,{children:`connections test`})}),`, as `,_jsx(_components.em,{children:`“Postgres database and username are required”`}),`, naming the labels, not the keys. Always test straight after creating.`]})}),`\n`,_jsx(Heading,{level:`3`,id:`ssl-modes`,children:`SSL modes`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Mode`}),_jsx(_components.th,{children:`What it does`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`disable`})}),_jsx(_components.td,{children:`No SSL. Don’t use over the public internet.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`prefer`})}),_jsx(_components.td,{children:`Use TLS if the server offers it, otherwise fall back to plaintext; certificate not verified. The default when SSL Mode is left unset.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`require`})}),_jsx(_components.td,{children:`TLS on; certificate not verified.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`verify-ca`})}),_jsx(_components.td,{children:`TLS on; certificate verified against a trusted CA.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`verify-full`})}),_jsxs(_components.td,{children:[`TLS on; certificate verified `,_jsx(_components.em,{children:`and`}),` hostname checked. `,_jsx(_components.strong,{children:`Recommended.`})]})]})]})]}),`\n`,_jsxs(_components.p,{children:[_jsxs(_components.strong,{children:[_jsx(_components.code,{children:`verify-ca`}),` and `,_jsx(_components.code,{children:`verify-full`}),` always require a CA bundle`]}),` in `,_jsx(_components.strong,{children:`CA Certificate`}),`, including with managed providers that use a well-known public root. Without one, the connection is created and reports `,_jsx(_components.code,{children:`ACTIVE`}),`, and `,_jsx(_components.a,{href:`/features/connectors#manage-a-connection`,children:_jsx(_components.code,{children:`connections test`})}),` then fails with `,_jsx(_components.em,{children:`“Postgres CA certificate is required.”`})]}),`\n`,_jsx(_components.p,{children:`To get the right bundle, read the chain the server actually presents and take its root:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`openssl`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` s_client`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -connect`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` \u003c`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`hos`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`t`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`>`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`:5432`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -starttls`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` postgres`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -showcerts`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` \u003c`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`/dev/null`})]}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[`Paste that root PEM into `,_jsx(_components.strong,{children:`CA Certificate`}),` (`,_jsx(_components.code,{children:`pg_sslrootcert`}),`, a secret). Verify it works on its own before sending it:`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`2`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`2`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:`openssl`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` s_client`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -connect`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` \u003c`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`hos`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`t`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`>`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`:5432`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -starttls`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` postgres`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D7BA7D`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -CAfile`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` ./root.pem`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -verify_hostname`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` \u003c`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`hos`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`t`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`>`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` \u003c`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`/dev/null`}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:` # want: Verify return code: 0 (ok)`})]}),`\n`]})})}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[`When `,_jsx(_components.code,{children:`verify-full`}),` fails, the tempting fix is dropping to `,_jsx(_components.code,{children:`require`}),`. Don’t. `,_jsx(_components.code,{children:`require`}),` encrypts the connection but `,_jsx(_components.strong,{children:`verifies no certificate at all`}),`, so it succeeds instantly and silently gives up the protection you were configuring. Supply the CA instead.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`setup-sql`,children:`Setup SQL`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`8`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`8`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`CREATE`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ROLE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`LOGIN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` PASSWORD`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '\u003cstrong-password>'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GRANT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` CONNECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ON`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` DATABASE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` analytics `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation;`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GRANT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` USAGE `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ON`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SCHEMA`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` public `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation;`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GRANT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ON`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` ALL TABLES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`IN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SCHEMA`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` public `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation;`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ALTER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` DEFAULT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` PRIVILEGES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`IN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SCHEMA`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` public`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` GRANT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ON`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` TABLES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` summation;`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`adding-datasets`,children:`Adding datasets`}),`\n`,_jsx(_components.p,{children:`Source references use the form:`}),`\n`,_jsx(CodeBlock,{numberOfLines:`2`,language:`text`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`text`,children:_jsxs(_components.code,{language:`text`,numberOfLines:`2`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`postgres:my_database.my_schema.my_table`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})})]})})}),`\n`,_jsx(Heading,{level:`2`,id:`common-problems`,children:`Common problems`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Error or symptom`}),_jsx(_components.th,{children:`Likely cause`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`connection refused`})}),_jsx(_components.td,{children:`Wrong host/port, or your firewall doesn’t allow Summation’s egress IPs.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`SSL connection is required`})}),_jsxs(_components.td,{children:[`The server requires TLS. Set `,_jsx(_components.strong,{children:`SSL Mode`}),` to `,_jsx(_components.code,{children:`require`}),` or stricter.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`server certificate ... does not match host name`})}),_jsxs(_components.td,{children:[`The cert’s CN/SAN doesn’t include the host. Fix the cert or use `,_jsx(_components.code,{children:`verify-ca`}),`.`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`permission denied for relation ...`})}),_jsxs(_components.td,{children:[`Grant `,_jsx(_components.code,{children:`SELECT`}),` on the table to the Summation role.`]})]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Postgres","description":"Connect Summation to a PostgreSQL database.","href":"/features/connectors/postgres"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"What you’ll need","slug":"what-you’ll-need","depth":2,"children":[{"title":"Where to find host/port for your provider","slug":"where-to-find-host/port-for-your-provider","depth":3,"children":[]}]},{"title":"Form fields","slug":"form-fields","depth":2,"children":[{"title":"SSL modes","slug":"ssl-modes","depth":3,"children":[]}]},{"title":"Setup SQL","slug":"setup-sql","depth":2,"children":[]},{"title":"Adding datasets","slug":"adding-datasets","depth":2,"children":[]},{"title":"Common problems","slug":"common-problems","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/summation-676748f5/109fb4ec55c4f518/theme-toggle.js","/_mintlify/custom/summation-676748f5/767147eed46ae967/toc-indicator.js","/_mintlify/custom/summation-676748f5/82e2d1909a80e450/sidebar-collapse.js"],"subdomain":"summation-676748f5","siteName":"Summation","title":"Postgres - Summation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-09-04T16:45:18.193Z","originalFileLocation":"features/connectors/postgres.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Connect Summation to a PostgreSQL database.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Summation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Postgres - Summation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Connect Summation to a PostgreSQL database.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Summation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.summation.com/features/connectors/postgres\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Connectors\u0026amp;title=Postgres\u0026amp;description=Connect+Summation+to+a+PostgreSQL+database.\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=e9e718318f92e093424d725fe1797baccbdee2e439594a1e9cada559b9217757\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Postgres - Summation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Connect Summation to a PostgreSQL database.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Connectors\u0026amp;title=Postgres\u0026amp;description=Connect+Summation+to+a+PostgreSQL+database.\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=e9e718318f92e093424d725fe1797baccbdee2e439594a1e9cada559b9217757\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Summation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#000000\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.summation.com/features/connectors/postgres\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/features/connectors/postgres.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.summation.com/#organization\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.summation.com#website\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.summation.com/features/connectors/postgres#webpage\",\"url\":\"https://docs.summation.com/features/connectors/postgres\",\"name\":\"Postgres\",\"description\":\"Connect Summation to a PostgreSQL database.\",\"dateModified\":\"2026-09-04T16:45:18.193Z\",\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.summation.com/features/connectors/postgres#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.summation.com/features/connectors/postgres#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Connectors\",\"item\":\"https://docs.summation.com/features/connectors\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Postgres\",\"item\":\"https://docs.summation.com/features/connectors/postgres\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.summation.com/features/connectors/postgres#article\",\"headline\":\"Postgres\",\"name\":\"Postgres\",\"description\":\"Connect Summation to a PostgreSQL database.\",\"url\":\"https://docs.summation.com/features/connectors/postgres\",\"mainEntityOfPage\":{\"@id\":\"https://docs.summation.com/features/connectors/postgres#webpage\"},\"dateModified\":\"2026-09-04T16:45:18.193Z\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Summation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Summation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/features/connectors/postgres.md","siteName":"Summation","nav":{"global":null,"tabs":[{"tab":"Documentation","icon":"book-open","groups":[{"group":"Get started","pages":[{"title":"What is Summation?","href":"/introduction"},{"title":"Connect your data","sidebarTitle":"1. Connect your data","href":"/get-started/connect-your-data"},{"title":"Create your first analysis","sidebarTitle":"2. Create your first analysis","href":"/get-started/first-artifact"},{"title":"Refine your business context","sidebarTitle":"3. Refine your business context","href":"/get-started/build-your-context"},{"title":"Automate your first workflow","sidebarTitle":"4. Automate your first workflow","href":"/get-started/first-workflow"}]},{"group":"Key concepts","pages":[{"title":"Addison","href":"/features/addison"},{"title":"Projects","href":"/features/projects"},{"group":"Artifacts","pages":[{"title":"Verified Artifacts","sidebarTitle":"Overview","href":"/features/artifacts"},{"title":"Verification","href":"/features/artifacts/verification"},{"title":"Reports","href":"/features/artifacts/reports"},{"title":"Dashboards","href":"/features/artifacts/dashboards"},{"title":"Decks","href":"/features/artifacts/decks"},{"title":"Playbooks","href":"/features/artifacts/playbooks"},{"title":"Excel","href":"/features/artifacts/excel"},{"title":"HTML","href":"/features/artifacts/html"}]},{"title":"Workflows","href":"/features/workflows"},{"title":"Applications","href":"/features/applications"},{"group":"Tables","pages":[{"title":"Tables","sidebarTitle":"Overview","href":"/features/tables"},{"title":"Data table","href":"/features/tables/data"},{"title":"Source table","href":"/features/tables/source"},{"title":"Calculation table","href":"/features/tables/calculation"},{"title":"Dimension table","href":"/features/tables/dimension"},{"title":"Views","href":"/features/tables/views"}]},{"title":"Knowledge","href":"/features/knowledge"},{"title":"Skills","href":"/features/skills"}]},{"group":"Connectors","pages":[{"title":"Connectors","sidebarTitle":"Overview","href":"/features/connectors"},{"title":"Apps","href":"/features/connectors/apps"},{"title":"Snowflake","href":"/features/connectors/snowflake"},{"title":"BigQuery","href":"/features/connectors/bigquery"},{"title":"Databricks","description":"Connect Summation to Databricks via SQL Warehouse, Spark Connect, or direct Delta Lake.","href":"/features/connectors/databricks"},{"title":"Postgres","href":"/features/connectors/postgres"},{"title":"Redshift","description":"Connect Summation to an Amazon Redshift data warehouse.","href":"/features/connectors/redshift"},{"title":"MySQL","href":"/features/connectors/mysql"},{"title":"SQL Server","href":"/features/connectors/mssql"},{"title":"ClickHouse","href":"/features/connectors/clickhouse"},{"title":"MongoDB","href":"/features/connectors/mongodb"},{"title":"Oracle","href":"/features/connectors/oracle"},{"title":"MotherDuck","href":"/features/connectors/motherduck"},{"title":"REST API","href":"/features/connectors/http"},{"title":"Datadog","href":"/features/connectors/datadog"},{"title":"S3","href":"/features/connectors/s3"},{"title":"Apache Iceberg","href":"/features/connectors/iceberg"},{"title":"AWS Glue","href":"/features/connectors/glue"},{"title":"GCS","href":"/features/connectors/gcs"},{"title":"Google Sheets","href":"/features/connectors/google-sheets"},{"title":"GitHub","href":"/features/connectors/github"}]},{"group":"Agent integrations","pages":[{"title":"Claude Plugin","href":"/integrations/claude-plugin"},{"title":"Codex Plugin","href":"/integrations/codex-plugin"},{"title":"MCP Server","href":"/integrations/mcp-server"}]}]},{"tab":"Use cases","icon":"lightbulb","pages":[{"title":"Use cases","href":"/use-cases/overview"}]},{"tab":"API","icon":"code","pages":[{"title":"API","href":"/api/overview"}]}]},"basePath":"","title":"Postgres - Summation","deploymentId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","buildId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","dynamics":[],"chunks":[]}