New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Postgresql Table Design

by ynulihao in ynulihao/AgentSkillOS

Design a PostgreSQL-specific schema. An agent skill from ynulihao/AgentSkillOS.

No licenceAuto-check passedDatabases

Install Postgresql Table Design

skills CLI
$ npx skills add ynulihao/AgentSkillOS --skill postgresql-table-design -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install ynulihao/AgentSkillOS postgresql-table-design --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/ynulihao/AgentSkillOS.git skills-src && mkdir -p .claude/skills && cp -r skills-src/data/skill_seeds/postgresql-table-design .claude/skills/postgresql-table-design && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
postgresql-table-design
GitHub stars
617
Used in
15 other repos
Token cost
~4k tokens
SKILL.md length
1,833 words
Files
1
Skills in repo
26
Repo updated
First seen
Licence
None found

At a glance

Design a PostgreSQL-specific schema. An agent skill from ynulihao/AgentSkillOS.

  • Databases work in your project
  • SKILL.md covers Core Rules, PostgreSQL “Gotchas”, Data Types and Table Types, plus 9 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Postgresql Table Design is an agent skill from ynulihao/AgentSkillOS. Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Its SKILL.md is about 4k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases. It works with PostgreSQL. The repository describes itself as: Build your agent from 200,000+ skills via skill RETRIEVAL & ORCHESTRATION.

When your agent uses it

  • Databases work in your project

Example prompts

  • “/postgresql-table-design”

What it can do on your machine

Read from SKILL.md and the folder at commit c3cfae1. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are sql).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Postgresql Table Design loads about 4k tokens when it runs. Until then it costs about 41 tokens; SKILL.md has 1,833 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~41
When it runs · the whole SKILL.md, loaded when a task matches
~4k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 1,833 words (~4,000 tokens).

“Enable with ALTER TABLE tbl ENABLE ROW LEVEL SECURITY. Create policies: CREATE POLICY user_access ON orders FOR SELECT TO app_users USING (user_id = current_user_id()). Built-in user-based access control at the row level.”

— opening of SKILL.md by ynulihao
name
postgresql-table-design

Read the full SKILL.md on GitHub

Files

Just SKILL.md in data/skill_seeds/postgresql-table-design of ynulihao/AgentSkillOS.

Open the folder on GitHubat commit c3cfae1

Used in 15 other repositories

We found 26 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 15 other GitHub owners. This page covers the copy in ynulihao/AgentSkillOS, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Postgresql Table Design next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Postgresql Table Design compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Postgresql Table Design this skillynulihao/AgentSkillOS61715 repos~4kAutomated safety check: PassNone
Backend Test WorkerCorrectRoadH/OpenTickly306—~1.3kAutomated safety check: PassAGPL-3.0
Ef Core Migrationsjihadkhawaja/Egroo178—~673Automated safety check: PassApache-2.0
Add Oliphaunt Extensionf0rr0/oliphaunt105—~1.4kAutomated safety check: PassMIT
Diagnose Cloud SessionFreakStudioCN/mpy-hardware-extension132—~809Automated safety check: NotesCustom licence
DB AdminEliasOulkadi/shokunin114—~2kAutomated safety check: NotesMIT

Similar skills

  • Backend Test Worker

    CorrectRoadH/OpenTickly

    Build and verify real-Postgres Go tests and thin transport smoke for tracking behavior.

    306 GitHub stars~1.3k tokensUpdated 5 days ago
    DatabasesAuto-check passed

  • Ef Core Migrations

    jihadkhawaja/Egroo

    Handle EF Core schema changes in Egroo. An agent skill from jihadkhawaja/Egroo.

    178 GitHub stars~673 tokensUpdated 6 mo ago
    DatabasesAuto-check passed

  • Add Oliphaunt Extension

    f0rr0/oliphaunt

    Add, update, or remove an Oliphaunt PostgreSQL contrib or external extension, including source pins, build recipes, target support, SDK metadata, release products, carrier identities, and package…

    105 GitHub stars~1.4k tokensUpdated today
    DatabasesAuto-check passed

  • Diagnose Cloud Session

    FreakStudioCN/mpy-hardware-extension

    用户报告 Blockless 扩展在云端实测时出问题（卡死/灰屏/跳步/构建失败），但本地复现不了、日志不在本地文件里时，用这个从云端托管数据库拉真实 session 定位症状与根因 / Use when a user reports an in-product Blockless bug from live cloud-backend testing and the real session…

    132 GitHub stars~809 tokensUpdated 9 days ago
    DatabasesAuto-check: notes

  • DB Admin

    EliasOulkadi/shokunin

    PostgreSQL database administration — backup/restore (pgdump, PITR, WAL archiving), health monitoring (connections, bloat, cache hit ratio, dead tuples), connection pooling (PgBouncer), replication…

    114 GitHub stars~2k tokensUpdated 3 days ago
    DatabasesAuto-check: notes

  • Postgres Patterns

    ThibautBaissac/rails_ai_agents

    PostgreSQL database patterns for query optimization, schema design, indexing, and security.

    665 GitHub starsUsed in 7 repos~922 tokens
    DatabasesAuto-check passed

