WindsurfSQLDatabase

SQL Windsurf Rules

Windsurf rules for SQL: PostgreSQL best practices, query optimization, and schema design conventions.

.windsurfrules

- Use PostgreSQL as the default database; leverage JSONB for semi-structured data
- Use pg_partman for automatic table partitioning on large time-series tables
- Monitor query performance with pg_stat_statements and auto_explain
- Use row-level security (RLS) for multi-tenant data isolation
- Create partial indexes for queries that filter on boolean flags or status columns
- Use BRIN indexes for time-ordered append-only tables
- Schedule VACUUM ANALYZE with appropriate autovacuum settings
- Use pg_cron for scheduled database maintenance tasks

How to use with Windsurf

Create a `.windsurfrules` file in your project root. Windsurf's Cascade AI applies these rules automatically.

← All Windsurf rules All SQL rules →

#sql#postgresql#windsurf#database#coding-rules

Related Rules

TypeScript Windsurf Rules

WindsurfTypeScript

Windsurf rules for TypeScript: strict type safety, functional patterns, and modern TypeScript conventions.

Code Style

typescript · windsurfCopy Ready

React Windsurf Rules

WindsurfReact

Windsurf rules for React: modern patterns, performance, and scalable React architecture.

Architecture

react · windsurfCopy Ready

Go Windsurf Rules

WindsurfGo

Windsurf rules for Go: hexagonal architecture, clean code, observability, and production Go patterns.

Architecture

go · windsurfCopy Ready

Rust Windsurf Rules

WindsurfRust

Windsurf rules for Rust: async Rust, WASM, systems programming, and production Rust patterns.

Architecture

rust · windsurfCopy Ready