dialect-postgresql
OfficialMaster PostgreSQL syntax and debugging queries.
Authormako-ai
Version1.0.0
Installs0
System Documentation
What problem does it solve?
PostgreSQL and Cloud SQL users often struggle with dialect-specific syntax and edge cases when writing or debugging complex queries. This skill provides a concise guide to identifiers, casts, JSON operators, arrays, pattern matching, intervals, and LIMIT syntax to help craft correct SQL across PostgreSQL variants.
Core Features & Use Cases
- Syntax quick reference for common PostgreSQL features including identifiers, casts, string concatenation, date intervals, JSONB access, and array handling.
- Example-driven guidance showing typical query patterns and best practices for schema-qualified tables.
- Use Case: When migrating queries from other databases, or debugging correctness of complex expressions in PostgreSQL.
Quick Start
Provide PostgreSQL dialect-compliant SQL queries with correct identifiers, casts, JSON operators, arrays, and interval handling.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: dialect-postgresql Download link: https://github.com/mako-ai/mako/archive/main.zip#dialect-postgresql Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.