AI Conversational Database Agent for Supabase/PostgreSQL

Unlock Natural Language Database Interaction with this AI Agent

This n8n workflow transforms how you interact with your Supabase or PostgreSQL database. Instead of writing complex SQL, you can simply ask questions in plain English. The AI Agent, powered by OpenAI, intelligently interprets your requests, generates the appropriate SQL queries, and retrieves the information for you. This agent is designed for developers, analysts, and even non-technical team members who need quick access to database insights.

This AI Agent possesses key abilities for database interaction:

• Conversational Querying & SQL Generation: Understands natural language requests and dynamically generates SQL queries to fetch, aggregate, or analyze data. It's instructed to handle JSON fields using appropriate operators (e.g., ->>).
• Database Schema Discovery: Can execute queries to list all available tables, providing context for its operations.
• Table Definition Retrieval: Capable of fetching detailed column information (names, types, foreign key references) for specified tables, allowing it to formulate accurate queries.

Key Features & Benefits

• Intuitive Data Access: Ask questions like "Show me all users who signed up last week" or "What's the total revenue from product X this month?"
• AI-Powered SQL: Leverages OpenAI's function-calling capabilities to construct precise SQL queries from your conversational input.
• Schema-Aware Responses: The agent can use its tools to learn about your database structure, leading to more relevant and accurate data retrieval.
• Simplifies Data Analysis: Enables users without deep SQL knowledge to perform data lookups and basic analysis.
• Boosts Productivity: Get database insights faster without the manual overhead of writing and testing SQL queries from scratch.
• Seamless Integration: Connects directly to your Supabase/PostgreSQL database and utilizes n8n's chat interface for a smooth user experience.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to a suitable model (e.g., gpt-3.5-turbo, gpt-4) that supports function calling.
• Supabase account with an active PostgreSQL database, or direct PostgreSQL credentials if not using Supabase.
• Database connection details: Host, Database Name, Username, and Password for your PostgreSQL instance.

1. Ensure you have active accounts for n8n, Supabase (or your PostgreSQL provider), and OpenAI.
2. In Supabase (or your PostgreSQL environment), ensure your database is set up and you have the connection credentials (Host, Database Name, Username, Password).
3. Download the n8n workflow JSON file.
4. Import the workflow into your n8n instance.
5. Configure OpenAI Connection:
   • Select the 'OpenAI Chat Model' node.
   • In the 'Credential for OpenAI API' field, select or create your OpenAI credentials using your API Key.
6. Configure PostgreSQL Connection:
   • This workflow uses three PostgreSQL Tool nodes: 'Run SQL Query', 'DB Schema', and 'Get table definition'.
   • For each of these nodes, select it and go to the 'Credential for PostgreSQL' field.
   • Select or create new credentials. Input your Supabase/PostgreSQL Host, Database, User, and Password. (The workflow template might have placeholder credentials named 'Postgres 5minai'; replace these with your actual credentials as prompted by 'Sticky Note3' in the workflow.)
7. Customize AI Behavior (Optional):
   • Select the 'AI Agent' node.
   • Review and modify the 'System Message' in the 'Options' tab if you want to provide more specific instructions, constraints, or context to the AI about your database or common query patterns.
8. Save and activate the workflow.
9. You can now interact with your AI Database Agent. Send messages to it via the chat interface initiated by the 'When chat message received' trigger. Start by asking simple questions about your database tables or data.