supabase-node

Create Node.js APIs with Supabase authentication, Drizzle ORM, and Zod validation.

1|Updated Feb 26, 2026

Search Tags:#api #drizzle #supabase #nodejs #express #hono

Ready to run

npx skills add https://github.com/aberrantCode/llm_skills --skill supabase-node-aberrantcode

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: supabase-node
Source: https://github.com/aberrantCode/llm_skills/tree/main/claude/skills/supabase-node
Command: npx skills add https://github.com/aberrantCode/llm_skills --skill supabase-node-aberrantcode

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Developers often spend excessive time wiring authentication, database access, and validation for Node.js APIs. This skill eliminates that setup friction by providing ready‑to‑use patterns integrating Supabase auth with Drizzle ORM and Zod validation.

Core Features & Use Cases

Authentication Middleware: Verify Supabase JWTs and attach user context.
Type‑Safe Queries: Use Drizzle ORM for PostgreSQL interactions.
Input Validation: Zod schemas enforce request payload correctness.
Error Handling: Centralized AppError handling for consistent responses.
Framework Flexibility: Works with Express for traditional servers or Hono for edge deployments. Example: Quickly prototype a blogging backend where users create, edit, and delete posts securely.

Quick Start

Create a new Express API that uses Supabase authentication and Drizzle for database queries.

Frequently Asked Questions about supabase-node

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

FAQPage Schema

How do I set up Supabase authentication in a Node.js API with Drizzle ORM?▼

Supabase authentication in a Node.js API uses middleware to verify Supabase JWTs and attach user context to requests. This integrates with Drizzle ORM for type-safe PostgreSQL queries and Zod for input validation.

Can I use Hono for edge deployments instead of Express with Supabase auth?▼

Yes, Hono works with Supabase auth for edge-ready deployments instead of Express. Both frameworks support centralized AppError handling and integrate with Drizzle ORM for PostgreSQL interactions.

What environment variables do I need to connect Supabase and PostgreSQL in Node.js?▼

Connecting Supabase and PostgreSQL in Node.js requires environment variables for the Supabase URL, anon key, service role key, and a PostgreSQL connection string. These enable secure authentication and database access via Drizzle ORM.

How does Zod validation work with Supabase JWTs in an Express API?▼

Zod validation enforces request payload correctness in an Express API after Supabase JWT authentication middleware verifies the token. This ensures input data matches schemas before Drizzle ORM executes PostgreSQL queries.

What is the best way to handle errors in a Node.js API using Drizzle ORM and Supabase?▼

The best way to handle errors in a Node.js API using Drizzle ORM and Supabase is centralized AppError handling. This ensures consistent API responses across Express and Hono frameworks when queries or authentication fail.