Agent skill

Database Schema Designer

by jeremylongshore in jeremylongshore/tons-of-skills-marketplace

Build database schema designer operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

MITAuto-check passedDatabases

Install Database Schema Designer

skills CLI
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill database-schema-designer -a claude-code

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

GitHub CLI
$ gh skill install jeremylongshore/tons-of-skills-marketplace database-schema-designer --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/skills/06-backend-dev/database-schema-designer .claude/skills/database-schema-designer && 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
database-schema-designer
GitHub stars
2.8k
Token cost
~585 tokens
SKILL.md length
196 words
Files
1
Skills in repo
3,342
Repo updated
First seen
Licence
MIT

At a glance

Build database schema designer operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

  • Works in 4 steps: Provides step-by-step guidance for… → Follows industry best practices and… → Generates production-ready code and… → …
  • : database schema designer
  • SKILL.md covers Overview, When to Use, Instructions and Examples, plus 5 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Database Schema Designer is an agent skill from jeremylongshore/tons-of-skills-marketplace. Build database schema designer operations. Auto-activating skill for Backend Development. Triggers on: database schema designer, database schema designer Part of the Backend Development skill category. Use when working with database schema designer functionality. Trigger with phrases like "database schema designer", "database designer", "database".

Its SKILL.md is about 590 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts. Compatibility notes: Designed for Claude Code

It sits in Databases, covering Database schema design and Backend development. 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

  • : database schema designer
  • Database schema designer Part of the Backend Development skill category
  • Working with database schema designer functionality
  • With phrases like database schema designer

Example prompts

  • “database schema designer”
  • “database designer”
  • “database”
  • “/database-schema-designer”

Requirements

  • Node.js
  • Compatibility (from SKILL.md): Designed for Claude Code
  • Pre-approved tools (allowed-tools): Read, Write, Edit, Bash(cmd:*), Grep

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

  1. Provides step-by-step guidance for database schema designer
  2. Follows industry best practices and patterns
  3. Generates production-ready code and configurations
  4. Validates outputs against common standards

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
    • Write
    • Edit
    • Bash(cmd:*)
    • Grep

    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.

  • Compatibility

    Designed for Claude Code

    From compatibility in the SKILL.md frontmatter.

Context cost

Database Schema Designer loads about 585 tokens when it runs. Until then it costs about 94 tokens; SKILL.md has 196 words of instructions outside code blocks.

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

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 passed

The automated check found no risky patterns in SKILL.md.

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). 196 words, ~585 tokens.

