·postgresql
</>

postgresql

PostgreSQL 16+ reference for writing queries, designing schemas, managing indexes, and optimizing performance. Use when: (1) writing SQL queries (SELECT, INSERT, UPDATE, DELETE, CTEs, window functions, subqueries), (2) designing or altering table schemas (CREATE TABLE, constraints, sequences, data types), (3) choosing or creating indexes (B-tree, GIN, GiST, BRIN, partial, expression), (4) managing transactions and isolation levels (BEGIN/COMMIT, savepoints, MVCC), (5) working with JSONB data and jsonpath, (6) analyzing query performance with EXPLAIN ANALYZE, or (7) using the psql CLI.

13Installs·0Trend·@jgamaraalv

Installation

$npx skills add https://github.com/jgamaraalv/ts-dev-kit --skill postgresql

How to Install postgresql

Quickly install postgresql AI skill to your development environment via command line

  1. Open Terminal: Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.)
  2. Run Installation Command: Copy and run this command: npx skills add https://github.com/jgamaraalv/ts-dev-kit --skill postgresql
  3. Verify Installation: Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Source: jgamaraalv/ts-dev-kit.

SKILL.md

View raw

Version: 16+. All syntax is standard; most features apply to PostgreSQL 13+.

Load the relevant file when working on a specific topic:

| SELECT, JOINs, CTEs, window functions | references/queries.md | Writing or debugging any query | | CREATE TABLE, ALTER TABLE, constraints | references/ddl-schema.md | Designing or modifying schemas | | Index types, creation, strategy | references/indexes.md | Adding indexes or fixing slow queries |

PostgreSQL 16+ reference for writing queries, designing schemas, managing indexes, and optimizing performance. Use when: (1) writing SQL queries (SELECT, INSERT, UPDATE, DELETE, CTEs, window functions, subqueries), (2) designing or altering table schemas (CREATE TABLE, constraints, sequences, data types), (3) choosing or creating indexes (B-tree, GIN, GiST, BRIN, partial, expression), (4) managing transactions and isolation levels (BEGIN/COMMIT, savepoints, MVCC), (5) working with JSONB data and jsonpath, (6) analyzing query performance with EXPLAIN ANALYZE, or (7) using the psql CLI. Source: jgamaraalv/ts-dev-kit.

Facts (cite-ready)

Stable fields and commands for AI/search citations.

Install command
npx skills add https://github.com/jgamaraalv/ts-dev-kit --skill postgresql
Category
</>Dev Tools
Verified
First Seen
2026-02-24
Updated
2026-03-10

Browse more skills from jgamaraalv/ts-dev-kit

Quick answers

What is postgresql?

PostgreSQL 16+ reference for writing queries, designing schemas, managing indexes, and optimizing performance. Use when: (1) writing SQL queries (SELECT, INSERT, UPDATE, DELETE, CTEs, window functions, subqueries), (2) designing or altering table schemas (CREATE TABLE, constraints, sequences, data types), (3) choosing or creating indexes (B-tree, GIN, GiST, BRIN, partial, expression), (4) managing transactions and isolation levels (BEGIN/COMMIT, savepoints, MVCC), (5) working with JSONB data and jsonpath, (6) analyzing query performance with EXPLAIN ANALYZE, or (7) using the psql CLI. Source: jgamaraalv/ts-dev-kit.

How do I install postgresql?

Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/jgamaraalv/ts-dev-kit --skill postgresql Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Where is the source repository?

https://github.com/jgamaraalv/ts-dev-kit