Agent skill

Remove SQL Fields

by microbus-io in microbus-io/fabric

TRIGGER when user asks to remove, drop, or delete fields, properties, or columns from a SQL CRUD microservice's object.

Apache-2.0Auto-check passedBackend & APIs

Install Remove SQL Fields

skills CLI
$ npx skills add microbus-io/fabric --skill remove-sql-fields -a claude-code

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

GitHub CLI
$ gh skill install microbus-io/fabric remove-sql-fields --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/microbus-io/fabric.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/sequel/remove-sql-fields .claude/skills/remove-sql-fields && 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
remove-sql-fields
GitHub stars
172
Token cost
~1.1k tokens
SKILL.md length
425 words
Files
1
Skills in repo
32
Repo updated
First seen
Licence
Apache-2.0

At a glance

TRIGGER when user asks to remove, drop, or delete fields, properties, or columns from a SQL CRUD microservice's object.

  • Works in 8 steps: Read Local CLAUDE.md File → Update the Type Definition of the Object → Update the Type Definition of the Query → …
  • User asks to remove
  • Calls go
  • Columns from a SQL CRUD microservices object

What it does

Remove SQL Fields is an agent skill from microbus-io/fabric. TRIGGER when user asks to remove, drop, or delete fields, properties, or columns from a SQL CRUD microservice's object.

Its SKILL.md is about 1.1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Backend & APIs, covering SQL and Microservices. It works with SQL. The repository describes itself as: Microbus is the only fabric where every agentic workflow runs on a true microservice substrate - giving your workflows security, scale, observability, and prompt-driven authoring. The licence is Apache-2.0.

When your agent uses it

  • User asks to remove
  • Columns from a SQL CRUD microservices object

Example prompts

  • “/remove-sql-fields”

Workflow steps

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

  1. Read Local CLAUDE.md File
  2. Update the Type Definition of the Object
  3. Update the Type Definition of the Query
  4. Update Database Schema
  5. Remove Mappings of Column Names to Object Fields
  6. Remove Query Conditions
  7. Update Integration Tests
  8. Housekeeping

What it can do on your machine

Read from SKILL.md and the folder at commit fb98098. 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

    Shell commands in SKILL.md call:

    • go

    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

Remove SQL Fields loads about 1.1k tokens when it runs. Until then it costs about 34 tokens; SKILL.md has 425 words of instructions outside code blocks.

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

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 microbus-io/fabric at commit fb98098, republished under its Apache-2.0 licence (© microbus-io). 425 words, ~1,138 tokens.

