FRmicrow/database
.agents/skills/database/SKILL.md
PostgreSQL schema management and optimized queries. Use when creating or modifying migrations, schemas, or complex SQL queries.
data-ai
Updated Apr 16, 2026
$ install --global
skillsauthnpx skillsauth add FRmicrow/dataFootV1 databaseInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 2:00 AM4.4s1 file scanned
SKILL.md
- name:
- database
- description:
- PostgreSQL schema management and optimized queries. Use when creating or modifying migrations, schemas, or complex SQL queries.
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.
Best Practices
- Indexing: Create indexes for columns frequently used in
WHERE,JOIN, orORDER BYclauses. - Normalization: Aim for 3NF (Third Normal Form) to avoid data redundancy.
- Query Optimization: Use
EXPLAIN ANALYZEto identify and fix slow queries. - Data Integrity: Use proper constraints (FOREIGN KEY, NOT NULL, UNIQUE, CHECK).
Integration
- Works with the
backendskill to provide data persistence. - Supports the
data-analyzerskill by providing a robust data storage layer. - Works with the
performanceskill to ensure optimal query execution times.
Related Skills
FRmicrow/unit-testing-node
development
VerifiedTrustedCommunity
Écrire des tests unitaires Node.js. Utiliser quand on teste une fonction isolée avec Vitest dans backend/test/.
SKILL.mdUpdated Apr 16, 2026
FRmicrow/integration-testing
testing
VerifiedTrustedCommunity
Tester l'intégration entre services. Utiliser quand on vérifie l'interaction contrôleur/service avec Supertest + Vitest.
SKILL.mdUpdated Apr 16, 2026
FRmicrow/frontend-testing-react
development
VerifiedTrustedCommunity
Tester les composants React avec Vitest + Testing Library. Utiliser quand on teste le rendu ou les interactions.
SKILL.mdUpdated Apr 16, 2026
FRmicrow/e2e-testing-playwright
testing
VerifiedTrustedCommunity
Écrire des tests end-to-end Playwright. Utiliser quand on teste l'application complète du point de vue utilisateur.
SKILL.mdUpdated Apr 16, 2026