SQL

Comprehensive FastAPI development skill covering REST API creation, routing, request/response handling, validation, authentication, database integration, middleware, and deployment. Use when working with FastAPI projects, building APIs, implementing CRUD operations, setting up authentication/authorization, integrating databases (SQL/NoSQL), adding middleware, handling WebSockets, or deploying FastAPI applications. Triggered by requests involving .py files with FastAPI code, API endpoint creation, Pydantic models, or FastAPI-specific features.

Write secure, performant database queries using parameterization, proper indexing, and optimization techniques. When creating or modifying database query logic, data access layers, or repository files. When working on files that interact with databases using SQL, ORMs, or query builders. When implementing SELECT queries, joins, transactions, or data fetching logic. When optimizing queries to prevent N+1 problems, using eager loading, or implementing query caching. When writing parameterized queries to prevent SQL injection vulnerabilities.

Make database schema changes in IdeaForge. Triggers: create migration, add table/column, modify column type, add index, use JSONB, use pgvector. File-based migrations with raw SQL, no ORM.

Build production agentic applications on OCI using Oracle Agent Development Kit with multi-agent orchestration, function tools, and enterprise patterns

Expert database design specialist that creates optimized schemas, writes efficient queries, handles migrations, and provides guidance on normalization, indexing, and performance optimization across SQL and NoSQL databases

Fast in-process analytical database for SQL queries on DataFrames, CSV, Parquet, JSON files, and more. Use when user wants to perform SQL analytics on data files or Python DataFrames (pandas, Polars), run complex aggregations, joins, or window functions, or query external data sources without loading into memory. Best for analytical workloads, OLAP queries, and data exploration.

Chat app that lets you ask questions in plain English and query your PostgreSQL database.

High-performance PostgreSQL patterns. Use when optimizing queries, designing for scale, or debugging performance issues.

Database optimization, security audit, and performance analysis for MyDetailArea Supabase/PostgreSQL. Provides safe query optimization, RLS policy review, index recommendations, and migration strategies with extreme caution and rollback plans. Use when optimizing database performance, auditing security, or creating safe migrations. CRITICAL - All recommendations require validation and testing before production.

Writes, edits, and creates dbt models following best practices. Use when user needs to create new dbt SQL models, update existing models, or convert raw SQL to dbt format. Handles staging, intermediate, and mart models with proper config blocks, CTEs, and documentation.

Sets up a new Django project with RAPID architecture using uv. Creates horizontal layer structure with DRF, Docker/PostgreSQL support, and environment-based configuration. Use when the user wants to initialise a Django web application.

Complete Java Spring Boot skill set for building enterprise applications.Includes modular architecture with optional components:- PostgreSQL database with JPA/Hibernate + Flyway migration- Redis caching (optional)- Kafka/RabbitMQ messaging (optional, choose one)- JWT + OAuth2 authentication (optional OAuth2)- RBAC authorization (optional)- TDD with Mockito- Spec-First Development with OpenSpec

Multi-tenant architecture patterns including org_id claim management, JWT token structure with organization context, database isolation strategies for MongoDB and PostgreSQL, theme switching per organization, tenant provisioning workflows, data isolation patterns, and cross-tenant security. Activate for multi-tenancy implementation, tenant isolation, and organization-scoped data access.

Expert in designing SQLModel schemas and managing Neon PostgreSQL databases. Use this when defining data models, handling relationships, or performing database migrations.

Zenless 프로젝트 개발 환경을 중지하는 스킬. 사용자가 "프로젝트 중지", "서버 중지", "개발 환경 종료" 등을 요청할 때 사용. 백그라운드에서 실행 중인 백엔드와 프론트엔드 프로세스를 종료하고, PostgreSQL 컨테이너를 중지함. (project)

Write efficient and secure database queries using parameterized statements, preventing SQL injection, and optimizing performance through proper indexing and eager loading. Use this skill when writing database queries, ORM query methods, SQL statements, or repository pattern implementations. Use this skill when optimizing query performance, preventing N+1 query problems, implementing transactions for data consistency, or adding query timeouts and caching strategies. Use this skill when working with SELECT statements, JOIN operations, WHERE clauses, or any code that interacts with the database to fetch or manipulate data. Use this skill when working with files in repositories/, queries/, services/, or data access layers that contain database query logic.

Implements Kysely type-safe SQL query builder with full TypeScript inference, migrations, and multi-database support. Use when building type-safe SQL queries, needing a lightweight ORM alternative, or wanting SQL control with TypeScript safety.

Orchestrates automated service-based website generation with local SEO optimization. Creates 200+ service+location pages using parallel agents, Unsplash images via Jina AI, NextJS with dynamic routing, and PostgreSQL database. Use when building service business websites (plumbers, electricians, pressure washing, HVAC, etc.) targeting multiple locations.

Guide for ORM-based data modeling with SQLModel. Use for defining database models, fields, constraints, relationships (1:N, N:M), inheritance, validators, and handling JSON fields and timestamps. Provides templates for User, Task, and Category models.

Optimize SQL queries, analyze indexes, review Alembic migrations, and identify N+1 problems. Provides query execution plans, index recommendations, and migration best practices for SQLAlchemy async.