Menu
PostgreSQL database configuration and best practices
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Basé sur la classification professionnelle SOC
Multi-provider LLM integration for phrase generation (Groq, OpenAI, Gemini, extensible)
Cycle ORM patterns, configuration and common pitfalls for Symfony integration
Docker with multi-stage builds, security best practices and Docker Compose
Symfony framework with PestPHP testing and Clean Architecture patterns
WCAG 2.2 AA compliance for SAAC applications
Symfony with Pest PHP testing framework and TDD patterns
| name | postgresql |
| description | PostgreSQL database configuration and best practices |
| license | MIT |
| compatibility | opencode |
| metadata | {"type":"database","engine":"postgresql"} |
cycle-orm)# config/packages/doctrine.yaml (Symfony)
doctrine:
dbal:
url: '%env(resolve:DATABASE_URL)%'
options:
# SSL/TLS para conexiones seguras
1009: '%env(resolve:DATABASE_SSL_CA)%'
-- migrations/V001__initial_schema.sql
CREATE TABLE categories (
id UUID PRIMARY KEY,
name VARCHAR(50) NOT NULL,
icon VARCHAR(50),
color_hex VARCHAR(7) NOT NULL DEFAULT '#6B7280',
display_order INT NOT NULL DEFAULT 0,
CONSTRAINT uq_categories_name UNIQUE (name)
);
CREATE INDEX idx_categories_display_order ON categories(display_order);
Nota: Este proyecto usa Cycle ORM, no Doctrine. Ver skill
cycle-ormpara patrones de mapeo.