Gameplay SQL

Test game mechanics via SQL. Use game_* tools for gameplay flow.

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 gameplay-sql
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/gameplay-sql ~/.claude/skills/gameplay-sql

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 Gameplay

Test the game through database tools.

> **Announce:** "I'm using gameplay-sql to test via database."

## Game Tools

| Tool | Purpose |
|------|---------|
| `game_start` | Start a new game |
| `game_state` | See current question/guess/candidates |
| `game_turn` | Answer yes/no/not_sure |
| `game_submit` | Submit correct place (give up) |
| `game_find_place` | Search places by name |
| `game_summary` | Review completed session (history + result) |

## Complete Game Flow

### 1. Start a Game

```
game_start(description: "A medieval castle on a hilltop in Poland")
```

Returns: session_id, initial question, top candidates

### 2. Check State (optional)

```
game_state(session_id: "abc123...")
```

Returns: current status, question or guess, top candidates

### 3. Answer Questions

```
game_turn(session_id: "abc123...", answer: "yes")
game_turn(session_id: "abc123...", answer: "no")
game_turn(session_id: "abc123...", answer: "not_sure")
```

Returns: new state after answer

### 4a. If Game Guesses Correctly

```
game_turn(session_id: "abc123...", answer: "yes")
```

Game ends with status: won

### 4b. If Game Gives Up or Guesses Wrong

First, find the correct place:
```
game_find_place(name: "Wawel")
```

Then submit it:
```
game_submit(session_id: "abc123...", osm_id: "way/123456")
```

## Example Session
Read the full skill on GitHub

Details

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

FAQ

What does the Gameplay SQL skill do?

Test game mechanics via SQL. Use game_* tools for gameplay flow.

How do I install the Gameplay SQL 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 Gameplay SQL 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

Postgres Vectors

8

Freddy-CHEN-ux/00_claude_skills

Use when working with embeddings, semantic similarity, vector search, or the <-> <#> <=> operators. Load for pgvector queries, HNSW index creation, embedding storage, or similarity calculations. Covers distance operators, index strategies, and common pitfalls with 384-dimensional vectors.

Databases

Database First

8

Freddy-CHEN-ux/00_claude_skills

REQUIRED before implementing any game feature, scoring logic, state transition, or decision-making. ALL business logic lives in PostgreSQL - frontend is presentation only. Load this to understand where code belongs: database function vs component. Covers RPC patterns, SECURITY DEFINER, and anti-patterns.

Databases

Search Skill Database

8

Freddy-CHEN-ux/00_claude_skills

Query ALL available Skills database in Notion with filters. Load when user mentions "search skill database", "query notion", "search skills database", "find skills in notion", or "browse notion skills".

Databases

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