Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns.

MITAuto-check: notesDatabases

Install Flux Recon

skills CLI
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-recon -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install jeremylongshore/tons-of-skills-marketplace flux-recon --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/flux-recon .claude/skills/flux-recon && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
flux-recon
GitHub stars
2.8k
Token cost
~916 tokens
SKILL.md length
351 words
Files
2
Skills in repo
3,342
Repo updated
First seen
Licence
MIT

At a glance

Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns.

  • Works in 6 steps: Detect Environment → Analyze Schema → Analyze Migration History → …
  • Asked to assess this database
  • SKILL.md covers Steps and Delivery
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Flux Recon is an agent skill from jeremylongshore/tons-of-skills-marketplace. Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns. Use when asked to "assess this database", "understand the schema", or "database health check".

Its SKILL.md is about 920 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `.claude-plugin/plugin.json`).

It sits in Databases, covering Database administration, Backup and disaster recovery and Database migrations. The repository describes itself as: Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com. The licence is MIT.

When your agent uses it

  • Asked to assess this database
  • Understand the schema
  • Database health check

Example prompts

  • “assess this database”
  • “understand the schema”
  • “database health check”
  • “/flux-recon”

Requirements

  • Pre-approved tools (allowed-tools): Read, Bash, Glob, Grep, WebFetch, WebSearch, AskUserQuestion

Workflow steps

6 steps, taken from the step headings in SKILL.md.

  1. Detect Environment
  2. Analyze Schema
  3. Analyze Migration History
  4. Assess Operational Health
  5. Analyze Query Patterns
  6. Present Inventory

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Read
    • Bash
    • Glob
    • Grep
    • WebFetch
    • WebSearch
    • AskUserQuestion

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Flux Recon loads about 916 tokens when it runs. Until then it costs about 58 tokens; SKILL.md has 351 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~58
When it runs · the whole SKILL.md, loaded when a task matches
~916

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteMentions a .env fileSKILL.md:23
    - Check for connection strings in `.env`, `database.yml`, `settings.py`, `config/`
  • NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
    allowed-tools: Read, Bash, Glob, Grep, WebFetch, WebSearch, AskUserQuestion

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 351 words, ~916 tokens.

Download SKILL.mdSave it as .claude/skills/flux-recon/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
flux-recon
description
Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns. Use when asked to "assess this database", "understand the schema", or "database health check".
allowed-tools
Read, Bash, Glob, Grep, WebFetch, WebSearch, AskUserQuestion
version
0.6.4
author
tonone-ai <hello@tonone.ai>
license
MIT

Database Reconnaissance

You are Flux — the data engineer on the Engineering Team.

Follow the output format defined in docs/output-kit.md — 40-line CLI max, box-drawing skeleton, unified severity indicators, compressed prose.

Steps

Step 0: Detect Environment

Identify all database-related components:

  • Check for ORM configs: prisma/schema.prisma, alembic.ini, drizzle.config.ts, ormconfig.ts, knexfile.js
  • Check for connection strings in .env, database.yml, settings.py, config/
  • Check for migration directories and their contents
  • Check for multiple databases (primary, read replica, analytics, cache)
  • Identify the database engine(s) and hosting (self-managed, Cloud SQL, RDS, managed service)

If the stack is ambiguous, ask the user.

Step 1: Analyze Schema

Map the full schema:

  • Tables/collections — list all with column counts and primary key types
  • Relationships — foreign keys, join tables, embedded references
  • Indexes — what exists, what is missing (especially on FKs and common query columns)
  • Constraints — NOT NULL, UNIQUE, CHECK, DEFAULT values
  • Types — any unusual type choices (TEXT for UUIDs, VARCHAR(255) everywhere, etc.)
Step 2: Analyze Migration History

Review the migration directory:

  • Total migrations — how many, over what time period?
  • Recent activity — when was the last migration? How frequent are changes?
  • Failed migrations — any migrations that were partially applied or rolled back?
  • Migration quality — are they reversible? Do they use safe patterns?
  • Naming conventions — consistent or chaotic?
Show full SKILL.md (149 more words)Show less
Step 3: Assess Operational Health

Check infrastructure and operational aspects:

  • Data volume — estimate rows per table from code hints, migration data, or direct queries
  • Backup status — is there a backup strategy? Automated? Tested?
  • Connection pooling — is it configured? What tool (PgBouncer, built-in pool, ORM pool)?
  • Replication — read replicas? Failover configured?
  • Monitoring — any database monitoring in place?
Step 4: Analyze Query Patterns

Read through the application code to understand how the database is used:

  • ORM queries — what patterns dominate? Any N+1 risks?
  • Raw SQL — any complex queries? Stored procedures?
  • Transaction patterns — how are transactions scoped? Any long-running transactions?
  • Read/write ratio — is this read-heavy, write-heavy, or balanced?
Step 5: Present Inventory
## Database Reconnaissance

### Overview
| Property | Value |
|---|---|
| Engine | [database] |
| Hosting | [managed/self-hosted] |
| Tables | [count] |
| Migrations | [count] over [time period] |
| Last Migration | [date] |

### Schema Map
[table list with relationships]

### Risk Flags
- [flag] — [severity] — [recommendation]

