Co-Pilot / 辅助式
更新于 a month ago

postgres-skill

Ssanjay3290
0.0k
sanjay3290/postgres-skill
76
Agent 评分

💡 摘要

一系列用于编码助手的AI技能,支持多个平台的各种功能。

🎯 适合人群

寻求编码帮助的AI开发者需要数据库查询的数据分析师协调AI任务的项目经理学习AI集成的学生探索AI能力的科技爱好者

🤖 AI 吐槽:看起来很能打,但别让配置把人劝退。

安全分析中风险

风险:Medium。建议检查:是否执行 shell/命令行指令;是否发起外网请求(SSRF/数据外发);API Key/Token 的获取、存储与泄露风险;文件读写范围与路径穿越风险;依赖锁定与供应链风险。以最小权限运行,并在生产环境启用前审计代码与依赖。

AI Agent Skills

Ask DeepWiki

A collection of portable skills for AI coding assistants. Works with all major AI clients that support the Agent Skills Standard.

Supported AI Clients

| Client | Skills Directory | Documentation | |--------|-----------------|---------------| | Claude Code | ~/.claude/skills/ or .claude/skills/ | docs | | Gemini CLI | ~/.gemini/skills/ or .gemini/skills/ | docs | | Google Antigravity | ~/.gemini/antigravity/skills/ or .agent/skills/ | docs | | Cursor | ~/.cursor/skills/ or .cursor/skills/ | docs | | OpenAI Codex CLI | ~/.codex/skills/ or .codex/skills/ | docs | | Goose | ~/.config/goose/skills/ or .goose/skills/ | docs |

Available Skills

| Skill | Description | |-------|-------------| | postgres | Read-only PostgreSQL queries with defense-in-depth security | | imagen | AI image generation using Google Gemini (cross-platform) | | deep-research | Autonomous multi-step research using Gemini Deep Research Agent | | outline | Search, read, and manage Outline wiki documents | | jules | Delegate coding tasks to Google Jules AI agent (async bug fixes, docs, tests, features) |

Google Workspace Skills

Lightweight alternatives to the full Google Workspace MCP server. Each skill has standalone OAuth authentication with cross-platform token storage via keyring.

⚠️ Requires Google Workspace account. Personal Gmail accounts are not supported. These skills use the same OAuth infrastructure as the official Google Workspace MCP.

| Skill | Description | |-------|-------------| | google-chat | List spaces, send messages, DMs, create spaces | | google-docs | Create, read, edit Google Docs | | google-sheets | Read spreadsheets, get ranges, find sheets | | google-slides | Read presentations, get text and metadata | | google-drive | Search files, list folders, download files | | google-calendar | Events, scheduling, free time lookup | | gmail | Search, read, send emails, manage labels |

Installation

Option 1: Clone entire repository

# Clone to your preferred skills directory git clone https://github.com/sanjay3290/ai-skills.git ~/.claude/skills/ai-skills # Or for other clients: # git clone https://github.com/sanjay3290/ai-skills.git ~/.gemini/skills/ai-skills # git clone https://github.com/sanjay3290/ai-skills.git ~/.gemini/antigravity/skills/ai-skills # git clone https://github.com/sanjay3290/ai-skills.git ~/.cursor/skills/ai-skills # git clone https://github.com/sanjay3290/ai-skills.git ~/.codex/skills/ai-skills # git clone https://github.com/sanjay3290/ai-skills.git ~/.config/goose/skills/ai-skills

Option 2: Copy individual skills

# Example: Install just the postgres skill cp -r skills/postgres ~/.claude/skills/

Option 3: Symlink for development

# Symlink skills for easy updates ln -s /path/to/ai-skills/skills/postgres ~/.claude/skills/postgres ln -s /path/to/ai-skills/skills/imagen ~/.claude/skills/imagen

Client-Specific Installation

Claude Code

# Global installation cp -r skills/* ~/.claude/skills/ # Or project-level cp -r skills/* .claude/skills/

Gemini CLI

# Global installation cp -r skills/* ~/.gemini/skills/ # Or workspace-level cp -r skills/* .gemini/skills/

Google Antigravity

# Global installation cp -r skills/* ~/.gemini/antigravity/skills/ # Or workspace-level cp -r skills/* .agent/skills/

Cursor

# Global installation cp -r skills/* ~/.cursor/skills/ # Or project-level cp -r skills/* .cursor/skills/

OpenAI Codex CLI

# Global installation cp -r skills/* ~/.codex/skills/ # Or repository-level cp -r skills/* .codex/skills/

Goose

# Global installation cp -r skills/* ~/.config/goose/skills/ # Or project-level cp -r skills/* .goose/skills/

Skill Setup

Each skill may require additional configuration:

Postgres

