FreeSkills
Commits, branches and sync with the but CLI
- 361361 downloads
- 198198 likes
- 103103 saves
Works with
- Claude Code
- Codex
- Cursor
- and 3 more
PostgreSQL expert guidance hub v1.0.0
Use this resource to design, query and evolve a PostgreSQL database
New
- 497 downloads
- 194 likes
- 209 saves
Free
Install with the CLI
In a terminal, from the folder you want:
npx --yes palatekit@latest install postgresql-expert-guidanceWith no option, the skill goes to ~/.agents/skills/; add --agent claude-code (or codex, cursor…) to target an agent.
First time: connect the CLI with
npx --yes palatekit@latest loginThe agent loads the reference that fits your request: exploring an existing database, table design, data types, indexes, pgvector search, hybrid full-text search, PostGIS, migrations and TimescaleDB hypertables.
Mostly picked by
Updated November 2, 2026
Previews
Details
- Install guides
- Generates with
- Your agent's model
- Licence
- Apache-2.0
Similar resources
View all- Free
FreeSkills
Sentry CLI guide
- 525525 downloads
- 117117 likes
- 128128 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Drizzle ORM best practices with PostgreSQL
- 407407 downloads
- 194194 likes
- 151151 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
SLO design wizard
- 537537 downloads
- 105105 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
User stories and sprint fit
- 451451 downloads
- 150150 likes
- 132132 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Capacity-based sprint plan
- 423423 downloads
- 192192 likes
- 102102 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Startup CTO advisor
- 580580 downloads
- 201201 likes
- 242242 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
FreeSkills
Creating GitHub pull requests with quality checks
- 427427 downloads
- 230230 likes
- 196196 saves
Works with- Claude Code
- Codex
- Cursor
- and 3 more
What you get
- SKILL.md: index of PostgreSQL references by task
- references/: design, migrations, vector search and PostGIS
Good fit for
- You design the schema of a new PostgreSQL application
- You must understand an existing database before changing it
Not for
Tags
- PostgreSQL
- schema
- indexes
- migrations
About
You say
“Design the schema for my billing database and suggest indexes and constraints.”
Skill published by timescale under the Apache-2.0 license, delivered in its original version.
Show moreShow less
How to use it
- Install the skill in your agent's skills folder
- Ask your agent to design, query and evolve a PostgreSQL database
- Review and adjust the result
Content preview
Files
- LICENSE9.4 KB
- NOTICE-PALATEKIT.md0.5 KB
- references/backfill-strategies.md2.4 KB
- references/complete-example.md2.1 KB
- references/design-postgis-tables.md17 KB
- references/design-postgres-tables.md16.7 KB
- references/find-hypertable-candidates.md10.6 KB
- references/migrate-postgres-tables-to-hypertables.md15.2 KB
- references/pgvector-semantic-search.md15.1 KB
- references/postgres-database-migration.md24.7 KB
- references/postgres-hybrid-text-search.md12.6 KB
- references/schema-exploration/guide.md4.3 KB
- references/setup-timescaledb-hypertables.md18.9 KB
- references/validation-queries.md3.6 KB
- SKILL.md3.7 KB
Origin and licence
Listed unmodified
- Author
- timescale
- Source
- github.com/timescale/pg-aiguide/tree/5d3b76b5c986693b30753828b404aa66ba34c31a/skills/postgres
- Licence
- Apache-2.0
Notice
« postgres » (timescale, Apache-2.0) livré dans sa version d'origine : fiche en français et en anglais par PalateKit.
User reviews
–
No ratings yet
Loading reviews…