Skip to content
cccskills
FreePublished on GitHub

db

Database (PostgreSQL) SQL best practices for clean, performant, and maintainable queries. Use when writing or reviewing SQL, schema changes, or database-related guidance.

The English summary is being prepared. Showing the original description.

Works withPostgreSQL
See how to install

Files included (2)

  • SKILL.md1.0 KB
  • postgresql.mdc8.9 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Database Stack Skill

Default guidance

Use the PostgreSQL rule file in this folder as the authoritative reference.

Workflow (use this order)

  1. Confirm schema context and target tables/columns.
  2. Draft query with explicit columns and clear aliases.
  3. Prefer CTEs for readability and reuse.
  4. Avoid NOT IN; use NOT EXISTS or LEFT JOIN ... IS NULL.
  5. Run explain analyze and address sequential scans.
  6. Add or adjust indexes if query plan needs them.

Review Checklist

  • Naming uses snake_case; SQL keywords are lowercase.
  • Explicit joins used; no implicit joins.
  • select * avoided; columns are explicit.
  • NOT IN avoided with NULL-safe alternatives.
  • Query plan checked with explain analyze.

Local Resources

  • postgresql.mdc for naming, formatting, query patterns, and performance guidance.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Add an iOS App Clip target to an Expo app. Use when the user mentions App Clip, AASA, apple-app-site-association, appclips, smart app banner, or wants to ship a lightweight iOS Clip invoked from a URL alongside their parent app.

The English summary is being prepared. Showing the original description.

heyAyushh/stacc3Updated Sep 21, 2026

Automates browser interactions for web testing, form filling, screenshots, and data extraction. Use when the user needs to navigate websites, interact with web pages, fill forms, take screenshots, test web applications, or extract information from web pages.

The English summary is being prepared. Showing the original description.

heyAyushh/stacc3Updated Sep 21, 2026

Add Agentation visual feedback toolbar to a Next.js project

The English summary is being prepared. Showing the original description.

heyAyushh/stacc3Updated Sep 21, 2026

Apple's approach to interface design and fluid, physical motion, translated for the web. Use when building or reviewing gesture-driven UI, spring animations, drag/swipe/sheet interactions, momentum and interruptible transitions, translucent materials and depth, typography (optical sizing, tracking, leading), reduced-motion, or the design foundations (feedback, spatial consistency, restraint) behind Apple-style interfaces.

The English summary is being prepared. Showing the original description.

heyAyushh/stacc3Updated Sep 21, 2026

Derive and implement first-principles audio-coupled haptic and kinetic UI feedback. Use when designing, reviewing, or coding haptics/audio for mobile apps, native iOS/Android, React Native/Expo, SwiftUI, games, detent pickers, toggles, sliders, page curls, scroll gestures, wallet/signature flows, Solana transactions, backend/realtime state changes, confirmations, settlements, and semantic UI events where feedback should follow signal math instead of ad hoc vibration calls.

The English summary is being prepared. Showing the original description.

heyAyushh/stacc3Updated Sep 21, 2026

Babysit a GitHub pull request during a user-approved monitoring window by polling review comments, CI checks/workflow runs, and mergeability state. Diagnose failures, retry likely flaky failures up to 3 times, auto-fix/push branch-related issues when appropriate, and report fresh review feedback. Use when the user asks Codex to monitor a PR, watch CI, handle review comments, or keep an eye on failures and feedback on an open PR.

The English summary is being prepared. Showing the original description.

heyAyushh/stacc3Updated Sep 21, 2026

See all skills by heyAyushh

Report a problem with this skill