Supabase/PostgreSQL Skill

[!WARNING] This skill is in alpha stage and under active development. APIs, features, and functionality may change without notice.

[!NOTE] The dedicated SupabaseSkill is currently Python-only. TypeScript users can still talk to Supabase / PostgreSQL today using the OpenAPI Skill (Supabase ships an OpenAPI spec for REST) or via raw fetch from a custom skill. Track parity at internal/python-typescript-parity.md.

Minimalistic database integration for Supabase and PostgreSQL operations. Execute queries, manage data, and perform CRUD operations with secure credential storage.

Features

Dual Database Support: Works with both Supabase and PostgreSQL

SQL Query Execution: Run parameterized SQL queries safely

CRUD Operations: Create, Read, Update, Delete operations on tables

Secure Credentials: Connection string storage

Per-User Isolation: Each user has their own isolated database configuration

Quick Setup

// Coming soon — track at https://github.com/robutlerai/webagents/issues
// Recommended workaround: point OpenAPISkill at your Supabase REST spec.
//
// import { BaseAgent } from 'webagents';
// import { OpenAPISkill } from 'webagents/skills/openapi';
// const agent = new BaseAgent({
//   name: 'database-agent',
//   model: 'openai/gpt-4o',
//   skills: [
//     new OpenAPISkill({
//       servers: {
//         supabase: {
//           specUrl: 'https://YOUR-PROJECT.supabase.co/rest/v1/?spec',
//           auth: { type: 'bearer', token: process.env.SUPABASE_SERVICE_ROLE_KEY! },
//         },
//       },
//     }),
//   ],
// });

Install dependencies (Python):

pip install supabase psycopg2-binary

Core Tools

`supabase_setup(config)`

Configure database connection with Supabase or PostgreSQL credentials.

`supabase_query(sql, params)`

Execute raw SQL queries with parameterization (PostgreSQL mode only).

`supabase_table_ops(operation, table, data, filters)`

Perform CRUD operations: select, insert, update, delete.

`supabase_status()`

Check database configuration and connection health.

Usage Example

// Coming soon — track at https://github.com/robutlerai/webagents/issues

Configuration

Supabase: supabase_url, supabase_key PostgreSQL: Connection string or individual parameters (host, port, database, user, password)

"Database not configured" - Run supabase_setup() with your credentials "Connection failed" - Verify database server is accessible and credentials are correct "Permission denied" - Check database user privileges and Row Level Security policies