Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / AI Agents & Assistants

AI Agents & Assistants

Chat with Postgres Using Text-to-SQL with OpenAI

When a chat message arrives, an AI agent using OpenAI or DeepSeek reads the Postgres schema, writes SQL queries, and answers questions about the data.

Import it free Sign in to open it

The steps

  1. Window Buffer Memory
  2. No Operation, do nothing
  3. Add table name to output
  4. Save file locally
  5. Extract data from file
  6. Chat Trigger
  7. AI Agent
  8. When clicking "Test workflow"
  9. Combine schema data and chat input
  10. Load the schema from the local file
  11. Extract SQL query
  12. Check if query exists
  13. Format query results
  14. Prepare final output

25 steps in total.

Similar automations

Data Sync & ETLRun an SQL Query on Microsoft SQL Server2 stepsData Sync & ETLRun an SQL Query in Microsoft SQL Server3 stepsAI Agents & AssistantsTurn Email Questions into SQL with Ollama and Claude23 stepsAI Agents & AssistantsAsk Questions About Emails and Run Claude-Generated SQL28 steps