Download SKILL.mdSave it as .claude/skills/database-schema-designer/SKILL.md (or your agent's skills folder).
name
database-schema-designer
description
Build database schema designer operations. Auto-activating skill for Backend Development. Triggers on: database schema designer, database schema designer Part of the Backend Development skill category. Use when working with database schema designer functionality. Trigger with phrases like "database schema designer", "database designer", "database".
allowed-tools
Read, Write, Edit, Bash(cmd:*), Grep
compatibility
Designed for Claude Code
version
1.0.0
license
MIT
author
Jeremy Longshore <jeremy@intentsolutions.io>
tags
backend, development

Database Schema Designer

Overview

This skill provides automated assistance for database schema designer tasks within the Backend Development domain.

When to Use

This skill activates automatically when you:

  • Mention "database schema designer" in your request
  • Ask about database schema designer patterns or best practices
  • Need help with backend skills covering node.js, python, go, database design, caching, messaging, and microservices architecture.

Instructions

  1. Provides step-by-step guidance for database schema designer
  2. Follows industry best practices and patterns
  3. Generates production-ready code and configurations
  4. Validates outputs against common standards

Examples

Example: Basic Usage Request: "Help me with database schema designer" Result: Provides step-by-step guidance and generates appropriate configurations

Prerequisites

  • Relevant development environment configured
  • Access to necessary tools and services
  • Basic understanding of backend development concepts

Output

  • Generated configurations and code
  • Best practice recommendations
  • Validation results

Error Handling

ErrorCauseSolution
Configuration invalidMissing required fieldsCheck documentation for required parameters
Tool not foundDependency not installedInstall required tools per prerequisites
Permission deniedInsufficient accessVerify credentials and permissions

Resources

  • Official documentation for related tools
  • Best practices guides
  • Community examples and tutorials

Part of the Backend Development skill category. Tags: nodejs, python, go, microservices, database

© 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

Just SKILL.md in skills/06-backend-dev/database-schema-designer of jeremylongshore/tons-of-skills-marketplace.

Open the folder on GitHubat commit cfae287

Compare with similar skills

Database Schema Designer 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.

Database Schema Designer compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Database Schema Designer this skilljeremylongshore/tons-of-skills-marketplace2.8k—~585Automated safety check: PassMIT
BackendAlexPEClub/ai-coding-starter-kit382—~992Automated safety check: PassNone
Database Migrationagulli/atlas-agents579—~702Automated safety check: PassMIT
Jpa Patternsaffaan-m/ECC276k5 repos~1.2kAutomated safety check: PassMIT
Safe Database Migration Patternsaffaan-m/ECC276k—~3.3kAutomated safety check: PassMIT
Backend DevelopmentMoizIbnYousaf/ai-agent-skills1.1k—~853Automated safety check: PassMIT

Similar skills

  • Backend

    AlexPEClub/ai-coding-starter-kit

    Build APIs, database schemas, and server-side logic with Supabase.

    382 GitHub stars~992 tokensUpdated 4 mo ago
    DatabasesAuto-check passed
  • Database Migration

    agulli/atlas-agents

    Safely run database schema migrations. An agent skill from agulli/atlas-agents.

    579 GitHub stars~702 tokensUpdated 2 mo ago
    DatabasesAuto-check passed
  • Jpa Patterns

    affaan-m/ECC

    JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

    276k GitHub starsUsed in 5 repos~1.2k tokens
    DatabasesAuto-check passed
  • Rules and examples for safe, reversible schema changes in production: zero-downtime column and index changes, large data backfills and ORM migration workflows.

    276k GitHub stars~3.3k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Backend Development

    MoizIbnYousaf/ai-agent-skills

    Backend API design, database architecture, microservices patterns, and test-driven development.

    1.1k GitHub stars~853 tokensUpdated 19 days ago
    Backend & APIsAuto-check passed
  • Moai Ref API Patterns

    modu-ai/moai-adk

    REST/GraphQL API design patterns, error handling conventions, and input validation reference for backend development.

    1.2k GitHub stars~1.9k tokensUpdated yesterday
    Backend & APIsAuto-check passed

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 yesterday
    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 yesterday
    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 yesterday
    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 yesterday
    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 yesterday
    Auto-check passed

Questions about Database Schema Designer

What does Database Schema Designer do?

Build database schema designer operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. Database Schema Designer is an agent skill from jeremylongshore/tons-of-skills-marketplace. Build database schema designer operations.

When should I use Database Schema Designer?

Database Schema Designer fits situations like: : database schema designer; database schema designer Part of the Backend Development skill category; working with database schema designer functionality; with phrases like database schema designer.

How do I install Database Schema Designer in Claude Code?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill database-schema-designer -a claude-code`. Or copy the skill folder (skills/06-backend-dev/database-schema-designer in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/database-schema-designer in your project. Claude Code loads it when a task matches its description.

How do I install Database Schema Designer in Codex?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill database-schema-designer -a codex`. Or copy the skill folder (skills/06-backend-dev/database-schema-designer in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/database-schema-designer in your project. Codex loads it when a task matches its description.

Can I use Database Schema Designer 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 database-schema-designer -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-schema-designer, .gemini/skills/database-schema-designer, .github/skills/database-schema-designer and .opencode/skills/database-schema-designer in your project.

What does Database Schema Designer need to run?

SKILL.md names no scripts, command-line tools or credentials: Database Schema Designer is instructions for the agent only. Our summary lists: Node.js. Its frontmatter pre-approves these tools: Read, Write, Edit, Bash(cmd:*), Grep. Compatibility (from SKILL.md): Designed for Claude Code.

Does Database Schema Designer 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 Database Schema Designer safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Database Schema Designer use?

Database Schema Designer 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 Database Schema Designer use?

About 585 tokens (SKILL.md is roughly 2.3k 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 Database Schema Designer?

Skills that share tags, products or a category with Database Schema Designer: Backend (AlexPEClub/ai-coding-starter-kit, 382 stars), Database Migration (agulli/atlas-agents, 579 stars), Jpa Patterns (affaan-m/ECC, 276k stars) and Safe Database Migration Patterns (affaan-m/ECC, 276k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Database Schema Designer?

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.