Download SKILL.mdSave it as .claude/skills/remove-sql-fields/SKILL.md (or your agent's skills folder).
name
remove-sql-fields
description
TRIGGER when user asks to remove, drop, or delete fields, properties, or columns from a SQL CRUD microservice's object.

CRITICAL: Read and analyze this microservice before starting. Do NOT explore or analyze other microservices unless explicitly instructed to do so. The instructions in this skill are self-contained to this microservice.

IMPORTANT: MyNoun, MyNounKey, mynoun, and mynounapi are placeholders for the actual object, its key, directory, and API package of the microservice.

Workflow

Copy this checklist and track your progress:

Removing fields of the object:
- [ ] Step 1: Read Local CLAUDE.md File
- [ ] Step 2: Update the Type Definition of the Object
- [ ] Step 3: Update the Type Definition of the Query
- [ ] Step 4: Update Database Schema
- [ ] Step 5: Remove Mappings of Column Names to Object Fields
- [ ] Step 6: Remove Query Conditions
- [ ] Step 7: Update Integration Tests
- [ ] Step 8: Housekeeping
Step 1: Read Local CLAUDE.md File

Read the local CLAUDE.md file in the microservice's directory. It contains microservice-specific instructions that should take precedence over global instructions.

Step 2: Update the Type Definition of the Object

Find the type definition of the object in mynounapi/object.go. Remove the appropriate fields from the type definition of the struct. Remove the field's dv8 tags and any irrelevant code from the object's Validate method. Clean up any unused imports.

Step 3: Update the Type Definition of the Query

Find the type definition of the query in mynounapi/query.go. Remove the appropriate fields from the type definition of the struct. Remove the field's dv8 tags and any irrelevant code from the query's Validate method. Clean up any unused imports.

Step 4: Update Database Schema

Create a new migration script file in resources/sql with an incremental file name. IMPORTANT: Do not edit an existing migration file.

Refer to the older .sql migration files to identify what if any constraints were associated with the deprecated columns. Use ALTER TABLE statements to drop these constraints, if applicable.

sql
-- DRIVER: mysql
ALTER TABLE my_table DROP CONSTRAINT my_table_constraint_name;

-- DRIVER: pgx
ALTER TABLE my_table DROP CONSTRAINT my_table_constraint_name;

-- DRIVER: mssql
ALTER TABLE my_table DROP CONSTRAINT my_table_constraint_name;

Refer to the older .sql migration files to identify what if any indices were associated with the deprecated columns. Use DROP INDEX statements to drop these indices, if applicable.

sql
-- DRIVER: mysql
DROP INDEX my_table_idx_deprecated_field ON my_table;

-- DRIVER: pgx
DROP INDEX my_table_idx_deprecated_field;

-- DRIVER: mssql
DROP INDEX my_table_idx_deprecated_field ON my_table;

Append ALTER TABLE statements to drop the columns.

sql
-- DRIVER: mysql
ALTER TABLE my_table
	DROP COLUMN deprecated_field,
	DROP COLUMN unused_field;

-- DRIVER: pgx
ALTER TABLE my_table
	DROP COLUMN deprecated_field,
	DROP COLUMN unused_field;

-- DRIVER: mssql
ALTER TABLE my_table DROP COLUMN
	deprecated_field,
	unused_field;

-- DRIVER: sqlite
ALTER TABLE my_table DROP COLUMN deprecated_field;
-- DRIVER: sqlite
ALTER TABLE my_table DROP COLUMN unused_field;

IMPORTANT: SQLite only supports dropping one column per ALTER TABLE statement. Each column must be a separate statement prefixed with -- DRIVER: sqlite.

Show full SKILL.md (129 more words)Show less
Step 5: Remove Mappings of Column Names to Object Fields

Update the mappings of the database column names to their corresponding object fields in mapColumnsOnInsert, mapColumnsOnUpdate and mapColumnsOnSelect in service.go. Remove mappings of deprecated columns to deprecated object fields.

Step 6: Remove Query Conditions

Remove the query conditions and searchable columns in prepareWhereClauses in service.go that correspond to the removed fields or columns.

Step 7: Update Integration Tests

Remove references to the deprecated fields in service_test.go, including in the NewObject constructor and TestMyNoun_ColumnMappings.

Remove references to the deprecated fields in mynounapi/object_test.go and mynounapi/query_test.go.

Step 8: Housekeeping

Follow the housekeeping skill. Removing fields changes only the hand-written domain code (object.go, query.go, service.go, resources/sql), not definition.go, so the boilerplate regeneration is a no-op; the Version bump and go vet still apply.

© microbus-io, Apache-2.0. 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 .claude/skills/sequel/remove-sql-fields of microbus-io/fabric.

Open the folder on GitHubat commit fb98098

Compare with similar skills

Remove SQL Fields 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.

Remove SQL Fields compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Remove SQL Fields this skillmicrobus-io/fabric172—~1.1kAutomated safety check: PassApache-2.0
Google BigqueryLeoYeAI/openclaw-master-skills2.2k—~4.1kAutomated safety check: PassMIT
Debug Using Debugbarhexlet-volunteers/hexlet-sicp1141 repos~1.5kAutomated safety check: PassAGPL-3.0
Databricksrocky-data/rocky304—~2kAutomated safety check: PassApache-2.0
Datajunction QueryDataJunction/dj161—~2kAutomated safety check: PassMIT
Aurora Dsqlaws/agent-toolkit-for-aws2.8k—~9.6kAutomated safety check: PassApache-2.0

Similar skills

  • Google Bigquery

    LeoYeAI/openclaw-master-skills

    Google BigQuery API integration with managed OAuth. An agent skill from LeoYeAI/openclaw-master-skills.

    2.2k GitHub stars~4.1k tokensUpdated 2 mo ago
    Backend & APIsAuto-check passed
  • Debug Using Debugbar

    hexlet-volunteers/hexlet-sicp

    Inspect what a Laravel request actually did — queries, exceptions, timing, cache, auth, views — by reading the profiling data Laravel Debugbar already captured, via Artisan commands.

    114 GitHub starsUsed in 1 repo~1.5k tokens
    Backend & APIsAuto-check passed
  • Databricks

    rocky-data/rocky

    Databricks REST API and SQL reference for Rocky's warehouse adapter.

    304 GitHub stars~2k tokensUpdated today
    Backend & APIsAuto-check passed
  • Datajunction Query

    DataJunction/dj

    Activate this skill for querying DataJunction (DJ) — finding nodes, generating SQL, fetching metric data, exploring lineage, visualizing results — via the DJ UI, MCP tools, or REST/GraphQL APIs.

    161 GitHub stars~2k tokensUpdated today
    Backend & APIsAuto-check passed
  • Aurora Dsql

    aws/agent-toolkit-for-aws

    Official

    Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless…

    2.8k GitHub stars~9.6k tokensUpdated today
    Backend & APIsAuto-check passed
  • Pp Jobber

    mvanhorn/printing-press-library

    Read-only Jobber CLI for offline analysis — every GraphQL surface synced to SQLite, every relationship queryable.

    2.1k GitHub stars~3k tokensUpdated yesterday
    Backend & APIsAuto-check: notes

More from microbus-io/fabric

All 32 skills in this repo
  • Add Config

    microbus-io/fabric

    TRIGGER when user asks to add or modify a configuration property or setting, or to make a value configurable.

    172 GitHub stars~2.3k tokensUpdated 10 days ago
    Auto-check passed
  • Add Function

    microbus-io/fabric

    TRIGGER when user asks to add, create, or modify an API endpoint, function, or RPC, or a route that accepts typed arguments and returns typed results.

    172 GitHub stars~2.4k tokensUpdated 10 days ago
    Auto-check passed
  • Add Inbound Event

    microbus-io/fabric

    TRIGGER when user asks to listen for, subscribe to, or handle an event emitted by another microservice.

    172 GitHub stars~1.4k tokensUpdated 10 days ago
    Auto-check passed
  • Add Metric

    microbus-io/fabric

    TRIGGER when user asks to add or modify a metric, counter, gauge, or histogram, or to track/measure an operation.

    172 GitHub stars~1.5k tokensUpdated 10 days ago
    Auto-check passed
  • Add Outbound Event

    microbus-io/fabric

    TRIGGER when user asks to fire, emit, or publish an event that other microservices can subscribe to.

    172 GitHub stars~1.7k tokensUpdated 10 days ago
    Auto-check passed
  • Add Python Function

    microbus-io/fabric

    TRIGGER when user asks to add a Python-backed function endpoint to an existing Python-backed microservice.

    172 GitHub stars~1.3k tokensUpdated 10 days ago
    Auto-check passed

Works with

Questions about Remove SQL Fields

What does Remove SQL Fields do?

TRIGGER when user asks to remove, drop, or delete fields, properties, or columns from a SQL CRUD microservice's object. Remove SQL Fields is an agent skill from microbus-io/fabric. TRIGGER when user asks to remove, drop, or delete fields, properties, or columns from a SQL CRUD microservice's object.

When should I use Remove SQL Fields?

Remove SQL Fields fits situations like: user asks to remove; columns from a SQL CRUD microservices object.

How do I install Remove SQL Fields in Claude Code?

Run `npx skills add microbus-io/fabric --skill remove-sql-fields -a claude-code`. Or copy the skill folder (.claude/skills/sequel/remove-sql-fields in microbus-io/fabric) into .claude/skills/remove-sql-fields in your project. Claude Code loads it when a task matches its description.

How do I install Remove SQL Fields in Codex?

Run `npx skills add microbus-io/fabric --skill remove-sql-fields -a codex`. Or copy the skill folder (.claude/skills/sequel/remove-sql-fields in microbus-io/fabric) into .agents/skills/remove-sql-fields in your project. Codex loads it when a task matches its description.

Can I use Remove SQL Fields 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 microbus-io/fabric --skill remove-sql-fields -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/remove-sql-fields, .gemini/skills/remove-sql-fields, .github/skills/remove-sql-fields and .opencode/skills/remove-sql-fields in your project.

What does Remove SQL Fields need to run?

Going by SKILL.md and its folder, Remove SQL Fields needs the command-line tools its instructions call (go).

Does Remove SQL Fields 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 Remove SQL Fields 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 Remove SQL Fields use?

Remove SQL Fields is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Remove SQL Fields use?

About 1.1k tokens (SKILL.md is roughly 4.6k 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 Remove SQL Fields?

Skills that share tags, products or a category with Remove SQL Fields: Google Bigquery (LeoYeAI/openclaw-master-skills, 2.2k stars), Debug Using Debugbar (hexlet-volunteers/hexlet-sicp, 114 stars), Databricks (rocky-data/rocky, 304 stars) and Datajunction Query (DataJunction/dj, 161 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Remove SQL Fields?

microbus-io (a GitHub organization) maintains it in microbus-io/fabric, which has 172 GitHub stars. The repository holds 32 skills in this directory. The repository was last updated on September 28, 2026.

Source: microbus-io/fabric on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.