db-specialized-fit

db-specialized-fit is a skill for Claude Code from Hainrixz/claude-db. It costs 134 tokens per session (1,560 once invoked), scanned A, original, MIT.

A review for databases designed for a specific job, such as storing vectors, time-series data, graphs, or search indexes.

In plain words
What is it for?
Use it to check embedding models and vector indexes, time-series partitions, graph structure, and search configuration for correctness and performance.
Why use it?
It catches configuration problems that a general database review can miss, such as mismatched vector dimensions or unsuitable search settings.

Skill for Claude Code

Written for Claude Code: allowed-tools in frontmatter.

Part of the claude-db plugin — 36 skills, 6 agents, 1 hook shipped together

Good fit Use it to check embedding models and vector indexes, time-series partitions, graph structure, and search configuration for correctness and performance.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/hainrixz/claude-db/db-specialized-fit
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add Hainrixz/claude-db --skill db-specialized-fit
Clone the repo
git clone --depth 1 https://github.com/Hainrixz/claude-db

Made for: Claude Code.

Or install claude-db, the plugin that ships this one along with the rest of its 36 skills, 6 agents, 1 hook.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for db-specialized-fit

README.md
[![agentmods](https://agentmods.dev/badge/skills/hainrixz/claude-db/db-specialized-fit/github.svg)](https://agentmods.dev/skills/hainrixz/claude-db/db-specialized-fit)
Your own site
<a href="https://agentmods.dev/skills/hainrixz/claude-db/db-specialized-fit"><img src="https://agentmods.dev/badge/skills/hainrixz/claude-db/db-specialized-fit/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for db-specialized-fit

Your own site · 80×15
<a href="https://agentmods.dev/skills/hainrixz/claude-db/db-specialized-fit"><img src="https://agentmods.dev/badge/skills/hainrixz/claude-db/db-specialized-fit.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 134 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,560 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00134 $0.01560
Opus 5 $0.00067 $0.00780
Sonnet 5 $0.00027 $0.00312
Haiku 4.5 $0.00013 $0.00156

Measured 12d ago against content hash 2e4945792e73, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-12, from the pricing page.

Security

Grade A, and why

db-specialized-fit scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 12d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/db-specialized-fit/SKILL.md · 82 lines

How it starts

The opening of the file, as written. The whole thing — 82 lines — stays where its author put it; the contents beside it link to each section on GitHub.

M20 covers purpose-built engines whose correctness depends on parameters a generic relational audit ignores. Sub-modules carry a letter (M20a..M20d); the scorer maps them to the parent M20 in the paradigm profile (Vector / Time-series / Graph categories in references/scoring-model.md).

M20a — Vector (pgvector, Qdrant, Pinecone, Weaviate)

Feeds: design (Métrica & dimensión, Modelo-version, Metadata/filtro) + performance (Índice & params, Búsqueda filtrada, Recall-vs-latencia).

  • Dimension match — column/collection dim equals the embedding model's output dim (e.g. vector(1536) for text-embedding-3-small). A mismatch is a hard bug (design, sev 5).
  • Distance metric match — the index metric (cosine / L2 / inner-product) matches how the model was trained; a mismatch silently wrecks recall. Sev-5 only when the model is declared in-repo; else directional and do not cap (per scoring-model honesty rule).
  • Index present & tuned — HNSW (m, ef_construction, ef_search) or IVFFlat (lists/probes) declared, not a brute-force seq scan on a large table (performance).
  • Model version captured — embeddings are tied to a model version so a re-embed is possible (design).
  • Filtered search — metadata used for pre/post-filtering is itself indexed (performance).

M20b — Time-series / OLAP (TimescaleDB, InfluxDB, ClickHouse)

Feeds: design (Hypertable-fit, Retención, Precisión-ts & tz) + performance (Chunk/retención, Continuous-agg, Compresión, Query).

  • Hypertable / partition fit — large append-only time data is a hypertable / partitioned by time, with a sane chunk interval (not one giant chunk, not millions of tiny ones).
  • Continuous aggregates / rollups declared for dashboard queries instead of scanning raw rows.
  • Compression / TTL retention policy present for cold chunks; raw retention bounded.
  • Timestamp precision & timezonetimestamptz/UTC, not naive local time (shares the M4 rule).

Read the full file on GitHub · 82 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 12d ago First seen · 82 lines · 134 tokens per session scan A 2e4945792e73

Subscribe to this mod's changes

db-specialized-fit is a skill published in the GitHub repository Hainrixz/claude-db (19 stars, last pushed 2mo ago), licensed MIT. It adds 134 tokens to every session and 1,560 once invoked, about $0.0007 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

dynamodb

Use when modeling or operating a DynamoDB table: deriving partition/sort keys from access patterns, single-table vs table-per-entity, adding a GSI/LSI, on-demand vs provisioned capacity, or diagnosing hot-partition throttling. NOT relational schema/SQL/EXPLAIN (that is postgresdb), NOT aggregation-pipeline document…

ericrisco/rsc-harness · 82 tokens

malloy-lookml-review

Analyze LookML files as prior art for Malloy modeling. Used during Step 1 (DISCOVER) when .lkml files are present. Coordinates reference files that extract business logic, relationships, and curation decisions. Works with or without a database connection.

malloydata/publisher · 58 tokens

convex-migrations

Schema migration strategies for evolving applications including adding new fields, backfilling data, removing deprecated fields, index migrations, and zero-downtime migration patterns.

waynesutton/convexskills · 35 tokens

database-design-patterns

Database schema design patterns and optimization strategies for relational and NoSQL databases. Use when designing database schemas, optimizing query performance, or implementing data persistence layers at scale.

NickCrew/Claude-Cortex · 37 tokens

database-sql

Design database schemas, write efficient SQL queries, create migrations, and optimize database performance. Use when working with databases, writing queries, or designing data models.

asgarovf/locusai · 35 tokens

data-design

Data modeling, schema design, and data architecture.

miles990/claude-software-skills · 12 tokens