Database

Database Skill

This skill provides expertise in managing the PostgreSQL database for the statFootV3 project.

When to use

Use this skill for any database-related tasks, including:

• Designing and implementing database schemas.
• Writing and running migration scripts.
• Optimizing complex SQL queries.
• Managing indexing strategies for performance.
• Ensuring data normalization and integrity.

Hard Rules (CRITICAL)

• Security: Never hardcode credentials. Use process.env.DATABASE_URL.
• Safety: Use parameterized queries only (db.all(sql, [params])). Never use string interpolation for SQL.
• Consistency: Follow the database schema design in backend/scripts/v3/migrate.js.
• Migrations: Always create a migration script for schema changes.