Agent Plugins Marketplace
← All plugins

postgresql-external-dev

v1.2.0

PostgreSQL knowledge for low-code stacks. Schema design for external database connections (compatible SQL patterns for NocoDB and NocoBase — table creation, column types, relations, indexes, anti-patterns), plus the 29-tool PostgreSQL MCP reference and the PostgREST REST API.

Codex8 Skills

By AGENTS.STORE0 GitHub starsUpdated 2 weeks ago

Directory evidence

Runtimes
Codex
Parsed components
8 skill or MCP entries
Source updated
Oct 4, 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 postgresql-external-dev for Codex

Installs for the current user
codex plugin marketplace add Agents-Store/codex-plugins
codex plugin marketplace upgrade agents-store-codex-plugins
codex plugin add postgresql-external-dev@agents-store-codex-plugins

Paste and run these commands in a terminal with Codex. They add and refresh the agents-store-codex-plugins catalog, then install this plugin.

Compatibility: the page URL and API slug “postgresql-external-dev” remain stable.

  • Codex: postgresql-external-dev@agent-plugin-marketplace → postgresql-external-dev@agents-store-codex-plugins

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/Agents-Store/codex-plugins

Clone the source repository, then follow its setup instructions to add the plugin to a compatible client. The plugin root is postgresql-external-dev/.

Plugin files

postgresql-external-dev/
├── .codex-plugin/plugin.json
├── skills/column-types/SKILL.md
├── skills/create-tables/SKILL.md
├── skills/examples/SKILL.md
├── skills/modify-schema/SKILL.md
├── skills/postgres-mcp-tools/SKILL.md
├── skills/postgrest-api/SKILL.md
├── skills/relations/SKILL.md
└── skills/troubleshoot/SKILL.md

Included Skills8

column-typesskills/column-types/SKILL.md

This skill should be used when the user asks "what SQL type for", "which column type", "NocoDB column types", "NocoBase field types", "type compatibility", "how to store email/url/phone/json/rating", "what type for currency", "decimal vs double", "jsonb", "uuid column", "ARRAY column", "PostgreSQL enum", or needs to choose the correct PostgreSQL type that works in both NocoDB and NocoBase.

create-tablesskills/create-tables/SKILL.md

This skill should be used when the user asks to "create a table", "design a schema", "set up a database", "create PostgreSQL tables for NocoDB", "create tables for NocoBase external DB", "what PK type to use", "UUID primary key", "table without a primary key", "does NocoBase need a license", or needs to understand how NocoDB and NocoBase interact with the same PostgreSQL database.

examplesskills/examples/SKILL.md

This skill should be used when the user asks for a "full example", "complete schema", "e-commerce schema", "blog schema", "CRM schema", "content management schema", "show me a real schema", "sample database", "end-to-end example", or wants to see a complete working PostgreSQL schema with all tables, constraints, indexes, and relations that is compatible with NocoDB and NocoBase.

modify-schemaskills/modify-schema/SKILL.md

This skill should be used when the user asks to "alter a table", "rename a column", "change column type", "drop a column", "drop a table", "remove a constraint", "delete a junction table", "add default value", "set NOT NULL", "sync schema", "meta sync", "refresh data source", "NocoDB doesn't show the new column", or needs to modify an existing PostgreSQL schema that is connected to NocoDB or NocoBase.

postgres-mcp-toolsskills/postgres-mcp-tools/SKILL.md

This skill should be used when the user wants to "run SQL through MCP", "use the PostgreSQL MCP tools", "execute_sql", "inspect a database schema over MCP", "list indexes, locks or bloated tables", "analyze query performance with MCP", "check database status", "get a query plan", "MCP Toolbox for Databases", or needs the tool reference of the 29-tool PostgreSQL MCP server for querying and administering a PostgreSQL database.

postgrest-apiskills/postgrest-api/SKILL.md

This skill should be used when the user wants to "use PostgREST", "make REST calls to PostgreSQL", "CRUD over HTTP on a PostgreSQL table", "upsert with on_conflict", "Prefer header options", "return=representation", "max-affected", "call a stored function over REST", "read PostgreSQL from an n8n HTTP Request node", or "read PostgreSQL from a Trigger.dev task with fetch".

relationsskills/relations/SKILL.md

This skill should be used when the user asks to "create a relation", "add foreign key", "set up one-to-many", "many-to-many relation", "one-to-one", "self-referential", "junction table", "composite primary key", "FK constraint", "create index on FK", or needs to connect tables in a PostgreSQL database that works with NocoDB and NocoBase.

troubleshootskills/troubleshoot/SKILL.md

This skill should be used when the user asks about "incompatible types", "what to avoid", "schema checklist", "NocoDB doesn't recognize", "NocoBase can't read", "ARRAY not working", "ENUM alternative", "jsonb support", "UUID primary key problem", "external PostgreSQL missing in NocoBase", "naming conventions", "validation checklist", or encounters issues with a PostgreSQL schema connected to NocoDB or NocoBase.

Plugin manifests1

postgresql-external-dev/.codex-plugin/plugin.json
{
  "name": "postgresql-external-dev",
  "version": "1.2.0",
  "description": "PostgreSQL knowledge for low-code stacks. Schema design for external database connections (compatible SQL patterns for NocoDB and NocoBase — table creation, column types, relations, indexes, anti-patterns), plus the 29-tool PostgreSQL MCP reference and the PostgREST REST API.",
  "author": {
    "name": "AGENTS.STORE"
  },
  "keywords": [
    "postgresql",
    "postgres",
    "database",
    "schema",
    "sql",
    "postgrest",
    "mcp",
    "nocodb",
    "nocobase",
    "external-database",
    "low-code",
    "dev",
    "agents-store"
  ],
  "skills": "./skills/",
  "interface": {
    "displayName": "Postgresql External Dev",
    "shortDescription": "PostgreSQL knowledge for low-code stacks. Schema design for…",
    "longDescription": "PostgreSQL knowledge for low-code stacks. Schema design for external database connections (compatible SQL patterns for NocoDB and NocoBase — table creation, column types, relations, indexes, anti-patterns), plus the 29-tool PostgreSQL MCP reference and the PostgREST REST API.",
    "developerName": "AGENTS.STORE",
    "category": "development",
    "capabilities": [
      "Read",
      "Write"
    ],
    "websiteURL": "https://agents.store"
  }
}

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.

[postgresql-external-dev on Agent Plugins Marketplace](https://pluginsmp.com/plugins/postgresql-external-dev)