# backend-database-specialist

backend-database-specialist guides backend architecture and database setup using Supabase. Helps configure PostgreSQL queries, Row Level Security policies, and user authentication.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 159 installs · ★ 50 repo stars
- Author: qodex-ai
- License: LicenseRef-Proprietary · policy=link-only · description only; the file stays with the author
- Source: https://github.com/qodex-ai/ai-agent-skills/tree/HEAD/skills/backend-database-specialist/SKILL.md
- Updated: 2026-01-05
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/backend-database-specialist

## What it does

This skill guides database design, query construction, and service integration for Supabase projects. It supplies code snippets for the `@supabase/supabase-js` library, including join filters, full-text search, and RPC stored procedures.

The skill also covers user signup, OAuth providers, multi-factor authentication, file storage buckets, realtime channels, and serverless Edge Functions running on Deno.

Official reference markdown files must be fetched separately using `docpull`, otherwise the assistant cannot search the local offline docs directory.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add qodex-ai/ai-agent-skills --skill backend-database-specialist -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/backend-database-specialist/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/backend-database-specialist/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add qodex-ai/ai-agent-skills --skill backend-database-specialist -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/backend-database-specialist/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add qodex-ai/ai-agent-skills --skill backend-database-specialist -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/backend-database-specialist/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install qodex-ai/ai-agent-skills skills/backend-database-specialist
```

2. **Manually: put the files in place**
- File: `.github/skills/backend-database-specialist/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add qodex-ai/ai-agent-skills --skill backend-database-specialist -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/qodex-ai/ai-agent-skills --path skills/backend-database-specialist
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/backend-database-specialist/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add qodex-ai/ai-agent-skills --skill backend-database-specialist -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/qodex-ai/ai-agent-skills/tree/HEAD/skills/backend-database-specialist/SKILL.md

## When to use it
- Configure user authentication with OAuth or magic links
- Write filtered data queries using `@supabase/supabase-js`
- Set up Row Level Security policies for table protection
- Implement vector search workflows with `pgvector`

## Example prompts
- Write a Supabase query to fetch published posts with their author profiles
- Help me set up Google OAuth authentication in a Next.js project
- How do I define an RLS policy for the user profiles table?

## Similar
- [database-reviewer](https://affpapa.org/en/nevibecode/agents/database-reviewer.md) — subagent · ★ 880 repo stars
- [supabase-admin](https://affpapa.org/en/nevibecode/skills/supabase-admin.md) — skill · 200 installs
- [supabase-postgres-best-practices](https://affpapa.org/en/nevibecode/skills/supabase-postgres-best-practices-2.md) — skill · 146 installs
- [supabase-schema-architect](https://affpapa.org/en/nevibecode/agents/supabase-schema-architect.md) — subagent · 3839 installs
- [database-security](https://affpapa.org/en/nevibecode/skills/database-security.md) — skill · 208 installs
- [supabase-security-audit](https://affpapa.org/en/nevibecode/commands/supabase-security-audit.md) — command · 1020 installs

From the same set: [qodex-ai/ai-agent-skills](https://affpapa.org/en/nevibecode/by/qodex-ai/ai-agent-skills.md) — 42 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
