Agent Plugins Marketplace
← All plugins

postgres-sql

v1.0.0+codex.b2021964a7df

The PostgreSQL SQL dialect & data types that set Postgres apart from generic SQL. Use when writing or debugging Postgres-specific SQL — upsert (`ON CONFLICT`), `RETURNING`, `MERGE`, CTEs, window frames, `GROUPING SETS`, `LATERAL`, generated/identity columns, partitioning, `jsonb`/jsonpath/SQL-JSON (`JSON_TABLE`), arrays, ranges, composite/enum/domain types, `uuidv7()`. Includes `(pgNN+)` annotations. Dialect & types — client -> psql, tuning -> postgres-performance, config -> postgres-admin.

Codex1 Skill

By Alberto LealLicense: MIT22 GitHub starsUpdated 1 hour ago

Directory evidence

Runtimes
Codex
Parsed components
1 skill or MCP entry
Source updated
Aug 28, 2026
Manifest status
Canonical path parsed

The directory validates manifest shape and source location. It does not execute the plugin or provide a security endorsement. Review the indexing methodology →

Install plugin

Installs for the current user
codex plugin marketplace add IchenDEV/agent-plugin-mkt
codex plugin marketplace upgrade agent-plugin-marketplace
codex plugin add postgres-sql@agent-plugin-marketplace

Paste and run these commands in a terminal with Codex. They add and refresh the PluginsMP catalog, then install this plugin.

The installer fetches third-party code from the source repository shown on this page. This directory validates manifest structure and source location, but does not perform a security audit; review the manifest, components, and source before installing.

Get the source manually
git clone https://github.com/dashed/claude-marketplace

Clone the source repository, then follow its setup instructions to add the plugin to a compatible client. The plugin root is plugins/postgres-sql/.

Plugin files

plugins/postgres-sql/
├── .codex-plugin/plugin.json
└── skills/postgres-sql/SKILL.md

Included Skills1

postgres-sqlskills/postgres-sql/SKILL.md

The PostgreSQL SQL dialect and data types that set Postgres apart from generic SQL. Use when writing or debugging Postgres-specific SQL — upsert (`INSERT ... ON CONFLICT DO UPDATE/NOTHING`), `RETURNING` (incl. `OLD`/`NEW`), `MERGE`, CTEs (`WITH`/`MATERIALIZED`/recursive/data-modifying), window frames, `GROUPING SETS`/`CUBE`/`ROLLUP`, `DISTINCT ON`, `LATERAL`, `FILTER`, generated & identity columns, declarative partitioning, `jsonb` operators + jsonpath + SQL/JSON (`JSON_TABLE`/`IS JSON`), arrays, ranges & multiranges, composite/enum/domain types, and functions like `uuidv7()`/`gen_random_uuid()`/`ANY_VALUE()`. Triggers on `ON CONFLICT`, `MERGE`, `jsonb`, `@>`/`->>`, `GENERATED ... AS IDENTITY`, `PARTITION BY`. Disambiguation — this is the SQL dialect & types; for the `psql` client use psql, for tuning/EXPLAIN/indexes use postgres-performance, for config/auth/backup use postgres-admin, for contrib use postgres-extensions. Features carry inline `(pgNN+)` tags; unlisted = long-standing (bedrock since 9.x).

Plugin manifests1

plugins/postgres-sql/.codex-plugin/plugin.json
{
  "name": "postgres-sql",
  "version": "1.0.0+codex.b2021964a7df",
  "description": "The PostgreSQL SQL dialect & data types that set Postgres apart from generic SQL. Use when writing or debugging Postgres-specific SQL — upsert (`ON CONFLICT`), `RETURNING`, `MERGE`, CTEs, window frames, `GROUPING SETS`, `LATERAL`, generated/identity columns, partitioning, `jsonb`/jsonpath/SQL-JSON (`JSON_TABLE`), arrays, ranges, composite/enum/domain types, `uuidv7()`. Includes `(pgNN+)` annotations. Dialect & types — client -> psql, tuning -> postgres-performance, config -> postgres-admin.",
  "author": {
    "name": "Alberto Leal"
  },
  "license": "MIT",
  "keywords": [
    "postgres",
    "postgresql",
    "sql",
    "jsonb",
    "merge",
    "upsert",
    "partitioning"
  ],
  "interface": {
    "displayName": "Postgres SQL",
    "shortDescription": "The PostgreSQL SQL dialect & data types that set Postgres apart from generic SQL. Use when writing or debugging Postgres-specific SQL — upsert (`ON CONFLICT`), `RETURNING`...",
    "longDescription": "The PostgreSQL SQL dialect & data types that set Postgres apart from generic SQL. Use when writing or debugging Postgres-specific SQL — upsert (`ON CONFLICT`), `RETURNING`, `MERGE`, CTEs, window frames, `GROUPING SETS`, `LATERAL`, generated/identity columns, partitioning, `jsonb`/jsonpath/SQL-JSON (`JSON_TABLE`), arrays, ranges, composite/enum/domain types, `uuidv7()`. Includes `(pgNN+)` annotations. Dialect & types — client -> psql, tuning -> postgres-performance, config -> postgres-admin.",
    "developerName": "Alberto Leal",
    "category": "Productivity",
    "capabilities": [
      "Skills"
    ],
    "defaultPrompt": [
      "Use $postgres-sql for this task."
    ]
  },
  "repository": "https://github.com/dashed/claude-marketplace/tree/master/plugins/postgres-sql",
  "skills": "./skills/"
}

For maintainers

If you maintain this plugin, link to this source-backed listing from your README so users can review its manifest and indexed components.

[postgres-sql on Agent Plugins Marketplace](https://pluginsmp.com/plugins/postgres-sql)