Supabase

What it does

This skill provides access to Supabase, an open-source Firebase alternative. It allows AI agents to interact with and manage data stored within a Supabase project, including creating tables, inserting data, querying information, and performing updates. This enables the agent to build applications or perform tasks that require persistent storage and retrieval of data.

When to use it

• Building a simple web application: The agent can automatically set up database tables and populate them with initial data for a prototype app.
• Data analysis and reporting: The agent can query Supabase databases to extract specific information and generate reports based on the results.
• Managing user accounts and authentication: Integrate user management features into an application using Supabase's built-in authentication system.
• Automating data entry tasks: The agent can be used to automatically insert or update data in a Supabase database from external sources.

Key capabilities

• Database creation and schema definition
• Data insertion, retrieval, updating, and deletion (CRUD operations)
• User authentication management
• Table querying using SQL

Example prompts

• "Create a table called 'users' with columns for name, email, and password."
• "Insert a new user into the 'users' table with the name 'Alice', email '[email protected]', and password 'password'."
• "Retrieve all users from the 'users' table where the email is '[email protected]'."

Tips & gotchas

• Requires proper Supabase project setup and API keys to function correctly.
• Be mindful of SQL injection vulnerabilities when constructing queries; sanitize user inputs appropriately.