Agent skill

Insforge Schema Patterns

by Microck in Microck/ordinary-claude-skills

Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies.

Custom licenceAuto-check passedDatabases

Install Insforge Schema Patterns

skills CLI
$ npx skills add Microck/ordinary-claude-skills --skill insforge-schema-patterns -a claude-code

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

GitHub CLI
$ gh skill install Microck/ordinary-claude-skills insforge-schema-patterns --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/Microck/ordinary-claude-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills_all/insforge-schema-patterns .claude/skills/insforge-schema-patterns && 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
insforge-schema-patterns
GitHub stars
401
Token cost
~1.9k tokens
SKILL.md length
193 words
Files
2
Skills in repo
97
Repo updated
First seen
Licence
Custom licence

At a glance

Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies.

  • Works in 7 steps: Always add indexes on foreign key… → Use UNIQUE constraints on junction… → Enable RLS on all user-facing tables → …
  • Designing data models with relationships
  • SKILL.md covers Pattern 1: Social Graph…, Pattern 2: Likes (Many-to-Many…, Pattern 3: Nested Comments… and Pattern 4: Multi-Tenant…, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Insforge Schema Patterns is an agent skill from Microck/ordinary-claude-skills. Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies. Use when designing data models with relationships, foreign keys, or Row Level Security.

Its SKILL.md is about 1.9k tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `metadata.json`).

It sits in Databases, covering Multi-tenancy, Database schema design and Social publishing and cross-posting. The repository describes itself as: An unappealing collection of Claude Skills and resources.

When your agent uses it

  • Designing data models with relationships
  • Row Level Security

Example prompts

  • “/insforge-schema-patterns”

Workflow steps

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

  1. Always add indexes on foreign key columns for performance
  2. Use UNIQUE constraints on junction tables to prevent duplicates
  3. Enable RLS on all user-facing tables
  4. Use ON DELETE CASCADE for automatic cleanup
  5. Foreign key expansion in SDK uses the syntax: table:column(fields)
  6. Count aggregations use: table(count)
  7. Filter nested tables with: nested_table!inner() for inner join behavior

What it can do on your machine

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

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are sql and javascript).

    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

Insforge Schema Patterns loads about 1.9k tokens when it runs. Until then it costs about 61 tokens; SKILL.md has 193 words of instructions outside code blocks.

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

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

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 193 words (~1,869 tokens).

“Expert patterns for designing PostgreSQL schemas optimized for InsForge's PostgREST backend.”

— opening of SKILL.md by Microck, Custom licence
name
insforge-schema-patterns

Read the full SKILL.md on GitHub

Files

SKILL.md and 1 other file in skills_all/insforge-schema-patterns of Microck/ordinary-claude-skills.

  • SKILL.md
  • metadata.json

Open the folder on GitHubat commit 1056d29

Compare with similar skills

Insforge Schema Patterns 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.

Insforge Schema Patterns compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Insforge Schema Patterns this skillMicrock/ordinary-claude-skills401—~1.9kAutomated safety check: PassCustom licence
Convex CoreIgorWarzocha/Opencode-Workflows122—~1.3kAutomated safety check: PassNone
Database ArchitectFerroxLabs/wayland608—~4kAutomated safety check: PassApache-2.0
Replicate Video AdJingyi-Wu-Richael/replicate-video-ad1061 repos~1.6kAutomated safety check: PassNone
Ecto Persistence Patternsgeorgeguimaraes/elixir-agent-tools184—~1.2kAutomated safety check: PassApache-2.0
Mas SkillsAUTO-MAS-Project/AUTO-MAS707—~3.6kAutomated safety check: PassAGPL-3.0

Similar skills

  • Convex Core

    IgorWarzocha/Opencode-Workflows

    Build Convex schemas, queries, mutations, actions, and client usage with strict validators and indexes.

    122 GitHub stars~1.3k tokensUpdated 8 mo ago
    DatabasesAuto-check passed
  • Database Architect

    FerroxLabs/wayland

    Database schema design expertise covering normalization, denormalization strategies, indexing, query optimization, partitioning, connection pooling, migration management, multi-tenancy patterns, and…

    608 GitHub stars~4k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Replicate Video Ad

    Jingyi-Wu-Richael/replicate-video-ad

    Analyze a reference video frame by frame and turn its visual grammar, story beats, dialogue, product reveal, proof sequence, and conversion structure into a production-ready ecommerce story-ad…

    106 GitHub starsUsed in 1 repo~1.6k tokens
    DatabasesAuto-check passed
  • Ecto Persistence Patterns

    georgeguimaraes/elixir-agent-tools

    Designs and debugs Elixir persistence with Ecto: schemas, changesets, queries, preloads, migrations and multi-tenancy, kept within application contexts.

    184 GitHub stars~1.2k tokensUpdated 18 days ago
    Backend & APIsAuto-check passed
  • Mas Skills

    AUTO-MAS-Project/AUTO-MAS

    A skill your agent uses when a task needs AUTO-MAS engineering conventions across frontend, UI, code style, schema naming, module boundaries, function design, API contracts, data modeling, script…

    707 GitHub stars~3.6k tokensUpdated today
    DatabasesAuto-check passed
  • Qdrant Multitenancy

    qdrant/skills

    Official

    Guides tenant isolation architecture in Qdrant for multi-tenant or multi-user applications.

    253 GitHub stars~1.6k tokensUpdated yesterday
    DatabasesAuto-check passed

