heyayushh/db
configs/stacks/databases/SKILL.md
Database (PostgreSQL) SQL best practices for clean, performant, and maintainable queries. Use when writing or reviewing SQL, schema changes, or database-related guidance.
$ install --global
skillsauthnpx skillsauth add heyayushh/stacc dbInstall 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: May 13, 2026, 2:30 AM246.5s2 files scanned
SKILL.md
- name:
- db
- description:
- Database (PostgreSQL) SQL best practices for clean, performant, and maintainable queries. Use when writing or reviewing SQL, schema changes, or database-related guidance.
Database Stack Skill
Default guidance
Use the PostgreSQL rule file in this folder as the authoritative reference.
Workflow (use this order)
- Confirm schema context and target tables/columns.
- Draft query with explicit columns and clear aliases.
- Prefer CTEs for readability and reuse.
- Avoid
NOT IN; useNOT EXISTSorLEFT JOIN ... IS NULL. - Run
explain analyzeand address sequential scans. - 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 INavoided withNULL-safe alternatives.- Query plan checked with
explain analyze.
Local Resources
postgresql.mdcfor naming, formatting, query patterns, and performance guidance.
Related Skills
heyayushh/frontend-design
development
VerifiedTrustedCommunity
Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, artifacts, posters, or applications (examples include websites, landing pages, dashboards, React components, HTML/CSS layouts, or when styling/beautifying any web UI). Generates creative, polished code and UI design that avoids generic AI aesthetics.
2SKILL.mdUpdated May 13, 2026
heyayushh/swiftui-view-refactor
development
VerifiedTrustedCommunity
Refactor and review SwiftUI view files for consistent structure, dependency injection, and Observation usage. Use when asked to clean up a SwiftUI view’s layout/ordering, handle view models safely (non-optional when possible), or standardize how dependencies and @Observable state are initialized and passed.
2SKILL.mdUpdated May 13, 2026
heyayushh/swiftui-ui-patterns
development
VerifiedTrustedCommunity
Best practices and example-driven guidance for building SwiftUI views and components. Use when creating or refactoring SwiftUI UI, designing tab architecture with TabView, composing screens, or needing component-specific patterns and examples.
2SKILL.mdUpdated May 13, 2026
heyayushh/swiftui-performance-audit
development
VerifiedTrustedCommunity
Audit and improve SwiftUI runtime performance from code review and architecture. Use for requests to diagnose slow rendering, janky scrolling, high CPU/memory usage, excessive view updates, or layout thrash in SwiftUI apps, and to provide guidance for user-run Instruments profiling when code review alone is insufficient.
2SKILL.mdUpdated May 13, 2026