db-designDeep database design workflow—entities and relationships, keys and constraints, normalization vs denormalization, indexing strategy, integrity, and operation...
Install via ClawdBot CLI:
clawdbot install codekungfu/db-designGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated May 9, 2026
Designing a scalable database schema for a SaaS platform that isolates tenant data while supporting shared infrastructure. The workflow ensures tenant_id is used in keys and indexes, and migration strategies consider zero-downtime deployments.
Redesigning a product catalog database to handle high query volumes, with denormalization for frequently accessed product details. The workflow balances normalization for inventory management with indexing for search performance.
Creating a relational schema for patient records with strict integrity constraints, including foreign keys for appointments and prescriptions. The design addresses PII flagging and audit logging for regulatory compliance.
Designing an OLTP schema for a payment processing system with high write throughput and strong consistency. Focus on surrogate keys, unique constraints for transaction IDs, and indexing for real-time balance queries.
Provides recurring revenue through monthly or annual subscriptions. The database design supports multi-tenancy and usage tracking, enabling tiered pricing based on data volume or features.
Generates revenue by charging per transaction or operation. The schema must ensure high throughput and data integrity to minimize errors and support auditing for fee calculation.
Offers database management as a service, with the schema design focused on isolation, scalability, and operational excellence. Revenue comes from resource usage and premium features like backups and replication.
💬 Integration Tip
Pair with db-migrate tool for online schema changes and use the final review checklist to validate decisions before implementation.
Scored May 9, 2026
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use 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.
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.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
MarkItDown is a Python utility from Microsoft for converting various files (PDF, Word, Excel, PPTX, Images, Audio) to Markdown. Useful for extracting structu...
Write correct MySQL queries avoiding common pitfalls with character sets, indexes, and locking.