Menu
PostgreSQL — advanced SQL, indexing, extensions, partitioning, EXPLAIN ANALYZE.
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/skeletorflet/opencode-supreme-setup --skill postgresqlThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Hyperframes-based video template for retro pixel deck motion design. Use when users want a high-fidelity, multi-scene HTML-to-video composition with advanced transitions, interactive preview controls, and ready-to-render default style.
Generate and iterate ad creative including headlines, descriptions, and primary text. Useful for paid social and search ad iteration.
Browser automation CLI for AI agents. Use when the user needs to inspect, test, or automate browser behavior: navigating pages, filling forms, clicking buttons, taking screenshots, extracting page data, testing web apps, dogfooding Open Design previews, QA, bug hunts, or reviewing app quality. Prefer local Open Design preview URLs unless the user explicitly asks for external browsing.
Based on SOC occupation classification
Showing SKILL.md
| name | postgresql |
| description | PostgreSQL — advanced SQL, indexing, extensions, partitioning, EXPLAIN ANALYZE. |
WITH cte AS (SELECT ...) SELECT * FROM cte for readable queries.ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC).WITH RECURSIVE for tree/graph traversal queries.LATERAL subqueries, GROUPING SETS, FILTER clause for conditional aggregates.CREATE INDEX active_users ON users(created_at) WHERE status = 'active'.INCLUDE (col1, col2) for index-only scans.ST_Distance, ST_Within, ST_AsGeoJSON.CREATE INDEX ON items USING ivfflat (embedding vector_cosine_ops) for ANN.uuid-ossp, pg_trgm, citext, hstore for common utilities.PARTITION BY RANGE (created_at).EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) for execution plan analysis.\dt, \d table, \l, \di, \x auto for expanded display.