database-operationsUse when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Install via ClawdBot CLI:
clawdbot install jgarrison929/database-operationsGrade Good — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated Mar 1, 2026
An online retailer experiencing slow product search and checkout processes needs to optimize PostgreSQL queries and implement full-text search. The specialist would analyze query performance using EXPLAIN ANALALYZE, create strategic indexes on product tables, and implement Redis caching for frequently accessed product data to improve user experience during peak shopping periods.
A software-as-a-service company needs to implement zero-downtime database migrations while adding new features. The specialist would design additive schema changes first, create rollback procedures for every migration, and implement audit logging to track data changes across user tables while maintaining service availability during deployment.
A financial institution's transaction processing system suffers from N+1 query problems and slow report generation. The specialist would identify inefficient joins, implement composite indexes on transaction tables, create materialized views for complex reports, and optimize connection pooling to handle high-volume financial data processing during business hours.
A healthcare provider needs to implement secure patient data management with audit trails and soft delete functionality. The specialist would design PostgreSQL schemas with proper constraints, implement audit logging triggers for compliance tracking, create partial indexes for active patient records, and ensure HIPAA-compliant data access patterns through optimized queries.
A media company's content management system struggles with slow user profile queries and inefficient full-text search. The specialist would implement table partitioning for user-generated content, create GIN indexes for text search, optimize user management schemas with strategic indexes, and implement caching strategies for frequently accessed user profiles and content metadata.
Companies hire database specialists on a project basis to optimize existing systems, implement migrations, or design new database architectures. Revenue comes from hourly consulting fees or fixed-price projects for specific database optimization tasks, with typical engagements ranging from query tuning to complete schema redesigns for performance-critical applications.
SaaS companies offer ongoing database performance monitoring and optimization as a subscription service. Revenue is generated through monthly or annual subscriptions that include regular query analysis, index optimization recommendations, and migration planning services, with tiered pricing based on database size and complexity.
Large organizations purchase comprehensive support contracts for critical database systems. Revenue comes from annual contracts that include 24/7 support, emergency optimization services, migration assistance, and regular performance audits for mission-critical PostgreSQL deployments in financial, healthcare, or e-commerce environments.
💬 Integration Tip
Integrate this skill by providing specific database schemas and query patterns when requesting optimizations. Include actual EXPLAIN ANALYZE output for slow queries to get targeted indexing and caching recommendations.
Scored Apr 19, 2026
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Typeform API integration with managed OAuth. Create forms, manage responses, and access insights. Use this skill when users want to interact with Typeform surveys and responses. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Airtable API integration with managed OAuth. Manage bases, tables, and records. Use this skill when users want to read, create, update, or delete Airtable records, or query data with filter formulas. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
Use SQLite correctly with proper concurrency, pragmas, and type handling.
JotForm API integration with managed OAuth. Create forms, manage submissions, and access form data. Use this skill when users want to interact with JotForm forms and submissions. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).