Skills
.Work. You
Rest

postgres-core-api-surface

Official

Master PostgreSQL's SQL surface with precision.

Software Engineering#database#sql#postgres#upsert#transaction control#sql surface
AuthorImpertio-Studio
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides deterministic guidance for navigating PostgreSQL's SQL surface, ensuring accurate schema design, indexing, and query execution.

Core Features & Use Cases

  • SQL Surface Navigation: Efficiently choose between pg_catalog and information_schema for database introspection.
  • Upsert Patterns: Correctly apply INSERT ... ON CONFLICT and MERGE for upsert operations.
  • Transaction Control: Utilize SAVEPOINT for nested transactions and manage isolation levels.
  • psql Meta-commands: Translate psql meta-commands into equivalent SQL queries.
  • Use Case: When writing a complex SQL script, this Skill helps you correctly identify the system catalogs to use, apply upsert patterns for efficient data insertion, and manage transactions to maintain data integrity.

Quick Start

Run the postgres-core-api-surface skill to get insights into PostgreSQL's SQL surface and upsert patterns.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 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: postgres-core-api-surface
Download link: https://github.com/Impertio-Studio/PostgreSQL-Claude-Skill-Package/archive/main.zip#postgres-core-api-surface

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.