01 Establish Visual Hierarchy
by gnurio
Determine what UI element draws attention first, second, third using size, weight, color, and de-emphasis strategies
Loading Skills Catalog: Organizing 2,800+ verified agent skills, categories, and live metrics...
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and m...
Postgres is an open-source AI agent skill designed for Claude Code, Codex CLI, Cursor, Gemini CLI. It enables autonomous agents to use this skill for any postgresql database work — table design, indexing, data types, constraints, extensions (pgvector, postgis, timescaledb), search, and m... with verified execution instructions and live repository tracking.
Pick the AI assistant you use, then copy the command or follow the steps. New to this? Read the install guide.
Security Notice: Listed from the author's public repository. Not owned or endorsed by SkillHub. Review before installing. Always inspect a skill's SKILL.md and execution scripts before running commands locally.
Installation Time: Downloading and configuring this skill typically takes 15–45 seconds. If your terminal pauses during package downloads, Git checkouts, or dependency resolution, please allow it to finish.
npx skills add timescale/pg-aiguide --skill postgres
This skill uses a direct npx package distribution. Run the verified command below in your terminal:
npx skills add timescale/pg-aiguide --skill postgres
skills/postgresPostgres — Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. Trigger when user asks to: - Explore an existing PostgreSQL database to understand its objects and relationships - Design or modify PostgreSQL tables, schemas, or data models - Choose data types, constraints, indexes, or partitioning strategies - Work with pgvector embeddings, semantic search, or RAG - Set up full-text search, hybrid search, or BM25 ranking - Use PostGIS for spatial/geographic data - Set up TimescaleDB hypertables for time-series data - Migrate tables to hypertables or evaluate migration candidates - Plan or execute safe schema migrations with zero downtime Keywords: PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration
Install with npx skills add timescale/pg-aiguide --skill postgres.
Source: skills/postgres in timescale/pg-aiguide.
The same install steps as plain text, for AI assistants to read:
/skills/postgres/install.txtBroken link, old instructions or a safety worry? Tell us.
Report broken skill or link →Common questions about installing and using this skill.
You can install Postgres by cloning the repository or copying the skill instructions from our Install Tabs into your agent's skills directory (~/.claude/skills/postgres/ for Claude Code or your project's .claude/ folder).
Postgres officially supports Claude Code, Codex CLI, Cursor, Gemini CLI. Setup commands and agent prompts are pre-configured for each platform.
The official repository is hosted on GitHub at https://github.com/timescale/pg-aiguide by author timescale under the Apache-2.0 license.
by gnurio
Determine what UI element draws attention first, second, third using size, weight, color, and de-emphasis strategies
by gnurio
Create clear typographic hierarchy using hand-crafted font sizes, weights, and colors
by gnurio
Create comprehensive palette with 8-10 greys, 5-10 primary, 5-10 accent shades
by gnurio
Use systematic spacing with 25% minimum jumps, start with excess whitespace