Database skills

This skill guides you through Alembic database migrations for customer support systems, ensuring minimal downtime, data integrity, and safe production

This skill helps you quickly build production-ready Hasura GraphQL APIs with instant generation, fine-grained permissions, and real-time features.

This skill helps you build modern FastAPI backends with async patterns, Pydantic validation, and production-ready deployment strategies.

This skill helps you design and optimize SQLAlchemy ORM patterns, sessions, and queries for fast, scalable PostgreSQL-backed support systems.

This skill helps you master Redis state management for caching, sessions, pub/sub, and distributed locks to build scalable, real-time applications.

This skill helps you implement dbt data transformation pipelines with modular models, tests, documentation, and production workflows to improve data quality.

This skill guides building Spring Boot applications with auto-configuration, DI, REST APIs, data access, security, and cloud-ready patterns.

This skill helps you design, optimize, and maintain high-performance PostgreSQL databases at scale across indexing, partitioning, replication, and tuning.

This skill helps you implement RFC-44 compliant distributed locking using PostgreSQL or Redis to coordinate jobs across instances.

This skill helps you implement full-text search in SQLite using fts5, delivering fast, accurate queries with MATCH across your data.

This skill researches how production Rails apps solve architectural problems by examining real code patterns from the Real World Rails repository.

This skill helps you implement offline content recommendations using SQLite and vector embeddings to deliver fast, scalable related posts.

This skill shows how to store JSON documents in SQLite as a NoSQL-like store with TTL expiration and queries.

This skill guides you to export a SQLite database schema to runnable CREATE statements at runtime using Flutter and sqlite3.

This skill helps you design and query a graph database in Flutter using Drift and SQLite to model and traverse relationships.

This skill shows how to run synchronous SQLite queries on the UI thread in Flutter to boost UI responsiveness and handle large datasets efficiently.

This skill guides you in designing complete GraphRAG systems, selecting patterns, stacks, and domain customizations for robust real-time reasoning.

This skill guides you in designing and building knowledge graphs from unstructured data, offering extraction pipelines, schema patterns, and data model

This skill reviews Rust depot services focusing on Axum, SQLx, WebSocket, and Docker patterns to improve reliability and integration.

This skill creates a test authenticated user to audit access gaps versus anonymous users and detect IDOR, cross-user access, and privilege escalation.

This skill detects Supabase usage in a web app by analyzing domain patterns, client libraries, and API endpoints to determine project presence.