Back to Prompts
Database
Database Schema Designer with Migrations
Neura Editorial April 24, 2026
0 copies 0 likes
Design database tables with proper types, constraints, indexes, and migration files for PostgreSQL/Supabase.
Prompt
Design a database schema for [feature_description]. Requirements: - Use PostgreSQL-compatible types (uuid, timestamptz, text, integer, jsonb) - Primary key should be uuid with gen_random_uuid() default - Include created_at and updated_at timestamptz columns with defaults - Add proper foreign key constraints with ON DELETE behavior - Create indexes for columns used in WHERE clauses and JOINs - Add CHECK constraints for enum-like values - Include Row Level Security (RLS) policies if using Supabase - Write the migration as a .sql file - Add a rollback migration (DOWN) as comments - Include seed data examples as INSERT statements - Consider soft delete (deleted_at) vs hard delete based on requirements - Add comments on non-obvious columns
How to Use
Describe your feature and Cursor will design the full schema. Provide existing table names to create proper foreign key relationships.
Comments
More Prompts
View allDevelopment
Cursor .cursorrules Generator
Generate optimized .cursorrules files tailored to your project's tech stack, conventions, and team preferences. Covers TypeScript, Python, Rust, Go, and more.
C
CommunityDevelopment
Cursor Agent Mode Full-Stack Builder
Leverage Cursor's Agent mode to build complete features end-to-end. Handles file creation, terminal commands, dependency installation, and multi-file edits in one flow.
C
CommunityReact
React Component Generator with TypeScript and Tests
Generate complete React components with TypeScript types, props interface, stories, and unit tests in one prompt.
N
Neura EditorialNext.js
Next.js API Route Builder with Validation and Error Handling
Generate robust Next.js API routes with Zod validation, error handling, rate limiting, and TypeScript types.
N
Neura EditorialPython
Python FastAPI Endpoint with Pydantic Models
Generate FastAPI endpoints with Pydantic request/response models, dependency injection, and async database operations.
N
Neura EditorialTesting
Comprehensive Unit Test Suite Generator
Generate thorough unit test suites with edge cases, mocking, and coverage for any function or module.
N
Neura Editorial