Create connections.json in the skill directory with your database credentials. See postgres/README.md.

Imagen & Deep Research

export GEMINI_API_KEY=your-api-key

Get a free key at Google AI Studio.

Note: Deep Research tasks take 2-10 minutes and cost $2-5 per query.

Outline

export OUTLINE_API_KEY=your-api-key export OUTLINE_API_URL=https://your-wiki.example.com/api # Optional

Get your API key from your Outline wiki settings.

Jules

# Install CLI (one-time) npm install -g @google/jules # Authenticate (opens browser) jules login

Connect your GitHub repos at jules.google.com. Jules works asynchronously - create a task, it runs in the background, then pull results when complete.

Google Workspace Skills

Each Google Workspace skill requires the keyring library and first-time authentication:

# Install dependency (one-time) pip install keyring # Authenticate for the skill you need (opens browser) python ~/.claude/skills/ai-skills/skills/google-chat/scripts/auth.py login python ~/.claude/skills/ai-skills/skills/google-docs/scripts/auth.py login python ~/.claude/skills/ai-skills/skills/google-sheets/scripts/auth.py login python ~/.claude/skills/ai-skills/skills/google-slides/scripts/auth.py login python ~/.claude/skills/ai-skills/skills/google-drive/scripts/auth.py login python ~/.claude/skills/ai-skills/skills/google-calendar/scripts/auth.py login python ~/.claude/skills/ai-skills/skills/gmail/scripts/auth.py login

Tokens stored securely via system keyring:

  • macOS: Keychain
  • Windows: Windows Credential Locker
  • Linux: Secret Service API (GNOME Keyring, KDE Wallet, etc.)

Usage

Once installed, skills activate automatically based on your requests. Just ask naturally:

Postgres

  • "Query my production database for active users"
  • "Show me the schema of the orders table"
  • "How many signups last week?"

Imagen

  • "Generate an image of a sunset over mountains"
  • "Create an app icon for my weather app"
  • "I need a hero image for my landing page"

Deep Research

  • "Research the competitive landscape of EV batteries"
  • "Compare React, Vue, and Angular frameworks"
  • "What are the latest developments in Kubernetes?"

Outline

  • "Search the wiki for deployment guide"
  • "Read the onboarding documentation"
  • "Create a new wiki page for the API spec"

Jules

  • "Have Jules fix the authentication bug in src/auth.js"
  • "Delegate adding unit tests to Jules"
  • "Ask Jules to add documentation to the API module"
  • "Check my Jules sessions" / "Pull the results from Jules"

Google Workspace

  • "List my Google Chat spaces" / "Send a message to Project Alpha"
  • "Create a new Google Doc about the project proposal"
  • "Get the content of my Q4 Budget spreadsheet"
  • "What's on my calendar tomorrow?"
  • "Search my Gmail for invoices from last month"
  • "Find files named 'report' in my Drive"

Skill Structure

All skills follow the Agent Skills Standard:

skill-name/
├── SKILL.md              # Required: Instructions for the AI agent
├── README.md             # Human documentation
├── requirements.txt      # Dependencies (if any)
├── .env.example          # Environment variable template
└── scripts/              # Executable scripts
    └── main.py

The SKILL.md file uses YAML frontmatter:

--- name: skill-name description: "When to use this skill" --- # Instructions for the AI agent

Contributing

  1. Fork this repository
  2. Create a new skill in skills/your-skill-name/
  3. Include SKILL.md with proper frontmatter
  4. Add documentation in README.md
  5. Submit a pull request

Credits

  • Google Workspace Skills - Based on the official Google Workspace MCP server by the Gemini CLI team. Uses their OAuth cloud function for authentication.

License

Apache-2.0

五维分析
清晰度8/10
创新性6/10
实用性9/10
完整性8/10
可维护性7/10
优缺点分析

优点

  • 支持多个AI客户端
  • 提供多种实用技能
  • 安装和设置简单
  • 跨平台兼容性

缺点

  • 需要特定客户端配置
  • 某些技能需要额外的API密钥
  • 文档可以更详细
  • PostgreSQL仅限于只读

相关技能

banana-skills

B
toolCo-Pilot / 辅助式
78/ 100

“看起来很能打,但别让配置把人劝退。”

pytorch

S
toolCode Lib / 代码库
92/ 100

“它是深度学习的瑞士军刀,但祝你好运能从47种安装方法里找到那个不会搞崩你系统的那一个。”

agno

S
toolCode Lib / 代码库
90/ 100

“它承诺成为智能体领域的Kubernetes,但得看开发者有没有耐心学习又一个编排层。”

免责声明:本内容来源于 GitHub 开源项目,仅供展示和评分分析使用。

版权归原作者所有 sanjay3290.