PostgreSQL
Connect to a PostgreSQL database to query, insert, update, and delete rows using SQL.
Three ways to use PostgreSQL
Chat with Geni
Ask Geni to pull data, take actions, or answer questions using this integration in a conversation.
Build a workflow
Create automated workflows that trigger on events, run on a schedule, or chain multiple tools together.
Power an app
Use this integration as a data source or action layer behind a dashboard, form, or internal tool.
Supported tools
Actions your AI agents can perform with PostgreSQL.
Count Rows
Count the number of rows in a table, optionally with filtering.
Custom Query
Execute any arbitrary SQL statement including joins, aggregations, and complex queries.
Delete Row
Delete one or more rows from a table and optionally return the deleted data.
Find Row
Find a single row by a unique identifier or condition.
Insert Row
Insert a new row into a table and return the inserted data.
List Columns
Retrieve column definitions for a specific table using information_schema.
Get started automating PostgreSQL
Ready-to-use workflows
Prompts using PostgreSQL
SQL Crafter: draft, explain, and review queries from your schema
Upload your schema, metric definitions, and sample rows. Geni drafts queries, explains the joins and grain, and flags risky assumptions before you run.
Sharpen and ship any data analysis
An assistant that turns a fuzzy data question into a clear, defensible answer with sound SQL, dataset checks, and a final quality pass before sharing.
+5Daily KPI snapshot from Postgres to Google Sheets
Every morning at 6am ET, a fresh row of yesterday's signups, active users, MRR, and support tickets lands in your stakeholder Sheet.
Triage Typeform product feedback into Postgres and Slack
Every Typeform submission lands in your Postgres feedback table, gets tagged by sentiment, theme, and severity, and posts a clean summary to Slack.
Daily signup digest in Slack
Get a written read on yesterday's new signups posted to Slack every weekday at 9am, with the headline number, trend, and what changed.
Recover failed Stripe payments with Postgres context and Resend
When a Stripe payment fails, look up the customer in your Postgres database, mark the account past due, and send a personalized recovery email from Resend.
Weekly at-risk customer outreach drafts for your CSM team
Every Monday at 8am, find your paying customers who are quietly disengaging, draft personalized re-engagement emails in Gmail, and queue HubSpot tasks for your CSMs.
