Database skills

This skill helps you implement robust Python database patterns with SQLAlchemy 2.0, AsyncIO support, and repository patterns for reliable data access.

This skill helps you write type-safe Drizzle ORM queries in TypeScript for select, insert, update, delete, and relational data.

This skill enables end-to-end type safety using Zod, tRPC, Prisma, and TypeScript 5.7+ to validate data and APIs across full stack.

This skill designs robust, scalable data pipelines (batch or streaming) with quality checks, lineage, and idempotent recovery.

This skill helps you build and manage a full-stack AI chat app with persistence, chat list features, and automatic title generation.

This skill helps you connect a Next.js app to Neon Postgres using Drizzle ORM with optimized serverless pooling for Vercel.

This skill helps you provision isolated Neon test branches with schema-only structure, auto-cleanup TTL, and environment orchestration for safe testing.

This skill designs robust database schemas, generates safe migrations, and documents ER diagrams to ensure data integrity and scalable queries.

This skill automates Stripe subscriptions syncing with Postgres via webhooks, Vercel flags for plan configuration, and billing portal integration.

This skill helps you write and optimize SQL queries using common patterns, CTEs, and window functions for faster data retrieval.

This skill helps persist AI chat conversations in Neon Postgres, including AI SDK message parts, tools, reasoning, and streaming for reliable history.

This skill helps you implement a complete Stripe subscriptions workflow with webhooks, plan gating via feature flags, and a billing portal for seamless billing.

This skill generates production-ready unit tests for Frappe DocTypes, controllers, and APIs to accelerate test coverage and reliability.

This skill helps you configure mirrord.json for safe database branching, generating valid configs and explaining copy modes, IAM auth, and branch management.

This skill analyzes application performance, identifies bottlenecks, and guides concrete optimizations to reduce latency and boost throughput.

This skill reproduces GitHub ticket issues locally by automatically substituting production URLs, syncing databases, and validating fixes before proposing

This skill helps you generate Magento 2 admin backend controller actions with ACL, routing, and UI integration for admin pages and AJAX endpoints.

This skill generates optimized queries, caching, and indexes to boost Frappe performance and eliminate slow queries.

This skill generates complete Frappe DocType JSON with fields, permissions, and configurations to accelerate DocType creation and modification.

This skill helps you design scalable backends and APIs, optimize performance, and reason about microservices and database architecture.

This skill helps you design secure Supabase SSR, enforce RLS, and optimize real-time Next.js 16.1+ apps with revocable keys.