postgresql-json

📁 pluginagentmarketplace/custom-plugin-postgresql 📅 3 days ago

总安装量

周安装量

#44701

全站排名

安装命令

npx skills add https://github.com/pluginagentmarketplace/custom-plugin-postgresql --skill postgresql-json

Agent 安装分布

amp 1

opencode 1

kimi-cli 1

github-copilot 1

claude-code 1

Skill 文档

PostgreSQL JSON Skill

Atomic skill for JSONB operations

Overview

Production-ready patterns for JSONB queries, indexing, and transformations.

Prerequisites

PostgreSQL 16+
Understanding of JSON structure

Parameters

parameters:
  operation:
    type: string
    required: true
    enum: [query, index, transform, aggregate]
  json_path:
    type: string

Quick Reference

JSONB Operators

Operator	Description	Example
`->`	Get object	`data->'user'`
`->>`	Get as text	`data->>'name'`
`@>`	Contains	`data @> '{"active":true}'`
`?`	Key exists	`data ? 'email'`

Index Patterns

CREATE INDEX idx_data ON t USING GIN(data);  -- Containment
CREATE INDEX idx_data_path ON t USING GIN(data jsonb_path_ops);  -- Faster @>
CREATE INDEX idx_status ON t ((data->>'status'));  -- Specific key

Common Operations

-- Nested update
UPDATE docs SET data = jsonb_set(data, '{user,verified}', 'true');

-- Array append
UPDATE docs SET data = jsonb_set(data, '{tags}', (data->'tags') || '"new"');

-- Aggregate
SELECT jsonb_agg(jsonb_build_object('id', id, 'name', name)) FROM users;

Troubleshooting

Error	Cause	Solution
`22P02`	Invalid JSON	Validate syntax
Slow @>	No GIN index	Create GIN index
NULL path	Key missing	Check with ?

Usage

Skill("postgresql-json")

GitHub 仓库 ↗ ← 返回陌讯 Skills 聚合平台