Database
Database management and queries
backend-development
by tomaspozo
Supabase backend development workflow. Use for ANY backend work in Supabase projects — schema changes, API endpoints, database functions, RLS policies, edge functions, auth, storage, business logic, or data access. Activate whenever the task involves server-side logic, data layer, or Supabase features.
configuring-connection-pools
by djankies
Configure connection pool sizing for optimal performance. Use when configuring DATABASE_URL or deploying to production.
Zombie Codes — Persistent Memory for AI
by robertsellman-code
Memory importance is derived automatically from your answers to the memory_properties questions. You don't set it directly — the server computes it from your honest Q&A responses. Critical memories (failures, hard constraints) surface more readily. The system detects inflation — answering everything as critical actually reduces effective importance.
dhh-rails-style
by 8b-is
This skill should be used when writing Ruby and Rails code in DHH's distinctive 37signals style. It applies when writing Ruby code, Rails applications, creating models, controllers, or any Ruby file. Triggers on Ruby/Rails code generation, refactoring requests, code review, or when the user mentions DHH, 37signals, Basecamp, HEY, or Campfire style. Embodies REST purity, fat models, thin controllers, Current attributes, Hotwire patterns, and the "clarity over cleverness" philosophy.
creating-client-singletons
by djankies
Prevent multiple PrismaClient instances that exhaust connection pools causing P1017 errors. Use when creating PrismaClient, exporting database clients, setting up Prisma in new files, or encountering connection pool errors. Critical for serverless environments.
soria-stack
by Soria-Inc
Data pipeline skills for Soria Analytics. Cognitive modes for upstream pipeline work (scrape → extract → value-map → publish) and for building dives (dbt marts + manifest + React component + DivesPage registration + rows in the shared verifications seed + methodology wired into the component). All skills drive the Soria platform through the mcp__soria__* MCP tool namespace. SQL and React dives are authored locally in frontend/src/dives/ and shipped via git push + PR — there is no soria CLI. Soria skills: /tools (verify MCP + local stack), /env (preflight; no isolated envs), /status (what exists), /plan (ETVLR orchestrator), /ingest (scrape + extract + publish), /map (value mapping), /parent-map (centralized parent company resolution), /dive (build a dive end-to-end), /preview (render a dive in chat), /verify (prove data correct), /dashboard-review (adversarial browser QA against dev.soriaanalytics.com), /diagnose (failure triage), /ticket (file structured tickets mid-session), /promote (warehouse_diff + warehouse_promote + PR + CI), /newsroom (news pipeline ops), /lessons (retrospective), /browse (persistent headless Chromium for verification), plus engineering skills /dev-env, /dev-dives, /test, and /code-review for branch-local app work, dev HTTPS dive frontend repair, test evidence, and Soria-specific code review. Suggest the right skill by stage: starting a session → /tools; investigating what exists → /status; planning work → /plan; building a pipeline → /ingest; normalizing values → /map; resolving parent companies → /parent-map; building a dive or reviewing its SQL → /dive; proving data correct → /verify; testing live dive UI → /dashboard-review; something broke → /diagnose; filing a bug/feature ticket → /ticket; promoting to prod → /promote; news pipeline → /newsroom; reviewing recent work → /lessons.
bio-blast
by dakesan
"NCBI BLAST sequence similarity search using BioPython. Use when a user wants to run BLAST programmatically with blastn/blastp and retrieve results in JSON format."
plugin-creator
by ylt
Guide for creating Claude Code plugins. This skill should be used when the user wants to "create a plugin", "write a plugin", "build a plugin", "scaffold a plugin", "set up plugin structure", "configure plugin.json", "add commands to a plugin", "add agents to a plugin", "add hooks to a plugin", "add MCP server to a plugin", "add LSP to a plugin", "organize plugin components", or needs guidance on Claude Code plugin architecture, manifest configuration, or plugin distribution.
fastapi
by yldgio
FastAPI endpoint design, Pydantic validation, dependency injection, and async patterns
migrating-git-filter-repo
by squirrel289
Move one or more subdirectories or files from one Git repository to another with git filter-repo while preserving commit history, authorship, and timestamps. Use when asked to split monorepos, migrate multiple paths between repositories, import selected files/folders into a new or existing repository, or retire source paths after verified migration.
context7
by trancong12102
Retrieve up-to-date documentation for software libraries, frameworks, and components via the Context7 API. Use when looking up documentation for programming libraries or frameworks, finding code examples for specific APIs or features, verifying correct usage of library functions, or obtaining current information about library APIs that may have changed since training.
notion-db
by iemong
Notion APIを使ってデータベース/データソースから複数ページを取得するスキル。filter/sorts/start_cursorを指定して絞り込み取得できる。 使用タイミング: (1) Notion DBを条件付きで取得したい (2) 一括取得したい (3) APIベースで再利用可能な取得処理が必要 トリガーキーワード: Notion、データベース取得、Notion API、filter、query database
migration-breaking
by ShotaIuchi
Breaking change analysis for migrations. Apply when cataloging incompatible API changes, removed features, behavioral differences, deprecated usage, and version-specific breaking changes.
cqrs-implementation
by TriNgo0108
Implement Command Query Responsibility Segregation for scalable architectures. Use when separating read and write models, optimizing query performance, or building event-sourced systems.
sql-standards
by quanturetechnologies
Writes, reviews, and optimizes SQL queries following Quanture security and performance standards. Use when writing SQL queries, designing database schemas, creating migrations, optimizing slow queries, or reviewing database code.
idempiere-ai
by comitsrl
"Usar AI (Copilot/LLMs y agentes) en proyectos iDempiere para acelerar desarrollo y habilitar acceso conversacional a datos, con guardrails de seguridad, multi-tenant, observabilidad y control humano. Usar para POCs o disenos productivos de RAG y LLM a SQL."
fitness-finder
by Barneyjm
"Search for gyms, yoga studios, swimming pools, and sports facilities using Camino AI's location intelligence with AI-powered ranking."
svelte-5
by NikiSkaarup
Guide Svelte 5 development with runes and migration-aware practices.
ensuring-query-type-safety
by djankies
Use Prisma's generated types, Prisma.validator, and GetPayload for type-safe queries.
tuya-irrigation
by giocaizzi
Smart irrigation system for Tuya-based devices with sensor integration. Features: cluster management, plant profiles, sensor data logging, smart irrigation logic. Use when: managing irrigation, adding plants/sensors, analyzing conditions, auto-watering. Requires: TUYA_CLIENT_ID, TUYA_CLIENT_SECRET in ~/.openclaw/.env.
stack
by biruk741
Interactively select the complete technology stack for the hackathon project. Covers package manager, frontend framework, backend framework, database, ORM, styling, testing, and deployment. Considers agent-coding compatibility, documentation quality, and team familiarity. Use when the team needs to decide on technologies, when someone asks "what should we use for X", "what's the best framework for this", or "let's pick our stack". Also use mid-project if a technology choice needs to be reconsidered.
validation
by zap-studio
Use when validating data with Standard Schema-compatible schemas or handling ValidationError results.
graphql-api-design
by karchtho
GraphQL schema design, type systems, resolver patterns, DataLoader optimization, pagination, subscriptions, and query complexity management. Use when building GraphQL APIs, designing schemas, migrating from REST, or optimizing query performance.
Salesforce Observable Logging Skill
by ichwansh03
Created for the Salesforce Observable Logging Project.