Overview
What is Azure Database for PostgreSQL: Azure Database for PostgreSQL Flexible Server is a fully managed Database-as-a-Service built on the open-source PostgreSQL engine. It runs exclusively on the Flexible Server deployment model and covers PostgreSQL versions 11 through 18 across more than 30 Azure regions. The service handles infrastructure, patching, backups, and high availability automatically, with zone-redundant replication, intelligent tuning, and native vector search via pgvector.
Connecting Azure PostgreSQL Database to Datagrid brings structured database records into a workflow where AI agents execute work against that data. Datagrid imports tables, views, and stored procedure outputs from your PostgreSQL instance on a configurable schedule. Agents then classify, enrich, cross-reference, and route that data automatically.
The primary data flow is one-way: Azure PostgreSQL to Datagrid. After ingestion, Datagrid joins PostgreSQL records with data from CRM platforms, project management systems, and file storage integrations. This creates unified datasets that agents query, analyze, and deliver to downstream channels such as Slack, Microsoft Teams, or email.
How to integrate Azure PostgreSQL Database with Datagrid
This integration imports tables, views, and stored procedure outputs into Datagrid datasets. The setup follows a simple sequence: confirm access, enter server credentials, select the data objects to import, and define how often Datagrid syncs production data.
Configure access
Before you connect Azure PostgreSQL Database to Datagrid, confirm that you can reach the target server and that Azure networking settings permit inbound connections from Datagrid.
Confirm you have an active Azure account with access permissions for the target Azure PostgreSQL Database server.
Gather your server connection details: server name, database name, username, and password.
Configure your Azure PostgreSQL firewall rules to allow connections from Datagrid's IP addresses. Navigate to Azure Portal → your PostgreSQL server → Networking → Firewall Rules and add the required addresses. See the Azure firewall rules documentation for details.
Verify that TLS is enabled on your server. Azure enforces
require_secure_transportby default and permits only TLS 1.2 and 1.3.
Connect the integration
After access is in place, create the integration in Datagrid and choose the PostgreSQL objects you want Datagrid to ingest.
Click + Create in the top left of the Datagrid screen.
Select Connect Apps.
Search for and select the Azure PostgreSQL Database integration.
Enter your server name, database name, username, and password.
Click Next.
Select the data objects you want to import: tables, views, or stored procedures.
Click Start First Import to begin your initial sync.
Authenticate the connection
Datagrid authenticates to Azure PostgreSQL with direct database credentials entered during setup. The connection uses the PostgreSQL username and password over TLS. Azure PostgreSQL also offers Microsoft Entra ID authentication, though this Datagrid integration authenticates through the server credentials entered during setup.
Define sync behavior
Once the integration is connected, define how often Datagrid refreshes the dataset.
Open the left panel and locate your Azure PostgreSQL Database dataset.
Click the ... menu in the top right of the dataset.
Click Edit Pipeline to adjust your integration name if needed.
Click the Schedule button next to the Import Configuration button.
Set your sync frequency: daily, weekly, or monthly.
Specify the time of day for each sync to run.
Define downtime windows if needed, periods when syncs should not execute.
Click Update to save the schedule.
Review data sync details
Use these settings as the operating summary for the integration:
Data objects: Tables, views, stored procedures
Sync direction: One-way (Azure PostgreSQL → Datagrid)
Sync frequency: Configurable, daily, weekly, or monthly with optional downtime windows
Data access type: Object-level
For detailed setup steps, use the Azure PostgreSQL Database connector guide linked at the top of this page.
Why use Azure PostgreSQL Database with Datagrid
This integration fits operators running mission-critical programs who need answers and action from live PostgreSQL records, without manual exports between systems.
AI agents query your database directly: Datagrid AI agents retrieve and act on PostgreSQL records automatically, without manual SQL exports or spreadsheet handoffs.
Row-level enrichment: AI Columns classify, summarize, tag sentiment, and flag anomalies on every imported row without custom ML pipelines.
Cross-platform data joins: Combine PostgreSQL operational data with records from CRM, workspace, and documentation tools in one workspace.
Scheduled syncs replace manual ETL: Set your sync cadence once. Datagrid keeps datasets current, and agents process new data automatically on each refresh.
Natural language access to structured data: Business teams can ask questions about PostgreSQL records in plain language. Agents return specific answers grounded in your data, with no SQL required.
Knowledge base construction from database records: Index PostgreSQL tables, product docs, policy records, and technical specifications into a searchable knowledge corpus that agents use for contextual retrieval.
What you can build with Azure PostgreSQL Database Datagrid integration
Azure PostgreSQL becomes more useful when Datagrid turns stored records into repeatable workflows.
These examples show how project teams and operations leaders can put scheduled database syncs to work across support, finance, compliance, and reporting.
Automated support ticket triage: Store customer support tickets in Azure PostgreSQL. Datagrid ingests the ticket table on schedule, AI Columns classify urgency and sentiment per row, and agents route high-priority tickets to the right team in Slack or Microsoft Teams, without anyone writing a SQL query.
Cross-system customer intelligence: Join PostgreSQL transactional records with CRM opportunity data. Agents identify which customers with open deals also have outstanding invoices or support escalations, then deliver a unified view to account managers.
Regulatory compliance monitoring: Use Azure PostgreSQL as the governed data store for compliance records. Datagrid agents cross-check database entries against policy requirements, flag deviations, and generate audit-ready reports that stay traceable to specific source rows. Organizations in healthcare and financial services already use this architecture for regulatory workflows.
Automated operational reporting: Replace manual SQL-export-to-spreadsheet workflows. Datagrid syncs PostgreSQL datasets on a daily schedule, agents analyze trends and exceptions, and finished reports deliver to email or Teams automatically.
These workflows give operators a repeatable way to move from stored records to action, without rebuilding reporting and review steps by hand.
Resources and documentation
Azure PostgreSQL Database connector setup on Datagrid — prerequisites, connection steps, and schedule configuration
Datagrid AI agents documentation — how agents process and act on connected datasets
Datagrid Knowledge API — create from connection — index PostgreSQL data into a searchable knowledge base
Azure Database for PostgreSQL Flexible Server service overview — official Microsoft product documentation
Azure PostgreSQL REST API reference — server management API specs
Azure PostgreSQL networking overview — firewall rules, VNet integration, and Private Link configuration
Azure PostgreSQL TLS connection guide — SSL/TLS setup for client connections
Build your first Datagrid AI agent — step-by-step tutorial for creating agents over connected data
Frequently asked questions
What authentication methods does Azure PostgreSQL support for external connections?
Azure Database for PostgreSQL Flexible Server supports four authentication methods: basic password authentication, Microsoft Entra ID (token-based), system-assigned managed identity, and user-assigned managed identity. Both Entra ID and password auth can be enabled simultaneously. The Datagrid integration uses direct database credentials entered during setup.
How do I configure firewall rules so Datagrid can reach my Azure PostgreSQL server?
Navigate to Azure Portal → your PostgreSQL server → Networking → Firewall Rules, and add Datagrid's outbound IP addresses. For VNet-integrated servers, confirm that DNS resolves the server FQDN to a private IP. If connectivity breaks after infrastructure changes, review your firewall and networking configuration.
What SSL/TLS version does Azure PostgreSQL require?
Azure PostgreSQL enforces require_secure_transport by default. Only TLS 1.2 and 1.3 are supported. TLS 1.0 and 1.1 are denied. Microsoft recommends sslmode=verify-full or verify-ca, and two root CA certificates, DigiCert Global Root G2 and Microsoft RSA Root CA 2017, must be in the client trust store. Mutual TLS and custom server certificates are not supported.
Can I choose which tables and views to sync with Datagrid?
Yes. During integration setup, after entering your server credentials and clicking Next, you select the specific tables, views, or stored procedures to include in your dataset. You import only the data objects relevant to your workflow.
Similar integrations
PostgreSQL — Connect self-managed or on-premises PostgreSQL instances to Datagrid for the same AI enrichment and agent workflows.