Supabase Admin

What it does

This skill allows AI agents to interact with and manage Supabase databases. It enables tasks like creating tables, inserting data, querying information, and performing basic administrative functions within a Supabase project. The agent can execute SQL commands and retrieve results for analysis or further processing.

When to use it

• Data Entry Automation: Automatically populate a new table with data extracted from an external source.
• Report Generation: Query specific data points from the database and format them into a readable report.
• Database Troubleshooting: Execute SQL commands to diagnose and fix issues within the Supabase environment.
• Schema Management: Create or modify tables based on user requests, such as adding new columns.

Key capabilities

• Execute SQL queries against a Supabase database.
• Create new tables in the database.
• Insert data into existing tables.
• Retrieve data from tables.

Example prompts

• "Create a table called 'users' with columns for id, name, and email."
• "What is the average age of users in the 'customers' table?"
• "Insert a new row into the 'products' table with product_name = 'Laptop', price = 1200."

Tips & gotchas

• Requires proper Supabase API keys and project configuration to function correctly. Ensure the agent has appropriate permissions within your Supabase project.