Supabase MCP. Run full CRUD operations directly from your AI client.

You're connecting your AI client straight to a PostgreSQL database. This setup gives your agent full-admin rights—it bypasses row-level security checks so you can test data flows and debug backend logic without hesitation. It’s basically giving your bot the keys to the kingdom, which is exactly what engineers need.

Database Management (CRUD)

When you need to read data, you'll use db_select to query records from any table; it takes PostgREST syntax and specific filters, bringing back up to 50 rows by default. If you just need a quick count of how many records are in a table for pagination metrics, run db_count.

To create new data, you'll use db_insert, providing the agent with a JSON payload that populates a brand-new row in your specified table. Need to change something? You'll use db_update to adjust values in existing rows; remember, it requires a target filter so it doesn't mess up everything. If you gotta wipe stuff out—and this is irreversible—you run db_delete, targeting one or more records from any table.

Backend Logic & Custom Functions

Sometimes the logic needs to happen on the server side, not just in a simple query. You can trigger complex stored procedures or functions defined within PostgreSQL using db_rpc; you'll supply it with the required arguments for that pre-compiled function call. This lets your agent execute heavy backend operations directly.

User and Account Auditing

To check who’s logged in, you can use list_auth_users to retrieve a complete list of every registered user in the Supabase Auth system. If you need deep details on one specific account—say, checking an email or getting their full profile info—you run get_auth_user, feeding it either an ID or an email address.

Storage and File Inspection

If your app uses file storage, this setup handles that too. You start by calling list_storage_buckets to map out every available container the service configured for file management. Once you know which bucket it is, you use list_storage_files to get a list of all specific files stored inside that designated area.

This whole suite gives your agent comprehensive control over querying data records using specified filters, adding brand new rows of structured data into a database table, changing the values in specific targeted rows within a table, executing complex stored procedures or functions defined within PostgreSQL, listing and retrieving detailed information about registered users in the system, and mapping out all available object storage containers and files for debugging file paths.