SQL Reader

Query production PostgreSQL database with read-only credentials. Use for investigating data, debugging issues, or analyzing application state.

8 stars 3 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add Freddy-CHEN-ux/00_claude_skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add Freddy-CHEN-ux/00_claude_skills --skill sql-reader
Manual install
git clone --depth 1 https://github.com/Freddy-CHEN-ux/00_claude_skills.git /tmp/00_claude_skills
mkdir -p ~/.claude/skills
cp -r /tmp/00_claude_skills/skills/sql-reader ~/.claude/skills/sql-reader

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# SQL Reader Skill

Query production PostgreSQL database using read-only credentials stored in Arsenal environment configuration.

## 🚨 MANDATORY: Read Data Quirks First

**BEFORE querying the database, you MUST read the data quirks documentation:**

```bash
cat docs/sql/DATA_QUIRKS.md
```

**Why:** The database has critical semantic quirks that will cause incorrect queries if not understood:
- NULL values have clinical meaning (not "missing data")
- Data inconsistencies require special query patterns
- Volume normalization is required for accuracy

**DO NOT skip this step. Read the file every time before querying.**

---

## When to Use

Use this skill when you need to:
- Investigate data issues in production
- Debug application state
- Analyze user data or conversation history
- Verify database schema or table contents
- Count records or check data integrity
- Understand database structure and relationships

## Database Selection: Production vs Development

**CRITICAL: Always prefer PRODUCTION database for usage/analytics questions.**

The `arsenal/.env` file should be configured with **production read-only credentials** by default.

### When to Use Production Database (DEFAULT)
- ✅ **User analytics**: "How many messages in the last day?"
- ✅ **Usage patterns**: "Any requests for codel/wren?"
- ✅ **Data investigation**: "What conversations exist?"
- ✅ **Debugging user issues**: "Why didn't user X get a message?"
Read the full skill on GitHub

Details

Skill name
sql-reader
Path
skills/sql-reader/SKILL.md
Repo updated
10 January 2026

FAQ

What does the SQL Reader skill do?

Query production PostgreSQL database with read-only credentials. Use for investigating data, debugging issues, or analyzing application state.

How do I install the SQL Reader skill?

Claude Code plugin: /plugin marketplace add Freddy-CHEN-ux/00_claude_skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is SQL Reader popular?

It lives in Freddy-CHEN-ux/00_claude_skills, which has 8 GitHub stars and 3 forks.

Related skills

Add Integration

8

Freddy-CHEN-ux/00_claude_skills

Build a new API integration for Nexus. Load when user mentions "add integration", "new integration", "integrate with", "connect to [service]", or "build [service] integration". Interactive workflow that discovers API endpoints, plans the integration, and creates a project for implementation.

Software Development

AI Agents

8

Freddy-CHEN-ux/00_claude_skills

Production-grade AI agent patterns with MCP integration, agentic RAG, handoff orchestration, multi-layer guardrails, and observability (modern best practices)

AI, LLMs & Agents

AI LLM

8

Freddy-CHEN-ux/00_claude_skills

Production LLM engineering skill. Covers strategy selection (prompting vs RAG vs fine-tuning), dataset design, PEFT/LoRA, evaluation workflows, deployment handoff to inference serving, and lifecycle operations with cost/safety controls.

AI, LLMs & Agents

Creator Intelligence

5

Dreydrey9000/claude-skills

Scrape, deconstruct, and database any Instagram creator or Viral Editz client's entire content strategy. Input = Instagram handle or client name. Output = full Notion database with deconstructed videos, hooks, scripts, frameworks, editing styles, performance data, Content Market Fit profile, and queryable intelligence. This is the BUSINESS tool for Viral Editz clients and creators — NOT for personal/dating intel (use ig-profile-scraper for that). Triggers: "deconstruct this creator", "add to creator database", "competitor analysis", "creator intelligence", "client database", "viral database",

Databases

Share Skill

8

Freddy-CHEN-ux/00_claude_skills

Push a local skill to the Notion skills database. Load when user mentions "share skill", "export skill", "push to notion", "add skill to database", or after creating a new skill with create-skill.

Databases

Azure Postgres Ts

5

lucaspmarie-a11y/claude-skills-vault

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.