프로토타입 · 미리 보기: 공식 레지스트리의 모든 서버를 담고 있으며 30분마다 동기화해요. Google로 로그인하면 리뷰를 쓸 수 있어요.프로토타입 · 30분마다 업데이트
PopNx MCPAI를 쓰는 사람을 위한 MCP 서버 · 쉬운 말로 설명해요

pg-aiguide Skill

저장소 ↗

같은 프로젝트의 MCP 버전도 있습니다 →

제작자: timescale★ 1,886 (whole repo)skill 10개

★ Stars are for the whole repo, not each skill

Pick the skill to install

What it does

This repo is a collection of 10 skills

  • Connects Instruction files the AI reads, with steps that call an outside service
  • Account or key Some steps need a key for OpenAI, OPENROUTER_API_KEY (per the README)
  • Category 코딩
Maker’s original description
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
제작자용: README에 배지 달기

제작자라면 이 코드를 README에 붙여 넣으세요. 배지는 이 페이지로 연결됩니다.

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/skill/timescale-pg-aiguide.svg)](https://mcp.popnx.com/en/skills/timescale-pg-aiguide)

함께 쓰기

같은 작업에서 AI를 서비스에 연결하는 MCP

REA

Reverse engineer anything from your terminal or agent with one CLI and MCP server.

제작자: morluto널리 사용됨↓ 38.9만/주★ 46.4만6일 전 업데이트

MCP · 서비스 연결내 컴퓨터에서 실행

Fallow

Codebase intelligence for TypeScript and JavaScript, exposed as structured MCP analysis tools.

제작자: fallow-rs널리 사용됨↓ 244.1만/주★ 5.4천어제 업데이트

MCP · 서비스 연결내 컴퓨터에서 실행

Desktop Commander

MCP server for terminal commands, file operations, and process management

제작자: wonderwhy-er널리 사용됨↓ 74만/주★ 1만6일 전 업데이트

MCP · 서비스 연결내 컴퓨터에서 실행

비슷한 Skill

같은 종류의 작업, Skill 목록과 같은 순서

비슷한 항목과 비교
이 항목
pg-aiguide
reaandrej-karpathy-skillsgraphifyMoneyPrinterTurbo
제작자timescalemorlutomultica-aiGraphify-Labsharry0703
Skill 수101111
GitHub 별1,886465,460233,910149,364144,149
마지막 코드 변경2026년 11월 16일2026년 11월 17일2026년 4월 20일2026년 11월 17일2026년 11월 17일
라이선스Apache-2.0MIT–Apache-2.0MIT

timescale의 Skill(지시 묶음) 10개, AI가 읽고 그대로 일해요 · MCP server가 아니에요

Pick the skill to install

Install only the ones you use. Open a skill to see how to install it

Install the whole set (10)

If you want every one, let the AI install them in one go. Know 2 things first

  • Every installed skill’s description is loaded into every chat. The more you install, the easier it is for the AI to pick the wrong one
  • Some skills duplicate tools the AI already has built in. Installing only the ones you use works better
Where to install
Please install all 10 skills from https://github.com/timescale/pg-aiguide: design-postgis-tables, design-postgres-tables, find-hypertable-candidates, ghost-database, migrate-postgres-tables-to-hypertables, pgvector-semantic-search, postgres, postgres-database-migration, postgres-hybrid-text-search, setup-timescaledb-hypertables, for all my projects, putting each at ~/.claude/skills/<skill name> (in Codex use ~/.agents/skills/<skill name>, in Cursor ~/.cursor/skills/<skill name>). Folders in the repo: design-postgis-tables = skills/design-postgis-tables · design-postgres-tables = skills/design-postgres-tables · find-hypertable-candidates = skills/find-hypertable-candidates · ghost-database = skills/ghost-database · migrate-postgres-tables-to-hypertables = skills/migrate-postgres-tables-to-hypertables · pgvector-semantic-search = skills/pgvector-semantic-search · postgres = skills/postgres · postgres-database-migration = skills/postgres-database-migration · postgres-hybrid-text-search = skills/postgres-hybrid-text-search · setup-timescaledb-hypertables = skills/setup-timescaledb-hypertables. First show me every file and tell me whether any has scripts or changes machine settings, then tell me the full path you will install each one to and wait for me to agree.
Please install all 10 skills from https://github.com/timescale/pg-aiguide: design-postgis-tables, design-postgres-tables, find-hypertable-candidates, ghost-database, migrate-postgres-tables-to-hypertables, pgvector-semantic-search, postgres, postgres-database-migration, postgres-hybrid-text-search, setup-timescaledb-hypertables, into the project this chat is open in (at .claude/skills/<skill name>; in Codex use .agents/skills/<skill name>, in Cursor .cursor/skills/<skill name>). Folders in the repo: design-postgis-tables = skills/design-postgis-tables · design-postgres-tables = skills/design-postgres-tables · find-hypertable-candidates = skills/find-hypertable-candidates · ghost-database = skills/ghost-database · migrate-postgres-tables-to-hypertables = skills/migrate-postgres-tables-to-hypertables · pgvector-semantic-search = skills/pgvector-semantic-search · postgres = skills/postgres · postgres-database-migration = skills/postgres-database-migration · postgres-hybrid-text-search = skills/postgres-hybrid-text-search · setup-timescaledb-hypertables = skills/setup-timescaledb-hypertables. First show me every file and tell me whether any has scripts or changes machine settings, then tell me the project name and the full path you will install each one to and wait for me to agree.

Uploading to Claude on the web and apps: you need 10 uploads, one ZIP per skill. Open each skill in the list below to download it

Checked against official docs 2026년 11월 12일 · Source: support.claude.com, code.claude.com, learn.chatgpt.com, cursor.com

  • design-postgis-tables

    Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

  • design-postgres-tables

    Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference…

  • find-hypertable-candidates

    Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - E…

  • ghost-database

    No description from the maker

  • migrate-postgres-tables-to-hypertables

    Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migratio…

  • pgvector-semantic-search

    Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search. **Trigger when user asks to:** - Store or search vector embeddings in PostgreSQL - Set up semantic search, similarity search, or nearest neighbor search - Create HNSW or…

  • postgres

    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 mo…

  • postgres-database-migration

    Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases. **Trigger when user asks to:** - Test a schema migration before applying it to production - Add, remove, or rename columns safely on a live tab…

  • postgres-hybrid-text-search

    Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pg_textsearch with pgvector toge…

  • setup-timescaledb-hypertables

    Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. **Trigger when user asks to:** - Create or design SQL schemas/…

Skill과 MCP의 차이

MCP = 손

AI를 외부 서비스나 데이터에 연결합니다(예: Notion 읽기, 청구서 만들기). 프로그램이나 서버가 실행 중이어야 합니다.

Skill = 안내서

작업 방법을 AI에게 가르치는 텍스트 파일. 어떤 서비스에도 연결되지 않습니다.

겹치는 경우도 있습니다. 도구를 부르는 스크립트가 있는 Skill도, 지식만 보내는 MCP도 있습니다. 하려는 작업을 기준으로 고르세요.

쓸 수 있는 앱

Claude CodeCodexCursorGemini CLIWindsurfOpenCode

제작자 README와 repo 폴더 기준

설치

Pick a skill first

This repo has 10 skills. Pick one from the list above; its page shows every way to install it, including letting the AI install it and a ZIP

Let the AI install it
Upload to claude.ai

Go to the skill list ↑

The maker’s command installs the whole set of 10
Node.js 설치 (아직 없다면)

이미 설치했나요? 먼저 확인 · 터미널을 열고 이 명령을 입력한 뒤 Enter

node -v
  • 버전 번호(예: v26.13.1)가 나오면 설치된 것입니다. 이 단계는 건너뛰세요
  • "command not found"(Windows는 "is not recognized")가 나오면 아직 설치하지 않았거나, 방금 설치해서 터미널을 닫았다가 다시 열어야 합니다
터미널 여는 법

Mac: ⌘ + Space를 누르고 Terminal 입력 후 Enter

Windows: 시작 메뉴를 열고 Windows PowerShell 입력 후 "열기"

아직 설치하지 않았다면: 공식 다운로드 페이지에서 LTS 버전과 클릭형 설치 파일을 고르세요: Mac은 .pkg · Windows는 .msi. 더블클릭 후 끝까지 진행하면 됩니다. curl 명령은 필요 없습니다

Node.js 다운로드 페이지 열기 ↗

설치가 끝나면 터미널을 닫았다가 다시 열고 같은 명령을 실행하세요. 버전 번호가 나와야 합니다: node -v

한 번 설치하면 Node.js가 필요한 모든 도구에서 쓸 수 있습니다

npx skills add timescale/pg-aiguide --skill postgres

제작자 README에서 가져온 명령으로, 제작자 코드를 내려받아 실행해요

토론

질문하고, 팁을 나누고, 안 되는 점을 알려 주세요. "도움이 됨"이 많은 순서예요.

아직 글이 없어요. 처음으로 질문하거나 공유해 보세요.

이곳의 글은 사용자가 쓴 것으로, PopNx 팀의 글이 아니에요.

로그인하고 글쓰기

GitHub 정보

GitHub 스타
1,886
Stars are for the whole repo, not each skill
제작자
timescale
라이선스
Apache-2.0
최근 코드 수정
2026년 11월 16일
repo 안 SKILL.md(번역본과 템플릿 포함)
10
토픽
ai, ai-agents, ai-coding, claude-code-plugin, claude-code-plugins, claude-code-plugins-marketplace, claude-marketplace, claude-plugin, claude-skills, docs, documentation, mcp