Search Results

PostgreSQL database specialist for query optimization, schema design, security, and performance. Incorporates Supabase best practices and Row Level Security patterns.

Regression testing strategies for AI-assisted development. Sandbox-mode API testing without database dependencies, automated bug-check workflows, patterns to catch blind spots where the same model writes and reviews code.

Backend architecture patterns: repository/service/controller layers, database query optimization, Redis caching, background jobs, middleware chains, and structured error handling.

ClickHouse database patterns: columnar query optimization, MergeTree engine selection, materialized views, data ingestion pipelines, partition strategies, and high-performance analytical workload design.

Zero-downtime database migration patterns: forward-only production migrations, concurrent index creation, nullable column additions, separate schema vs data migrations, rollback planning.

Test-driven development for Laravel with PHPUnit and Pest: factories, database testing, fakes, and coverage targets.

Reference MCP server for PostgreSQL database access with parameterized queries, schema inspection, and read-only mode support.

Reference MCP server for SQLite database operations with query execution, schema inspection, and business insight memo generation.