Skip to main content
affpapa.org
RU EN
skill

nosql-expert — Claude Code skill: what it does, how to install

Guides query-first schema design for Cassandra and DynamoDB, helping developers pick optimal partition keys and avoid hot partitions under heavy traffic.

Install into Claude Code · claude-code-templates All methods and platforms ↓ 
npx claude-code-templates@latest --skill development/nosql-expert
Open on GitHub

What nosql-expert does

The skill shifts schema architecture toward query-first thinking. In distributed wide-column and key-value systems, tables cannot serve ad-hoc queries without penalty. Ad-hoc joins do not exist here. Everything depends on read patterns defined before writing code. It targets systems like Cassandra, ScyllaDB, and DynamoDB instead of standard SQL or document stores.

Guidance covers single-table layouts, composite primary keys, and secondary index behavior. It helps pick high-cardinality partition keys so write throughput spreads evenly across nodes. It also checks if a partition threatens to exceed 10GB. When partitions grow indefinitely, sharding by date prefixes becomes necessary.

Using ALLOW FILTERING in production Cassandra queries signals an architectural flaw because it triggers full cluster scans. The skill also highlights write costs: while inserts append quickly to LSM trees, frequent deletes generate harmful tombstones.

What it helps with

  • structure single-table schemas for Amazon DynamoDB
  • select high-cardinality partition keys to prevent hot nodes
  • map relational relationships into denormalized Cassandra tables
  • audit database schemas for unbounded partition growth

Example prompts for the agent

  • Design a DynamoDB single-table schema to store customer profiles alongside their orders
  • Inspect this Cassandra table design for hot partition risks and unbounded growth

How to install nosql-expert

1claude-code-templates

npx claude-code-templates@latest --skill development/nosql-expert

2Skills CLI (Vercel)

npx skills add davila7/claude-code-templates --skill nosql-expert -a claude-code

3Manually: put the files in place

~/.claude/skills/nosql-expert/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/nosql-expert/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about nosql-expert

How to install nosql-expert in Claude Code?

Run npx claude-code-templates@latest --skill development/nosql-expert in your terminal. You can also install it using npx skills add davila7/claude-code-templates --skill nosql-expert -a claude-code.

Why does this skill focus on query-first design?

Distributed NoSQL engines like Cassandra and DynamoDB do not support cost-effective runtime joins. Data models must directly reflect application read patterns, often duplicating records to preserve single-lookup speeds.

What is wrong with using ALLOW FILTERING in Cassandra?

It triggers an exhaustive scan across the entire cluster rather than querying indexed partitions directly. Needing this directive indicates that primary and clustering keys do not match actual read requirements.

Similar skills

All skills for Data and databases →
xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. 187,223installs google-agents-cli-observability official Google This skill guides you through tracing and monitoring AI agents, including ADK agents. Use it when you need to inspect agent execution or monitor a deployed agent. CX Codex +1 511,300installs caveman-evidence-review JuliusBrussee A read-only skill reviews Caveman Cloud evidence on LLM spend, traces, and routing. Use it to see where a project’s model budget goes. CX Codex +1 104,500installs migration JuliusBrussee Enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. CX Codex +1 103,900installs performance-optimization addyosmani An agent skill that measures before it changes code: Core Web Vitals budgets, N+1 queries, missing indexes and slow endpoints. CX Codex +1 65,200installs supabase official supabase Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs

From the same set804

The whole set →
seaborn Create statistical charts from datasets, from scatterplots to heatmaps and pair plots. Useful for exploratory analysis and figures prepared for publication. 68installs rag-chroma Reference patterns and code snippets for integrating the Chroma vector database, filtering metadata, and running semantic retrieval. 68installs gws-cloudidentity A slash command that sends Google Cloud Identity calls through the gws CLI: groups, memberships, devices, SSO profiles. Useful when admin work starts in the chat. 68installs exa-search Search by meaning, find related content, and run structured research through the Exa API. Use it when a keyword search does not match the task. 67installs emerging-techniques-model-pruning This skill walks through pruning language-model weights with Wanda, SparseGPT, and other methods. Use it to explore model compression without retraining. 67installs gws-workflow-email-to-task Turn a Gmail message into a Google Tasks entry, using its subject as the title and its snippet as a note. The command asks for confirmation before creating the task. 67installs gws-reseller This command runs Google Workspace Reseller operations through the gws CLI. Use it to handle customer accounts, subscription plans, licenses, and status changes. 67installs gws-people A Claude Code slash command that drives Google Workspace contacts and profiles through the gws CLI: create, search, update and delete records. 67installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor