#PostgreSQL
20 entries
Prompt to Add Better Auth to Next.js with PostgreSQL
A copy-paste prompt for adding Better Auth and PostgreSQL session handling to a Next.js App Router project.
Prompt to Add PostgreSQL Full-Text Search
Copy-paste AI prompt to add native PostgreSQL full-text search with tsvector, GIN index, and ranked results to an existing Next.js app.
Prompt to Add Stripe Checkout to a Next.js App
AI agent prompt to add Stripe Checkout with webhook handling, customer portal, and subscription status to a Next.js App Router project.
Prompt to Create an Admin Dashboard in Next.js
AI agent prompt to build a protected Next.js admin dashboard with data tables, server-side auth guards, and a sidebar layout using Tailwind.
AI Coding Rules for Auth and Security
AGENTS.md rules for authentication and security that prevent agents from rolling custom crypto, leaking secrets, or bypassing authorization checks.
AI Coding Rules for PostgreSQL Apps
AGENTS.md rules for PostgreSQL-backed apps covering query safety, migration discipline, indexing conventions, and preventing agents from writing N+1 queries.
Claude Code Rules for Prisma Projects
Claude Code rules for Prisma ORM projects covering migration safety, query patterns, relation loading, and preventing agents from corrupting the schema.
Prompt-to-PR: Add an Admin Data Table
SOP for adding a server-side paginated, sortable, searchable admin data table in Next.js using TanStack Table and a PostgreSQL query — no ORM magic.
Prompt-to-PR: Add Better Auth to a Next.js App
Full SOP for wiring Better Auth into a Next.js App Router project — sessions, email/password, OAuth, and middleware protection in one pass.
Prompt-to-PR: Add PostgreSQL Full-Text Search
SOP for adding native PostgreSQL full-text search with tsvector, GIN index, ts_rank, and a Next.js search API — no third-party search service needed.
Checklist for Reviewing AI-Generated API Routes
A human review checklist for REST and RPC API routes written by AI coding agents — authentication, input validation, rate limiting, and error handling.
Checklist for Reviewing AI-Generated Auth Code
A human review checklist for authentication code written by AI coding agents — sessions, JWTs, OAuth flows, and authorization logic for web apps.
Checklist for Reviewing AI-Generated Prisma Migrations
A human review checklist for Prisma schema changes and migrations written by AI coding agents — data loss, locking, and irreversible operations.
Checklist for Reviewing AI-Generated SQL Queries
A human review checklist for SQL written by AI coding agents — correctness, injection, performance, and migrations.
Checklist for Reviewing AI-Generated Stripe Code
A human review checklist for Stripe integration code written by AI coding agents — webhook security, idempotency, race conditions, and payment flows.
How to Fix AI Generating Invalid Prisma Relations
AI agents generate Prisma schema relations with missing back-relations, wrong referential actions, or mismatched field types that fail prisma validate and prisma migrate.
How to Fix AI Writing Insecure SQL
AI agents build SQL queries with string interpolation instead of parameterized statements, introducing SQL injection vulnerabilities into production database code.
AI Tool Directory — Context Pack
Copyable context pack for an AI tool directory site built with Astro and PostgreSQL, so agents understand the submission flow, tagging system, and content model from prompt one.
Next.js SaaS Starter — Context Pack
Copyable context pack for a Next.js SaaS app with App Router, Better Auth, Stripe billing, and Postgres so your AI agent works correctly from prompt one.
PostgreSQL Search App — Context Pack
Copyable context pack for a full-text and vector search application backed by PostgreSQL with pgvector, so your AI agent writes correct SQL and migration code from the start.