skills.rest
gabrielnsmnto
gabrielnsmntoCOMMUNITY
Explore all skills by this author →
GitHub

db-supabase-setup

Guides interactive setup of Supabase projects with CLI configuration, extensions, and migrations.

3|Updated Feb 7, 2026
Search Tags:#postgresql#migrations#backend#cli#configuration#supabase#database setup
One-click install
npx skills add https://github.com/gabrielnsmnto/kord-aios --skill db-supabase-setup-gabrielnsmnto
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-supabase-setup
Source: https://github.com/gabrielnsmnto/kord-aios/tree/main/src/features/builtin-skills/kord-aios/database/db-supabase-setup
Command: npx skills add https://github.com/gabrielnsmnto/kord-aios --skill db-supabase-setup-gabrielnsmnto

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Setting up a new Supabase project involves many manual steps—CLI login, project linking, environment variables, extensions, and migration structure—that are easy to misconfigure or forget, especially for developers new to the platform. ## Core Features & Use Cases - Guided Project Setup: Walks through creating a new Supabase project, linking an existing one, or configuring a local-only development environment. - Environment & Security Configuration: Generates .env.local templates, updates .gitignore to protect credentials, and verifies database connectivity. - Database Initialization: Enables recommended PostgreSQL extensions (uuid-ossp, pgcrypto, pgjwt), applies performance settings, and scaffolds a migrations/seeds/tests folder structure. - Use Case: A developer starting a new backend project runs this guide to go from zero to a fully linked Supabase project with local development support, helper scripts, and a ready migration workflow in one session. ## Quick Start Ask the agent to set up a new Supabase project for your app and follow the interactive prompts to configure the CLI, environment variables, and initial schema.

Frequently Asked Questions about db-supabase-setup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up a new Supabase project from the command line?▼

Install the Supabase CLI, run supabase login, create the project on the Supabase dashboard, then link it locally with supabase link --project-ref. This guide walks through each step interactively, including environment variable configuration.

How to run Supabase locally for development?▼

Run supabase init to initialize the local setup, then supabase start to launch a local instance via Docker. The local Studio runs on port 54323 and the API on port 54321, and supabase db reset restores the local database.

Which PostgreSQL extensions should I enable in Supabase?▼

Commonly recommended extensions include uuid-ossp for UUID generation, pgcrypto for encryption, pg_stat_statements for query tracking, and pgjwt for JWT functions. Enable them with CREATE EXTENSION IF NOT EXISTS statements through psql.

Why does my Supabase connection fail with connection refused?▼

Connection refused usually means the database is not reachable, the password in .env.local is wrong, or a firewall blocks ports 5432 or 6543. Try the connection pooler on port 6543 and verify credentials in the Supabase dashboard.

How do I fix SSL errors when connecting to Supabase with psql?▼

Add ?sslmode=require to the end of your PostgreSQL connection string. This forces an encrypted connection, which resolves the 'SSL connection has been closed unexpectedly' error when connecting to hosted Supabase databases.

Related Skills

Explore More Software Engineering Skills→
marcoapereirav-archmarcoapereirav-arch

supabase

Automate Supabase table creation, migrations, RLS policies, and schema documentation.

Community
Advanced
wordshepherdwordshepherd

db-reset

Reset database schema with Drizzle migrations and RLS policies.

Official
Intermediate
lucas42lucas42

estate-rollout

Automate estate-wide repository migrations with dry-run diff verification.

Community
Advanced
tjl8787tjl8787

rds

Manage AWS RDS instances for provisioning, backup, restore, and performance optimization.

Community
Advanced