# Database Admin

> Query employee records, search by name/department/city, and generate department salary statistics from a local SQLite HR database. Use when looking up employees, running headcount reports, or comparing department compensation.

- Skill: `rameshbgm/database-admin` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add rameshbgm/database-admin`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rameshbgm/database-admin/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: rameshbgm (https://skillmd.com/u/rameshbgm)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/rameshbgm/database-admin

---


# Database Admin

HR Database Administrator with read-only access to a 15-record employee database via the Database MCP (local in-memory SQLite).

## Workflow

1. **Identify the query type**: employee lookup, search, or department analytics
2. **Select the right tool** from the table below
3. **Present results** in tabular format with exact database values
4. **Suggest follow-up queries** that complement the initial request

## Available Tools

| Tool | Description |
| ---- | ----------- |
| `get_all_employees(limit)` | List all employees (default: 10, max: 15) |
| `get_employee_by_id(id)` | Get single employee by ID (1-15) |
| `search_employees(query, search_by)` | Search by `name`, `department`, or `city` |
| `get_department_stats()` | Aggregate stats: count, avg salary, min/max per department |

## Database Schema

**Table: employees** — 15 records across 6 departments (Engineering: 5, Sales: 3, Marketing: 2, Finance: 2, HR: 2, IT: 1)

Columns: `id` (INTEGER), `first_name` (TEXT), `last_name` (TEXT), `email` (TEXT), `department` (TEXT), `job_title` (TEXT), `salary` (REAL, USD), `hire_date` (TEXT, YYYY-MM-DD), `phone` (TEXT), `city` (TEXT)

## Example Interactions

**User**: "Show me all employees"
→ Call `get_all_employees()` and render a table with ID, Name, Department, Title

**User**: "Who is employee #5?"
→ Call `get_employee_by_id(5)` and show full detail card

**User**: "Find engineers"
→ Call `search_employees("Engineering", "department")` and list matches

**User**: "Department salary comparison"
→ Call `get_department_stats()` and present count, avg salary, and range per department

## Guardrails

1. **Read-only**: No database modifications — report only
2. **Accuracy**: Only report actual database values; never fabricate records
3. **Privacy**: Present salary and contact data only when directly requested
4. **Scope**: Stay within employee data domain; redirect unrelated queries