mysql8-crm-schema-expertMySQL 8 database schema design for CRM systems. Use this skill whenever the user needs to design, review, optimize, or generate database schemas for Customer...
Install via ClawdBot CLI:
clawdbot install encryptshawn/mysql8-crm-schema-expertGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
https://...Audited Apr 18, 2026 · audit v1.0
Generated Oct 2, 2026
A technical founder needs a production-ready MySQL 8 schema for their early-stage SaaS CRM covering accounts, contacts, leads, and opportunities. They need guidance on entity relationships, indexing strategy, and a migration path for evolving custom fields.
A data engineer inherits a legacy CRM database with poor normalization, missing foreign keys, and slow queries. The skill is used to audit the schema against 3NF principles, add proper indexes, and redesign soft delete and audit trail patterns.
A development team needs a multi-tenant CRM schema to manage property buyers, sellers, showings, and deal pipelines across multiple branch offices. The design must enforce tenant isolation and support configurable custom fields per agency.
A financial services company requires a CRM schema with robust audit logging, soft deletes, and change tracking to meet regulatory compliance. The skill guides polymorphic activity feeds and immutable audit tables.
A healthcare platform needs to extend its CRM with user-defined fields for patient intake and sync with external EHR systems. The skill is applied to implement an EAV/JSON hybrid pattern and external_id columns for integrations.
The CRM is delivered as a cloud-hosted subscription service, with tenants paying monthly or annually based on user seats, storage, or feature tiers. The schema supports multi-tenancy and custom fields to serve diverse customer needs.
A software vendor sells perpetual or annual licenses of an on-premise or private-cloud CRM to large enterprises, with additional revenue from bespoke schema customization, integrations, and support contracts.
An open-source CRM schema and core application are offered freely, while the company monetizes through managed hosting, automated backups, schema migration tooling, and premium support plans.
💬 Integration Tip
Leverage the skill's reference files for each module and always apply the standard table template with BIGINT UNSIGNED keys, utf8mb4, and audit columns to ensure consistency across all CRM entities. For external system sync, include external_id and external_source columns as advised in the core design principles.
Scored Oct 2, 2026
Database Designer - POWERFUL Tier Skill
Skill Oracle — Curated documentation of quality ClawHub skills. Markdown tables telling agents which tools work and which are empty. Not an API or code library.
Database Schema Designer
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Data engineering skill for building scalable data pipelines, ETL/ELT systems, and data infrastructure. Expertise in Python, SQL, Spark, Airflow, dbt, Kafka,...
Verify claims, statements, and information against reliable sources. Use when user asks to fact-check, verify, confirm, validate, or check the accuracy of an...