More from Microck/ordinary-claude-skills

All 97 skills in this repo
  • Every Style Editor

    Microck/ordinary-claude-skills

    This skill should be used when reviewing or editing copy to ensure adherence to Every's style guide.

    401 GitHub starsUsed in 3 repos~1.2k tokens
    Auto-check passed
  • Gemini Imagegen

    Microck/ordinary-claude-skills

    Generate and edit images using the Gemini API (Nano Banana Pro).

    401 GitHub starsUsed in 3 repos~1.6k tokens
    Auto-check passed
  • Andrew Kane Gem Writer

    Microck/ordinary-claude-skills

    Write Ruby gems following Andrew Kane's proven patterns and philosophy.

    401 GitHub starsUsed in 2 repos~1.2k tokens
    Auto-check passed
  • Codex

    Microck/ordinary-claude-skills

    Execute Codex CLI for code analysis, refactoring, and automated code changes.

    401 GitHub starsUsed in 2 repos~2.8k tokens
    Auto-check passed
  • Docs Review

    Microck/ordinary-claude-skills

    Review documentation changes for compliance with the Metabase writing style guide.

    401 GitHub starsUsed in 2 repos~1.8k tokens
    Auto-check: notes
  • File Todos

    Microck/ordinary-claude-skills

    This skill should be used when managing the file-based todo tracking system in the todos/ directory.

    401 GitHub starsUsed in 2 repos~1.9k tokens
    Auto-check passed

Questions about Insforge Schema Patterns

What does Insforge Schema Patterns do?

Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies. Insforge Schema Patterns is an agent skill from Microck/ordinary-claude-skills. Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies.

When should I use Insforge Schema Patterns?

Insforge Schema Patterns fits situations like: designing data models with relationships; row Level Security.

How do I install Insforge Schema Patterns in Claude Code?

Run `npx skills add Microck/ordinary-claude-skills --skill insforge-schema-patterns -a claude-code`. Or copy the skill folder (skills_all/insforge-schema-patterns in Microck/ordinary-claude-skills) into .claude/skills/insforge-schema-patterns in your project. Claude Code loads it when a task matches its description.

How do I install Insforge Schema Patterns in Codex?

Run `npx skills add Microck/ordinary-claude-skills --skill insforge-schema-patterns -a codex`. Or copy the skill folder (skills_all/insforge-schema-patterns in Microck/ordinary-claude-skills) into .agents/skills/insforge-schema-patterns in your project. Codex loads it when a task matches its description.

Can I use Insforge Schema Patterns 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 Microck/ordinary-claude-skills --skill insforge-schema-patterns -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/insforge-schema-patterns, .gemini/skills/insforge-schema-patterns, .github/skills/insforge-schema-patterns and .opencode/skills/insforge-schema-patterns in your project.

What does Insforge Schema Patterns need to run?

SKILL.md names no scripts, command-line tools or credentials: Insforge Schema Patterns is instructions for the agent only.

Does Insforge Schema Patterns 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 Insforge Schema Patterns 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 Insforge Schema Patterns use?

Insforge Schema Patterns has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Insforge Schema Patterns use?

About 1.9k tokens (SKILL.md is roughly 7.5k 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 Insforge Schema Patterns?

Skills that share tags, products or a category with Insforge Schema Patterns: Convex Core (IgorWarzocha/Opencode-Workflows, 122 stars), Database Architect (FerroxLabs/wayland, 608 stars), Replicate Video Ad (Jingyi-Wu-Richael/replicate-video-ad, 106 stars) and Ecto Persistence Patterns (georgeguimaraes/elixir-agent-tools, 184 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Insforge Schema Patterns?

Microck (a GitHub user) maintains it in Microck/ordinary-claude-skills, which has 401 GitHub stars. The repository holds 97 skills in this directory. The repository was last updated on September 6, 2026.

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