Mysql

MySQL Core Knowledge

Deep Knowledge: Use mcp__documentation__fetch_docs with technology: mysql for comprehensive documentation.

Table Definition

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    is_active BOOLEAN DEFAULT TRUE,
    INDEX idx_email (email),
    INDEX idx_created (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Common Queries

-- Pagination
SELECT * FROM users
WHERE is_active = TRUE
ORDER BY created_at DESC
LIMIT 20 OFFSET 0;

-- Join
SELECT u.*, COUNT(p.id) as post_count
FROM users u
LEFT JOIN posts p ON p.user_id = u.id
GROUP BY u.id;

-- Upsert
INSERT INTO users (email, name)
VALUES (?, ?)
ON DUPLICATE KEY UPDATE name = VALUES(name);

Key Differences from PostgreSQL

When NOT to Use This Skill

• PostgreSQL-specific features - Use postgresql skill for JSONB, arrays, window functions
• NoSQL operations - Use mongodb or redis skills for document/key-value stores
• Oracle database - Use oracle skill for Oracle-specific features
• SQL Server - Use sqlserver skill for T-SQL and SQL Server features
• ORM abstractions - Use framework-specific skills (Prisma, TypeORM, Sequelize)

Anti-Patterns

Quick Troubleshooting

Reference Documentation

• Indexes
• JSON