Skill UI

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 provides comprehensive performance optimization and best practices for PostgreSQL, maintained by Supabase. It guides users on optimizing database performance, covering critical areas such as writing efficient SQL queries, designing robust schemas, implementing proper indexing, managing connection pooling, and enforcing Row-Level Security (RLS).

Conduct rigorous, multi-database literature reviews with systematic workflows, verified citations in styles like APA or Nature, and AI-enhanced schematics for publication-ready markdown and PDF outputs in biomedical and technical domains.

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.

Generates a production-ready SaaS boilerplate with authentication, database schema, billing integration, API routes, and a dashboard built with Next.js 14 App Router, TypeScript, Tailwind, shadcn/ui, Drizzle ORM, and Stripe—ideal for bootstrapping new subscription-based products.

This comprehensive guide facilitates the development of a production-ready Minimum Viable Product (MVP) for a SaaS business. It covers the entire lifecycle, including idea validation, modern tech stack selection (Next.js, Supabase, Stripe), architectural design for multi-tenancy, database schema planning, authentication setup, payment integration, and a detailed pre-launch checklist for technical and marketing readiness.

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 comprehensive strategy for regression testing in AI-assisted development. It focuses on identifying systematic blind spots, such as schema inconsistencies between sandbox and production paths, and integrating automated bug checks into the development workflow. This guide teaches how to build robust, database-free API tests to ensure code quality when AI models contribute to the codebase.

This skill provides a comprehensive framework for building an automated Service Level Agreement (SLA) breach alerting system for vulnerability remediation. It covers defining severity-based SLA policies (Critical, High, Medium, Low), structuring a database schema for tracking, implementing breach detection logic, and dispatching multi-channel escalation notifications (Email, Slack, PagerDuty). Essential for achieving compliance and improving overall security posture.

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.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.