• READ
  • WRITE
  • EDIT
  • REVIEW

How to query and update database rows with your AI

Connect your AI to Supabase once. After that, you can manage your database through a simple chat interface.

Ask AI about this page

Short answer

Can I use my AI to manage my Supabase data?

Yes. You can ask your AI to find, add, change, or remove rows in your PostgreSQL tables. This allows you to treat your database like a conversation instead of writing manual SQL queries.

Data management outcomes

Database operations

What happens when you give your AI a command.

READ

Instant data lookups

Your AI pulls specific rows based on your description. You get the exact data you asked for without writing SELECT statements.

WRITE

New record creation

The AI adds new entries to your tables. Just tell it what information to include and it handles the insertion.

EDIT

Targeted row updates

You can modify existing data by describing which records to change. The AI finds the right rows and applies your edits.

REVIEW

Human oversight needed

For sensitive deletions or bulk changes, the AI presents the intended action. You decide if the change should actually happen.

The workflow

What your AI does when the command arrives.

The AI translates your plain English into direct database actions.

  1. Locate data

    The AI scans your tables to find the specific records you mentioned in your prompt.

    db_select

  2. Add information

    When you need to expand your dataset, the AI creates new rows with the provided details.

    db_insert

  3. Modify records

    The AI changes specific values in existing rows to match your new requirements.

    db_update

  4. Remove entries

    If you need to clean up your database, the AI removes the rows you specify.

    db_delete

Try it

Copy these to start.

Use these prompts to begin interacting with your data.

Starting points

These are examples. Swap out the table names and column values to match your actual Supabase schema.

Supabase Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_FP0ge4xEx4qBf4t9J73WhJFmRYGy102qt1vYxGMm/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 capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "supabase-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_FP0ge4xEx4qBf4t9J73WhJFmRYGy102qt1vYxGMm/mcp"
    }
  }
}
Copy into chat04

  • Show me all users in the 'profiles' table who signed up last week.

  • Add a new product to the 'inventory' table with the name 'Blue Widget' and price 19.99.

  • Update the status to 'shipped' for the order with ID 5502.

  • Delete the expired session from the 'user_sessions' table where the token is 'abc123xyz'.

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

Start here

Connect Supabase once, then ask.

Follow the link to link your account. Your credentials stay encrypted and secure, and you can immediately start chatting with your data in any compatible client.

Connect Supabase to your AI

FAQ

How this task behaves

  • 01

    Can my AI write raw SQL queries?

    No. The AI uses specific tools to interact with your data rather than executing arbitrary SQL strings.

  • 02

    Will the AI delete my entire database?

    No. The AI only performs deletions on specific rows that you explicitly identify in your prompt.

  • 03

    Does the AI see all my data?

    The AI only accesses the data required to fulfill your specific request through the connected tools.

  • 04

    Can I undo a change the AI made?

    No. Once a tool executes an update or deletion, the change is permanent in your database. You should always review the AI's plan before confirming destructive actions.

  • 05

    Can the AI create new tables?

    No. This MCP is limited to selecting, inserting, updating, and deleting rows within existing tables.

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

Connect Supabase to Claude, Cursor, ChatGPT & more