PostgreSQL 的 AI Skill

Name: PostgreSQL 的 AI Skill
Brand: KissMySkills
Price: 29.0 USD
Availability: InStock

PostgreSQL Skill AI skill by KissMySkills, cover

$29.00

PostgreSQL 的 AI Skill

$29.00 this skill vs $140+/hr hiring a PostgreSQL consultant

Complete skill package instant downloadai-skill-for-postgresql.txt

Works with

Choose how to get it

Buy once $29 This one skill as a file. Yours forever, works in any AI chat. All-Access whole library $8.25/mo billed yearly All 1,000+ skills in the marketplace. Your AI picks the right one and loads it by itself. Claude, ChatGPT, Claude Code, Cursor · or $19 month to month

Secure checkout by Shopify

⚡ 立即下載 ∞ 永遠保留 ✎ 由我們撰寫

Add it once. Your AI works like a specialist.

將其加入 Claude、ChatGPT 或 Gemini - 您的 AI 會在此領域中擔任專家。

立即下載 · 30 天退款保證。 一次付費，永久使用 - 無需訂閱。由我們撰寫並測試，絕非從 GitHub 抓取。退款政策

Ask it something hard.

📎 ai-skill-for-postgresql.md LOADED ✓

This query on a 40M row events table filters by user_id and last 7 days, orders by created_at desc, limit 50, and EXPLAIN shows a Seq Scan. Fix it.

CLAUDE · WITH THIS SKILL You get: a CREATE INDEX CONCURRENTLY statement on (user_id, created_at DESC) with equality column first and the range-plus-sort column second -> a one-line why explaining the planner can walk the index in sort order and stop after 50 rows with no sort node -> the EXPLAIN (ANALYZE, BUFFERS) query to rerun and what to look for (Index Scan, far fewer shared reads) -> operational notes: CONCURRENTLY cannot run inside a transaction, build off-peak, run ANALYZE afterwards -> the next action: create the index, rerun the plan and paste it if a Seq Scan remains.

購買前有任何問題嗎？

寫信給我們，通常當天就會有人回覆。不會是機器人，也不是排隊等候的客服工單。

hello@kissmyskills.com

Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.

你不需要閱讀。由你的 AI 代勞。

將技能檔案新增至 Claude、ChatGPT 或 Gemini 一次。之後它就會成為此領域的專家，從下一則訊息開始立即運作。

購買一次，檔案便永久歸您所有。或者訂閱 All-Access，讓 KissMySkills 連接器在您提出要求時，將該檔案及其他所有技能載入您的聊天中。

// what's inside

這項技能包含什麼

SQL with CTEs, window functions, DISTINCT ON and ON CONFLICT upserts
EXPLAIN ANALYZE diagnosis with the exact index or rewrite that fixes it
Lock-safe migrations: nullable add, batched backfill, NOT VALID then VALIDATE
pg_stat_statements and pg_stat_activity queries for slow and blocking sessions

Backend developers, data engineers and DBAs who write SQL or run PostgreSQL in production every day.

// what's inside

What you're actually buying

這項 Claude/ChatGPT 技能可在日常資料庫工作中，作為 PostgreSQL AI 結對程式設計師：使用 CTE、視窗函數和 LATERAL JOIN 撰寫 SQL，讀取 EXPLAIN (ANALYZE, BUFFERS) 輸出以找出耗費資源的節點和缺少的索引，產生 CREATE TABLE 和 CREATE INDEX CONCURRENTLY 陳述式，撰寫可安全處理鎖定的多步驟遷移，並起草 PL/pgSQL 函數和觸發程序。

它了解包括 jsonb 和 timestamptz 在內的資料類型、B-tree、GIN、BRIN 和部分索引、MVCC 和隔離層級、VACUUM 和 autovacuum、pg_stat_statements 和 pg_stat_activity、pg_dump 和 pg_restore、複寫、PgBouncer、psql 中繼命令，以及 PostGIS、pg_trgm 和 pgvector 等常見擴充功能。它不會連線到您的資料庫或執行任何操作；它會準備 SQL、遷移順序和驗證查詢，讓您能安全地套用。

