Skill UI

This comprehensive guide details the complete workflow for setting up and maintaining a local Supabase development environment. It utilizes Docker and the Supabase CLI to run the entire full-stack service (Postgres, Auth, Storage, etc.) locally. It guides developers through initialization, creating version-controlled migrations using diff, seeding data, and performing clean database resets, ensuring local iteration accurately mirrors production capabilities.

This comprehensive deep dive guides you through the entire database migration lifecycle using the Supabase CLI. Learn best practices for executing zero-downtime schema changes, safely backfilling data in production, managing schema versioning across environments, and implementing robust rollback strategies. Covers advanced PostgreSQL concepts like concurrent indexing and multi-phase column renaming.

This skill guides the setup of a robust, multi-environment architecture for Supabase, ensuring complete data isolation between development, staging, and production projects. It covers best practices for managing separate environment-specific secrets, safe database migration promotion (db push), environment-aware client initialization, and implementing safeguards to prevent accidental cross-environment operations in production. Essential for scaling SaaS applications.

This powerful tool helps translate natural language requirements into robust, normalized relational database schemas. It can generate comprehensive schema designs, complete with relationships, constraints, and advanced architectural concerns like multi-tenancy, soft deletes, and audit trails. Furthermore, it automates the generation of database migrations (supporting Prisma, TypeORM, Alembic, etc.), corresponding type definitions (TypeScript/Python), seed data, and Entity-Relationship Diagrams (ERD) using Mermaid.

This expert assists developers in building type-safe, high-performance database layers using Drizzle ORM with TypeScript. It provides deep knowledge of schema design, complex relational querying (joins, aggregations), managing migrations via Drizzle Kit, and seamless integration with modern stacks like Next.js, tRPC, and serverless environments. Ideal for developers needing a zero-overhead, type-safe ORM alternative.

A comprehensive guide to building robust database layers in Kotlin using the Exposed ORM framework. It covers advanced patterns including DSL queries, DAO entity management, transaction handling, connection pooling with HikariCP, schema migration via Flyway, and implementing the Repository pattern for clean, production-grade data access.

A powerful operational companion for database developers. This skill assists with the daily lifecycle of database interactions, including translating natural language requirements into optimized SQL queries, generating database migrations, performing comprehensive schema introspection across multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), and identifying performance bottlenecks through detailed query optimization and index recommendations. It also supports ORM patterns like Prisma and SQLAlchemy.

Provides a structured process for deprecating legacy systems, APIs, and features, and migrating consumers to replacements. Useful for sunsetting code, removing dead code, performing expand/contract database migrations without downtime, and deciding whether to maintain or retire existing software. Covers migration patterns, timelines, and best practices.

Generates integration test cases for .NET data access artifacts targeting Oracle as the authoritative baseline. Tests are portable and later migrated to PostgreSQL in Phase 6. Use only in Phase 3 before migration work begins, not during Phase 6 or against already-migrated projects.

This comprehensive guide provides best practices for developing robust and efficient data access layers using Entity Framework Core. It covers critical areas including DbContext design, performance optimization (e.g., AsNoTracking, Select projection), secure querying techniques, migration strategies, and testing methodologies, ensuring the creation of scalable and maintainable applications.

Creates structured bug reports for defects found during Oracle-to-PostgreSQL database migration, covering severity, root cause, reproduction steps, and remediation. Useful for documenting behavioral differences and validating fixes.

Bulk migrate repo labels and Project V2 metadata into GitHub org issue fields, converting label-based tags into typed fields, optionally removing old labels, and syncing project field values for cleaner structured issue tracking.