Database
Database management and queries
vps
by kyzdes
Deploy and manage applications on VPS servers with Dokploy. Use when the user wants to: set up a new VPS server, deploy a project from GitHub, manage domains/DNS, create databases, check server status, view logs, or remove deployed projects. Also use when the user mentions re-deploying, checking deploy status, adding environment variables, or troubleshooting a deployed app. Triggers on: VPS, deploy, server setup, Dokploy, hosting, domain, DNS, redeploy, server status, deploy logs.
@tank/relational-db-mastery
by tankpkg
Relational database performance optimization for PostgreSQL and MySQL. Covers indexing strategies (B-tree, GIN, GiST, BRIN, partial, expression, covering, composite), query optimization (JOINs, CTEs, pagination, N+1), EXPLAIN ANALYZE interpretation, schema design for performance, PostgreSQL tuning (VACUUM, autovacuum, connection pooling, pg_stat_statements), MySQL/InnoDB tuning, and monitoring diagnostics. Synthesizes Winand (SQL Performance Explained), Petrov (Database Internals), Karwin (SQL Antipatterns), Schwartz (High Performance MySQL), Kleppmann (Designing Data-Intensive Applications), and PostgreSQL/MySQL documentation. Trigger phrases: "slow query", "query optimization", "database performance", "index", "indexing strategy", "EXPLAIN ANALYZE", "query plan", "schema design", "normalization", "denormalization", "B-tree", "GIN index", "composite index", "covering index", "partial index", "N+1 query", "pagination", "keyset pagination", "cursor pagination", "connection pool", "PgBouncer", "VACUUM", "autovacuum", "table bloat", "dead tuples", "cache hit ratio", "PostgreSQL tuning", "MySQL tuning", "InnoDB", "foreign key index", "missing index", "over-indexing", "database schema", "data types", "partitioning", "pg_stat_statements", "slow query log", "JOINs", "subquery vs CTE", "query rewriting", "database optimization", "SQL performance", "database design", "relational database"
@tank/notion
by tankpkg
"Query, create, and update Notion pages, databases, and blocks through the Notion API. Covers database CRUD with typed properties (select, relation, rollup, formula), compound filters, page content as block trees, search across workspaces, and pagination patterns. Triggers: notion, database, page, block, query, filter, property, relation, rollup, block tree, Notion API, workspace, toggle, callout, create page, update page."
ask-db-migration-assistant
by NavanithanS
Safe database schema updates with migration and rollback scripts.
Civitai Analyst
by feed-mob
Agent Skills from FeedMob Dev Team
ralph
by realRoc
"Convert PRDs to prd.json format for the Ralph autonomous agent system. Use when you have an existing PRD and need to convert it to Ralph's JSON format. Triggers on: convert this prd, turn this into ralph format, create prd.json from this, ralph json."
project-docs-setup
by zhucl1006
项目文档结构创建助手。作为资深产品经理，通过多轮对话深入了解项目需求，分析合理性并提供最佳实践建议，最终生成完整的技术文档体系。 使用时机： - 新项目启动，需要建立文档体系（推荐第一步） - 现有项目缺少规范文档，需要补充完善 - 已有代码但缺少文档，需要根据代码回补文档 - 需要专业的产品和架构分析建议 支持两种工作模式： - 模式 A：新项目文档创建（从需求到文档） - 模式 B：代码回补文档（从代码到文档） 与其他 skill 的关系： - 本 skill 负责创建完整文档（PRD、SAD、开发指南等） - project-workflow 负责基于文档执行开发任务 - 建议流程：project-docs-setup → project-workflow 触发方式： - "创建项目文档" / "初始化项目文档" / "设置项目文档" - "根据代码生成文档" / "回补项目文档" / "补充项目文档" - 直接描述项目需求，如"帮我创建一个在线教育平台的文档"
boring-stack
by boringstackoverflow
Bootstraps new web app projects with a tech stack you can understand. Runs a 4-question intake to pick a stack (Go binary + SQLite + Litestream + Caddy + systemd + a $5 VPS by default; Postgres / managed platforms when the project doesn't fit), writes STACK.md as the source-of-truth decision record plus a CLAUDE.md anchor, scaffolds new projects from scratch (init), generates production-ready deploy files from bundled templates, and walks an 8-step post-deploy verification (TLS / Litestream / restore drill). Loads when starting a new web app, scaffolding deploy infrastructure, picking a tech stack, or making bootstrap-time architecture decisions for a side project, indie product, internal tool, hobby project, or solo-founder context.
db-diagram
by manastalukdar
Generate database ER diagrams from schema for documentation
ask-laravel-architect
by NavanithanS
Laravel scaffolding for SQL or Mongo (Official/Jenssegers), SoftDeletes, API standards.
moai-baas-convex-ext
by AJBcoding
Enterprise Convex Real-Time Backend with AI-powered reactive database architecture, Context7 integration, and intelligent synchronization orchestration for collaborative applications
moai-alfred-ask-user-questions
by AJBcoding
Enterprise interactive survey orchestrator with AskUserQuestion tool integration, multi-select support, conditional branching, error recovery, and production-grade decision automation across all Alfred workflows; activates for requirement clarification, architectural decisions, risky operations, feature selection, and complex multi-step user interactions
moai-baas-neon-ext
by AJBcoding
Enterprise Neon Serverless PostgreSQL Platform with AI-powered database architecture, Context7 integration, and intelligent branching orchestration for scalable modern applications
api-contracts-and-zod-validation
by hopeoverture
Generate Zod schemas and TypeScript types for forms, API routes, and Server Actions with runtime validation. Use this skill when creating API contracts, validating request/response payloads, generating form schemas, adding input validation to Server Actions or route handlers, or ensuring type safety across client-server boundaries. Trigger terms include zod, schema, validation, API contract, form validation, type inference, runtime validation, parse, safeParse, input validation, request validation, Server Action validation.
api-design-principles
by QuestForTech-Investments
Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.
supabase-rls-policy-generator
by hopeoverture
This skill should be used when the user requests to generate, create, or add Row-Level Security (RLS) policies for Supabase databases in multi-tenant or role-based applications. It generates comprehensive RLS policies using auth.uid(), auth.jwt() claims, and role-based access patterns. Trigger terms include RLS, row level security, supabase security, generate policies, auth policies, multi-tenant security, role-based access, database security policies, supabase permissions, tenant isolation.
moai-baas-firebase-ext
by AJBcoding
Enterprise Firebase Platform with AI-powered Google Cloud integration, Context7 integration, and intelligent Firebase orchestration for scalable mobile and web applications
plugin-creator
by otrebu
Create Claude Code plugins with proper structure. Use when user requests "create a plugin" or needs to scaffold a new plugin with metadata, directories, and marketplace registration.
mcp-server-developer
by hummbl-dev
Model Context Protocol (MCP) server implementation specialist for Claude Desktop integration. Handles TypeScript/Node.js server scaffolding, endpoint creation, telemetry setup, npx distribution, and comprehensive documentation. Follows MCP specification and best practices for production-grade server deployment.
multi-cloud-architecture
by QuestForTech-Investments
Design multi-cloud architectures using a decision framework to select and integrate services across AWS, Azure, and GCP. Use when building multi-cloud systems, avoiding vendor lock-in, or leveraging best-of-breed services from multiple providers.
supabase-prisma-database-management
by hopeoverture
This skill should be used when managing database schema, migrations, and seed data using Prisma ORM with Supabase PostgreSQL. Apply when setting up Prisma with Supabase, creating migrations, seeding data, configuring shadow database for migration preview, adding schema validation to CI, or managing database changes across environments.
sql-expert
by QuestForTech-Investments
"Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. Use when working with databases for: (1) Writing complex SQL queries with joins, subqueries, and window functions, (2) Optimizing slow queries and analyzing execution plans, (3) Designing database schemas with proper normalization, (4) Creating indexes and improving query performance, (5) Writing migrations and handling schema changes, (6) Debugging SQL errors and query issues"
moai-alfred-clone-pattern
by AJBcoding
Enterprise Master-Clone pattern implementation guide for complex multi-step tasks with full project context, autonomous delegation, parallel processing, and intelligent task distribution; activates for large-scale migrations, complex refactoring, parallel exploration, architecture restructuring, and multi-file transformations
sqldown
by mbailey
Bidirectional markdown ↔ SQLite conversion with column limit protection and smart section extraction. Import with Python, query with sqlite3.