#SQL
5 entries
Prompt
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.
Next.jsPostgreSQLTypeScript
Cursor · Claude Code Updated Jun 8, 2026
Playbook
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.
Next.jsPostgreSQLTypeScript
Cursor · Claude Code Updated Jun 8, 2026
Checklist ★ Popular
Checklist for Reviewing AI-Generated SQL Queries
A human review checklist for SQL written by AI coding agents — correctness, injection, performance, and migrations.
PostgreSQLTypeScript
Cursor · Claude Code Updated Jun 8, 2026
Failure
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.
PostgreSQLTypeScript
Cursor · Claude Code Updated Jun 8, 2026
Failure
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.
PostgreSQLTypeScript
Cursor · Claude Code Updated Jun 8, 2026