More from ynulihao/AgentSkillOS

All 26 skills in this repo

  • Generate Image

    ynulihao/AgentSkillOS

    Generate or edit images using AI models (FLUX, Gemini). An agent skill from ynulihao/AgentSkillOS.

    617 GitHub starsUsed in 10 repos~1.7k tokens
    Auto-check: notes

  • Data Storytelling

    ynulihao/AgentSkillOS

    Transform data into compelling narratives using visualization, context, and persuasive structure.

    617 GitHub starsUsed in 16 repos~2.8k tokens
    Auto-check passed

  • Prompt Engineering Patterns

    ynulihao/AgentSkillOS

    Master advanced prompt engineering techniques to maximize LLM performance, reliability, and controllability in production.

    617 GitHub starsUsed in 15 repos~1.7k tokens
    Auto-check passed

  • Employment Contract Templates

    ynulihao/AgentSkillOS

    Create employment contracts, offer letters, and HR policy documents following legal best practices.

    617 GitHub starsUsed in 12 repos~4.1k tokens
    Auto-check passed

  • SQL Optimization Patterns

    ynulihao/AgentSkillOS

    Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

    617 GitHub starsUsed in 11 repos~3.3k tokens
    Auto-check passed

  • Media Processing

    ynulihao/AgentSkillOS

    Process multimedia files with FFmpeg (video/audio encoding, conversion, streaming, filtering, hardware acceleration), ImageMagick (image manipulation, format conversion, batch processing, effects…

    617 GitHub stars~817 tokensUpdated 7 mo ago
    Auto-check: notes

Works with

Categories

Questions about Postgresql Table Design

What does Postgresql Table Design do?

Design a PostgreSQL-specific schema. An agent skill from ynulihao/AgentSkillOS. Postgresql Table Design is an agent skill from ynulihao/AgentSkillOS. Design a PostgreSQL-specific schema.

When should I use Postgresql Table Design?

Postgresql Table Design fits situations like: databases work in your project.

How do I install Postgresql Table Design in Claude Code?

Run `npx skills add ynulihao/AgentSkillOS --skill postgresql-table-design -a claude-code`. Or copy the skill folder (data/skill_seeds/postgresql-table-design in ynulihao/AgentSkillOS) into .claude/skills/postgresql-table-design in your project. Claude Code loads it when a task matches its description.

How do I install Postgresql Table Design in Codex?

Run `npx skills add ynulihao/AgentSkillOS --skill postgresql-table-design -a codex`. Or copy the skill folder (data/skill_seeds/postgresql-table-design in ynulihao/AgentSkillOS) into .agents/skills/postgresql-table-design in your project. Codex loads it when a task matches its description.

Can I use Postgresql Table Design in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add ynulihao/AgentSkillOS --skill postgresql-table-design -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/postgresql-table-design, .gemini/skills/postgresql-table-design, .github/skills/postgresql-table-design and .opencode/skills/postgresql-table-design in your project.

What does Postgresql Table Design need to run?

SKILL.md names no scripts, command-line tools or credentials: Postgresql Table Design is instructions for the agent only.

Does Postgresql Table Design access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Postgresql Table Design safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Postgresql Table Design use?

No licence was found for Postgresql Table Design or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does Postgresql Table Design use?

About 4k tokens (SKILL.md is roughly 16k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Postgresql Table Design?

Skills that share tags, products or a category with Postgresql Table Design: Backend Test Worker (CorrectRoadH/OpenTickly, 306 stars), Ef Core Migrations (jihadkhawaja/Egroo, 178 stars), Add Oliphaunt Extension (f0rr0/oliphaunt, 105 stars) and Diagnose Cloud Session (FreakStudioCN/mpy-hardware-extension, 132 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Postgresql Table Design?

ynulihao (a GitHub user) maintains it in ynulihao/AgentSkillOS, which has 617 GitHub stars. The repository holds 26 skills in this directory. The repository was last updated on March 7, 2026.

Source: ynulihao/AgentSkillOS on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.