---
title: "postgresql-external-dev"
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-to"
canonical: https://agentpluginsdirectory.com/plugins/postgresql-external-dev
last-updated: 2026-11-13
---

# postgresql-external-dev
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.
## Package we checked
The manifest we fetched is postgresql-external-dev/plugin.json in Agents-Store/agentplugins. The plugin root is the directory that holds that file. Its $schema is https://agent-plugins.org/schemas/1.0.0/plugin.schema.json. The manifest lists 8 skills (column-types, create-tables, examples, modify-schema, postgres-mcp-tools, postgrest-api, relations, troubleshoot) and no MCP servers. Extension keys: com.anthropic.claude-code.
- Slug: postgresql-external-dev
- Publisher: AGENTS.STORE
- Repository: https://github.com/Agents-Store/agentplugins
- Manifest: postgresql-external-dev/plugin.json
- Version: 1.2.8
- Category (editorial): databases
- Skills: 8 (column-types, create-tables, examples, modify-schema, postgres-mcp-tools, postgrest-api, relations, troubleshoot)
- MCP servers: 0
- Stars: 0
- Repository created: 2026-08-18
- Repository last pushed: 2026-11-05
- Publisher type: Organization
- Listing: https://agentpluginsdirectory.com/plugins/postgresql-external-dev
- Schema: https://agent-plugins.org/schemas/1.0.0/plugin.schema.json

## What postgresql-external-dev does, in the publisher's words

PostgreSQL schema design for external database connections. Compatible SQL patterns for NocoDB and NocoBase, table creation, column types, relations, indexes, and anti-patterns.

From the project README, punctuation lightly normalized. Full text: https://raw.githubusercontent.com/Agents-Store/agentplugins/HEAD/postgresql-external-dev/README.md

## Skills

- column-types: 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", or needs to choose the correct PostgreSQL type that…
- create-tables: 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", or needs to understand how NocoDB and NocoBase interact with the same PostgreSQL database.
- examples: 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…
- modify-schema: 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", or needs to modify an existing PostgreSQL schema that is connected to Noc…
- postgres-mcp-tools
- postgrest-api
- relations: 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 datab…
- troubleshoot: 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", "naming conventions", "validation checklist", or encounters issues with a PostgreSQL schema conne…

Descriptions come from the frontmatter of each SKILL.md, punctuation lightly normalized.
