LogoClawIndex
CasesSkillsAbout
LogoClawIndex

postgres-patterns - PostgreSQL Database Patterns and Best Practices

Provides PostgreSQL database patterns for query optimization, schema design, indexing, and security based on Supabase best practices.

Tags

Updated: 2026-02-23
databasepostgresqlsqloptimizationsecurity

Capabilities

Write SQL queriesDesign database schemasTroubleshoot slow queriesImplement row-level security

Typical Inputs

PostgreSQL databaseSQL requirementsPerformance issues

Typical Outputs

SQL codeSchema design recommendationsIndex optimization suggestions

What this skill does

  • Write SQL queries
  • Design database schemas
  • Troubleshoot slow queries
  • Implement row-level security
  • Setup connection pools

Inputs

  • PostgreSQL database
  • SQL requirements
  • Performance issues
  • Security policies

Outputs

  • SQL code
  • Schema design recommendations
  • Index optimization suggestions
  • Security configuration templates

Requirements

  • PostgreSQL environment
  • Database access permissions
  • SQL knowledge

Source

  • Spec: SKILL.md

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.