skills.rest
qodex-ai
qodex-aiOFFICIAL
Explore all skills by this author →
GitHub

backend-database-specialist

Guide Supabase backend and database design with PostgreSQL, RLS, and client libraries.

39|1|Updated Dec 21, 2025
Search Tags:#authentication#database#postgresql#backend#supabase#next.js#real-time
One-click install
npx skills add https://github.com/qodex-ai/ai-agent-skills --skill backend-database-specialist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backend-database-specialist
Source: https://github.com/qodex-ai/ai-agent-skills/tree/main/skills/backend-database-specialist
Command: npx skills add https://github.com/qodex-ai/ai-agent-skills --skill backend-database-specialist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill provides expert guidance for building applications with Supabase, covering database design, authentication, real-time features, and deployment.

Core Features & Use Cases

  • Database Operations: Comprehensive support for PostgreSQL, RLS, migrations, functions, and triggers.
  • Authentication: Handles email/password, OAuth, magic links, SSO, MFA, and phone auth.
  • Real-time & Storage: Manages database changes, broadcast, presence, file uploads, and CDN.
  • AI/ML Integration: Supports pgvector, embeddings, and semantic search for RAG.
  • Framework Integration: Specific guidance for Next.js, React, Vue, Svelte, and React Native.

Quick Start

Use the backend-database-specialist skill to help me set up user authentication with email and password in my Supabase project.

Frequently Asked Questions about backend-database-specialist

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

FAQPage Schema
How do I set up Supabase authentication with email and password in Next.js?▼

Supabase authentication with email and password in Next.js requires configuring the client library and implementing middleware or server actions for session management. This Skill provides detailed integration examples for email/password auth, middleware, and server actions.

How does Row Level Security (RLS) work in PostgreSQL with Supabase?▼

Row Level Security (RLS) in PostgreSQL with Supabase restricts data access at the row level based on user policies. This Skill offers comprehensive documentation on designing RLS policies to secure database operations effectively.

Can I use Supabase for real-time subscriptions and file storage management?▼

Supabase supports real-time subscriptions for database changes, broadcast, and presence, alongside file storage management with CDN. This Skill advises on implementing real-time features and handling file uploads through storage management.

What's the best way to implement vector search and embeddings for AI applications using PostgreSQL?▼

Implementing vector search and embeddings for AI applications uses pgvector in PostgreSQL. This Skill covers pgvector setup, embedding storage, and semantic search capabilities to build Retrieval-Augmented Generation (RAG) features.

Does Supabase support client libraries for mobile platforms like Dart, Swift, and Kotlin?▼

Supabase supports client libraries for JavaScript, Python, Dart, Swift, and Kotlin. This Skill details platform integrations and client library usage across these languages for backend and database services.

Why use Edge Functions in a Supabase backend architecture?▼

Edge Functions in Supabase backend architecture allow running server-side code close to users for low-latency processing. This Skill provides expert guidance on deploying and managing Edge Functions alongside database and authentication services.

Related Skills

Explore More Software Engineering Skills→
jankneumannjankneumann
4

bao-vault

Seeds OpenBao secrets and configures agent AppRoles from .yaml files.

Community
Intermediate
manutejmanutej
1

supabase-mcp-integration

Integrate Supabase authentication, database operations, realtime, and storage.

Community
Advanced
git-taogit-tao

supabase

Integrate Supabase services for PostgreSQL, authentication, storage, real-time subscriptions, and edge functions.

Community
Intermediate
miketrombamiketromba
2

supabase

Research Supabase documentation and provide guidance on backend development tasks.

Community
Intermediate