在 Claude、ChatGPT 和 Gemini 中的運作方式都相同。購買一次，下載檔案，在 2 分鐘內完成安裝，接著貼上資料表定義或 EXPLAIN 計畫，就能取得 PostgreSQL SQL。可搭配 Oleg，資料庫工程師這項角色技能使用；這一項則是 PostgreSQL 內部的輔助工具。

ai-skill-for-postgresql.txt

# AI Skill for PostgreSQL
KissMySkills.com | Install: paste this whole file into Claude Projects (Project instructions), a custom GPT (Instructions), a Gemini Gem, or your AI's system prompt. Then just ask questions the way you normally would.

## Who you are
You are a senior PostgreSQL practitioner embedded in the user's daily development and database work, with thousands of queries, pragmatic schemas and production clusters behind you. You optimise for correct SQL that uses indexes, schemas that stay consistent under load, and safe changes to live databases. Tone: direct, practical, step-by-step when needed.

## What you know about PostgreSQL
- Core objects: schemas, tables, constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL), identity columns, views, materialized views, functions, triggers, extensions, roles.
- Data types: bigint, numeric, text, boolean, timestamptz, inter

您將下載的實際檔案範例。

// how to install 不到 2 分鐘

四個步驟。任何 AI 聊天。

01
下載檔案
結帳後，下載連結會寄到您的收件匣。將檔案儲存至裝置上的任意位置。
02
開啟你的 AI 聊天功能
Claude、ChatGPT、Gemini、Grok 或 Copilot - 無論你目前使用哪一個。
03
貼上檔案內容
將其放入系統 prompt、專案指示或自訂指示欄位中。
04
開始工作
您的 AI 現已設定為專業助手。您可以詢問它任何與其專業領域相關的問題。

不需要技術知識。不需訂閱。一次付費，永久使用。

// compatible with

支援所有主要的 AI 聊天服務。

將檔案放入您的 AI system prompt、專案指示或自訂指示中。無需設定。無需程式碼。不受供應商綁定。

// faq

關於此產品的問題

What does the AI Skill for PostgreSQL do?+

It turns Claude or ChatGPT into a PostgreSQL AI assistant that writes and optimises SQL, reads EXPLAIN ANALYZE plans, recommends indexes, designs schemas with proper constraints, writes lock-safe migrations, drafts PL/pgSQL functions and triggers, and gives you diagnostic queries for bloat, slow statements and blocking sessions.

Does it operate PostgreSQL for me?+

No. It does not connect to your database, run queries, build indexes or apply migrations. It writes the SQL, the migration steps in the right order and the verification query, and you run them in psql, pgAdmin or your migration tool against your own PostgreSQL database.

Can the PostgreSQL skill write migrations that are safe on a live table?+

Yes. It splits changes into steps that avoid long locks: add the column nullable, backfill in batches, add the constraint as NOT VALID and VALIDATE later, and build indexes with CREATE INDEX CONCURRENTLY. It formats the migration for Flyway, Alembic, Prisma, Rails or Django when you name your tool, and it warns which PostgreSQL versions change the lock behaviour.

Does it cover managed PostgreSQL like RDS, Supabase or Neon?+

It covers self-managed PostgreSQL and managed services such as Amazon RDS and Aurora, Cloud SQL, Azure Database, Supabase and Neon, and it asks which one you use when extensions, configuration access or backup options differ. It never invents parameters or version numbers.

Which AI tools does this skill work with?+

Works with Claude (recommended), Claude Code, ChatGPT, Gemini and Copilot, and any AI chat that accepts system prompts. Claude Projects gives the best results because it remembers your PostgreSQL schema, table sizes and version between chats.

Do I have to read it myself?+

No. The file is written for your AI to read, not for you. Upload it or paste it in once and the AI takes on the role. After that you just ask it questions the way you normally would. You're welcome to open it and read it, but nothing here depends on you doing that.

Is this a physical book?+

No, it's digital. You download it the moment the order goes through and it's yours permanently. The cover is styled like a book because each edition is written and edited as one self-contained piece of work. The reading part is your AI's job, not yours.