• DATA
  • LOGIC
  • INFO
  • HUMAN

How to run postgres functions with your AI

Connect your agent to Supabase to trigger database logic on demand. Once linked, your AI can execute specific backend procedures as easily as answering a question.

Ask AI about this page

Short answer

How can I trigger Postgres functions using my AI?

Your agent uses RPC calls to run any custom function you've defined in your Supabase database. It can also explore your schema to find the right targets for these calls. You'll get direct execution of backend logic through your chat interface.

Where every action lands.

Outcomes of database execution

Depending on the function you trigger, your AI produces different results.

DATA

Updated database state

The AI runs a function that modifies rows or updates values. You'll see the direct impact on your database immediately.

LOGIC

Complex backend processing

The agent triggers heavy computational tasks or multi-step workflows defined in your SQL. The database handles the heavy lifting.

INFO

Schema awareness

The AI identifies which tables and functions are available to use. This helps it pick the right tool for your request.

HUMAN

Manual verification needed

If a function requires sensitive parameters or high-risk changes, the AI stops. You decide when to proceed with the execution.

The workflow

What your AI does when you request a function.

The agent moves from understanding your database structure to executing your specific logic.

  1. Explore the schema

    The agent looks through your database to see what tables and functions exist. This ensures it knows what it can actually call.

    list_tables

  2. Identify the target

    The AI matches your natural language request to a specific Postgres function name. It prepares the necessary arguments for the call.

    list_tables

  3. Execute the RPC

    The agent sends the command to trigger the function in your Supabase instance. The database runs the code and returns the result.

    call_postgres_function

  4. Report results

    The AI interprets the return value from the database. It tells you exactly what happened or what data was returned.

    call_postgres_function

Try it

Copy these to start.

Use these prompts to kick off your first database interaction.

Starting points

Swap the function names and table names for the ones you actually use in your Supabase project.

Supabase Vector Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_r2cwX4M1GouGmm6VnqY7CUQyTiHKovu2fp0L81jN/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Supabase Vector capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "supabase-vector-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_r2cwX4M1GouGmm6VnqY7CUQyTiHKovu2fp0L81jN/mcp"
    }
  }
}
Copy into chat04

  • List all the tables in my Supabase database so I know what we can work with.

  • Run the 'process_user_signup' function for the user with ID 550.

  • Check the 'get_inventory_count' function to see how many items are left in stock.

  • Find the table that stores customer orders and tell me the last five entries.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Supabase Vector once, then ask.

Just provide your Supabase credentials through the Vinkius interface. Your connection is encrypted, and you can start running functions immediately.

Connect Supabase Vector to your AI

FAQ

How the connector behaves

  • 01

    Can the AI delete my entire database?

    No. The AI can only execute the specific functions you have exposed via RPC. It cannot run arbitrary SQL commands or drop tables.

  • 02

    How does the AI know which functions to call?

    It uses the ability to list your tables and inspect your schema to identify valid function names and required arguments.

  • 03

    Can the AI create new tables on its own?

    No. The AI is limited to the tools provided, which are for listing existing tables and calling existing functions.

  • 04

    Does the AI see my database password?

    No. Your credentials are encrypted and managed by Vinkius. Your AI client only interacts with the tools through the secure connection.

  • 05

    Can I restrict what the AI can do?

    Yes. Since the AI can only call functions you've explicitly defined as RPCs, you have full control over its reach within your database.

  • More questions about Supabase Vector? See everything the Supabase Vector Connector can do

Connect Supabase Vector to Claude, Cursor, ChatGPT & more