### Missing
- [ ] [thing that should exist but doesn't]

### Strengths
- [positive observation]

### Recommended Actions (priority order)
1. [action] — [effort] — [impact]

Delivery

If output exceeds the 40-line CLI budget, invoke /atlas-report with the full findings. The HTML report is the output. CLI is the receipt — box header, one-line verdict, top 3 findings, and the report path. Never dump analysis to CLI.

© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file in plugins/ai-agency/tonone/skills/flux-recon of jeremylongshore/tons-of-skills-marketplace.

  • SKILL.md
  • .claude-plugin/plugin.json

Open the folder on GitHubat commit cfae287

Compare with similar skills

Flux Recon next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Flux Recon compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Flux Recon this skilljeremylongshore/tons-of-skills-marketplace2.8k—~916Automated safety check: NotesMIT
DB AdminEliasOulkadi/shokunin114—~2kAutomated safety check: NotesMIT
Database Migration Service Expertiseaws/tools-for-devops-agent103—~3.4kAutomated safety check: PassApache-2.0
Mongodbsickn33/agentic-awesome-skills47k2 repos~2.7kAutomated safety check: NotesMIT
Postgresql OperationsHack23/cia239—~467Automated safety check: PassApache-2.0
Replication Guidechmonitor/chmonitor300—~555Automated safety check: PassGPL-3.0

Similar skills

  • DB Admin

    EliasOulkadi/shokunin

    PostgreSQL database administration — backup/restore (pgdump, PITR, WAL archiving), health monitoring (connections, bloat, cache hit ratio, dead tuples), connection pooling (PgBouncer), replication…

    114 GitHub stars~2k tokensUpdated 6 days ago
    DatabasesAuto-check: notes
  • Database Migration Service Expertise

    aws/tools-for-devops-agent

    Official

    AWS Database Migration Service (DMS) operational review and troubleshooting skill.

    103 GitHub stars~3.4k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Mongodb

    sickn33/agentic-awesome-skills

    Administer MongoDB databases. An agent skill from sickn33/agentic-awesome-skills.

    47k GitHub starsUsed in 2 repos~2.7k tokens
    DatabasesAuto-check: notes
  • Manage PostgreSQL: schema migrations, performance tuning, backups, monitoring per README-SCHEMA-MAINTENANCE.md

    239 GitHub stars~467 tokensUpdated yesterday
    DatabasesAuto-check passed
  • Replication Guide

    chmonitor/chmonitor

    ReplicatedMergeTree operations, failover procedures, lag diagnosis, quorum writes, and Keeper management.

    300 GitHub stars~555 tokensUpdated 5 days ago
    DatabasesAuto-check passed
  • Database Backups

    sickn33/agentic-awesome-skills

    Implement database backup strategies. An agent skill from sickn33/agentic-awesome-skills.

    47k GitHub starsUsed in 2 repos~3.1k tokens
    DatabasesAuto-check: notes

More from jeremylongshore/tons-of-skills-marketplace

All 3,342 skills in this repo
  • Performing Security Code Review

    jeremylongshore/tons-of-skills-marketplace

    Execute this skill enables AI assistant to conduct a security-focused code review using the security-agent plugin.

    2.8k GitHub starsUsed in 2 repos~1.3k tokens
    Auto-check: notes
  • Adapting Transfer Learning Models

    jeremylongshore/tons-of-skills-marketplace

    Build this skill automates the adaptation of pre-trained machine learning models using transfer learning techniques.

    2.8k GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Agent Context Loader

    jeremylongshore/tons-of-skills-marketplace

    Execute proactive auto-loading: automatically detects and loads agents.md files.

    2.8k GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Aggregating Performance Metrics

    jeremylongshore/tons-of-skills-marketplace

    Aggregate and centralize performance metrics from applications, systems, databases, caches, and services.

    2.8k GitHub stars~1.2k tokensUpdated today
    Auto-check passed
  • Analyzing Capacity Planning

    jeremylongshore/tons-of-skills-marketplace

    Execute this skill enables AI assistant to analyze capacity requirements and plan for future growth.

    2.8k GitHub stars~947 tokensUpdated today
    Auto-check passed
  • Analyzing Database Indexes

    jeremylongshore/tons-of-skills-marketplace

    Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace.

    2.8k GitHub stars~2k tokensUpdated today
    Auto-check passed

Categories

Questions about Flux Recon

What does Flux Recon do?

Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns. Flux Recon is an agent skill from jeremylongshore/tons-of-skills-marketplace. Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns.

When should I use Flux Recon?

Flux Recon fits situations like: asked to assess this database; understand the schema; database health check.

How do I install Flux Recon in Claude Code?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-recon -a claude-code`. Or copy the skill folder (plugins/ai-agency/tonone/skills/flux-recon in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/flux-recon in your project. Claude Code loads it when a task matches its description.

How do I install Flux Recon in Codex?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-recon -a codex`. Or copy the skill folder (plugins/ai-agency/tonone/skills/flux-recon in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/flux-recon in your project. Codex loads it when a task matches its description.

Can I use Flux Recon in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-recon -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/flux-recon, .gemini/skills/flux-recon, .github/skills/flux-recon and .opencode/skills/flux-recon in your project.

What does Flux Recon need to run?

SKILL.md names no scripts, command-line tools or credentials: Flux Recon is instructions for the agent only. Its frontmatter pre-approves these tools: Read, Bash, Glob, Grep, WebFetch, WebSearch, AskUserQuestion.

Does Flux Recon access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Flux Recon safe to install?

Our automated static check of SKILL.md found notes only (mentions a .env file; pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Flux Recon use?

Flux Recon is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Flux Recon use?

About 916 tokens (SKILL.md is roughly 3.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Flux Recon?

Skills that share tags, products or a category with Flux Recon: DB Admin (EliasOulkadi/shokunin, 114 stars), Database Migration Service Expertise (aws/tools-for-devops-agent, 103 stars), Mongodb (sickn33/agentic-awesome-skills, 47k stars) and Postgresql Operations (Hack23/cia, 239 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Flux Recon?

jeremylongshore (a GitHub user) maintains it in jeremylongshore/tons-of-skills-marketplace, which has 2,827 GitHub stars. The repository holds 3,342 skills in this directory. The repository was last updated on October 10, 2026.

Source: jeremylongshore/tons-of-skills-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.