SQL Server
Connect to a Microsoft SQL Server database to query, insert, update, and delete rows using T-SQL.
Three ways to use SQL Server
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 SQL Server.
Count Rows
Count the number of rows in a table, optionally with a WHERE filter.
Custom Query
Execute any arbitrary T-SQL statement including JOINs, aggregations, subqueries, and DDL.
Delete Row
Delete one or more rows from a table and return deleted rows using OUTPUT DELETED.
Find Row
Look up a single row by a unique column value (e.g. email, ID).
Insert Multiple Rows
Insert multiple rows in a single statement using a VALUES list with OUTPUT INSERTED.
Insert Row
Insert a single row into a table and return the inserted row using OUTPUT INSERTED.
Get started automating SQL Server
Ready-to-use workflows
Prompts using SQL Server
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.
Mirror HubSpot contacts into a SQL Server warehouse in real time
The moment a contact is created or updated in HubSpot, the matching row appears in your SQL Server contacts table. No nightly job, no drift.
Recover failed Stripe payments with SQL Server context and Gmail dunning
When a Stripe invoice payment fails, enrich the customer from your SQL Server billing database, send a tone-matched recovery email through Gmail, and log every attempt for retention.
Slack data Q&A bot for your SQL Server database
@-mention the bot in Slack with any plain-English question. It queries your SQL Server database, summarizes the answer, and shows the exact SQL it ran.
Capture Typeform leads in SQL Server, score them, and alert sales in Slack
Every new Typeform response lands in your SQL Server leads table with a hot, warm, or cold score, and your sales channel only lights up for the ones worth chasing.
Morning KPI digest from SQL Server to Slack
Every weekday at 8:33am, your database becomes a short executive briefing in Slack with the day's headline numbers, wins, regressions, and a watch list.