Supabase Database

The supabase-database skill enables AI agents to interact directly with Supabase projects, allowing for automated database management and data retrieval. It facilitates seamless integration between code generation tasks and persistent data storage within the Supabase ecosystem.

When to use it

• Automating the creation of new tables or modifying existing schema structures based on project requirements.
• Executing complex SQL queries to retrieve, update, or delete specific datasets without manual intervention.
• Integrating real-time data feeds into applications by managing Supabase subscriptions and triggers.
• Performing routine maintenance tasks such as running migrations or optimizing database performance.

Key capabilities

• Direct connection to Supabase instances via API keys or service role credentials.
• Execution of raw SQL commands for custom data manipulation.
• Management of table schemas, including adding columns or altering types.
• Real-time synchronization with Supabase's edge functions and database triggers.

Example prompts

• "Create a new 'users' table in my Supabase project with fields for id, email, and created_at timestamp."
• "Run a query to find all active users who signed up in the last 30 days and return their emails."
• "Update the schema of the 'products' table to add a new boolean column called 'is_featured'."

Tips & gotchas

Ensure your AI agent has the correct service role or API key permissions before attempting write operations, as default keys may lack administrative privileges. Always validate generated SQL queries in a test environment before deploying them to production databases to prevent data loss.