Skill UI

Automate the entire Supabase development lifecycle within CI/CD pipelines using GitHub Actions. This tool links projects, validates database migrations, deploys Edge Functions, generates TypeScript types, and runs comprehensive tests against local Supabase instances. Essential for maintaining robust code quality and ensuring schema consistency before deployment.

This comprehensive skill guides the full lifecycle management of Supabase projects in a production environment. It covers essential DevOps practices, including running database migrations, deploying Edge Functions, managing secrets, implementing zero-downtime blue/green rollouts, and executing robust rollback procedures and post-deployment health checks. Ideal for ensuring stable and reliable production deployments.

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.

Automates the generation of robust, DB-agnostic integration test cases for data access layers (DAL) during major database migrations, specifically from Oracle to PostgreSQL. These tests validate behavioral consistency across both source and target database systems, ensuring that core business logic remains intact after the migration process. Essential for maintaining data integrity and application stability.

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.

A comprehensive guide and checklist for identifying potential risks when migrating database applications from Oracle to PostgreSQL. It systematically cross-references code and migration artifacts against known behavioral differences, covering issues such as empty string handling, refcursors, type coercion, sorting logic, and timestamp semantics. Use this tool during the planning phase to proactively mitigate risks, or during validation to ensure comprehensive integration test coverage for the new PostgreSQL environment.