PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Defining and validating database schemas with proper typing, index configuration, optional fields, unions, and migration strategies for schema changes

Use when building RAG systems, vector databases, or knowledge-grounded AI applications requiring semantic search, document retrieval, or context augmentation.

Use when building RAG systems, vector databases, or knowledge-grounded AI applications requiring semantic search, document retrieval, or context augmentation.

{{SKILL_DESCRIPTION}}. Use when users request {{USE_CASES}}. Demonstrates the System Skill Pattern (CLI + SKILL.md + Database).

Optional advanced tool for complex data modeling. For simple table creation, use relational-database-tool directly with SQL statements.

Write integration tests using TestContainers for .NET with xUnit. Covers infrastructure testing with real databases, message queues, and caches in Docker containers instead of mocks.

Best practices for TYPO3 local development with DDEV, including configuration, database management, multi-version testing, and common workflows for v13/v14.

Implement query caching strategies to improve performance. Use when setting up caching layers, configuring Redis, or optimizing database query response times.

Local development environment with Docker Compose for PostgreSQL and other services. This skill should be used when setting up local infrastructure, managing development databases, or configuring...

Database migration creation with mandatory RLS policies and ARCHitect approval workflow. Use when creating migrations, adding tables with RLS, or updating Prisma schema.

Use when user needs PostgreSQL database administration, performance optimization, high availability setup, backup/recovery, or advanced PostgreSQL feature implementation.

Separate pure computation from side effects. Core business logic is pure functions, shell handles IO. Use when mixing calculations with database, HTTP, or file operations.

Trigger AI analysis for your data assets. Handles "analyze my database", "generate intelligence", "refresh analysis", "update AI knowledge".

Prisma ORM, schema design, migrations ve type-safe database access.

Loads project context including database schema, business rules, and coding standards before task execution. Use at the start of any significant work to ensure agents have full context.

Expert guide for Supabase integration - database schemas, RLS policies, auth, Edge Functions, and real-time subscriptions. Use when working with Supabase backend features.

Use when fetching related data in loops. Use when seeing multiple queries for one request. Use when database is slow on list endpoints.

Optimize application performance and scalability. Use when investigating slow applications, scaling bottlenecks, or improving response times. Covers profiling, caching, database optimization, and...