Agent skill

Modify SQL Fields

by microbus-io in microbus-io/fabric

TRIGGER when user asks to change, rename, or retype fields, properties, or columns of a SQL CRUD microservice's object.

Apache-2.0Auto-check passedBackend & APIs

Install Modify SQL Fields

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

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

GitHub CLI
$ gh skill install microbus-io/fabric modify-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/modify-sql-fields .claude/skills/modify-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
modify-sql-fields
GitHub stars
172
Token cost
~1.4k tokens
SKILL.md length
482 words
Files
1
Skills in repo
32
Repo updated
First seen
Licence
Apache-2.0

At a glance

TRIGGER when user asks to change, rename, or retype fields, properties, or columns of 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 change
  • Calls go
  • Columns of a SQL CRUD microservices object

What it does

Modify SQL Fields is an agent skill from microbus-io/fabric. TRIGGER when user asks to change, rename, or retype fields, properties, or columns of a SQL CRUD microservice's object.

Its SKILL.md is about 1.4k 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 Microservices and SQL. 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 change
  • Columns of a SQL CRUD microservices object

Example prompts

  • “/modify-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. Update Mappings of Column Names to Object Fields
  6. Update 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

Modify SQL Fields loads about 1.4k tokens when it runs. Until then it costs about 34 tokens; SKILL.md has 482 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.4k

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). 482 words, ~1,433 tokens.

Download SKILL.mdSave it as .claude/skills/modify-sql-fields/SKILL.md (or your agent's skills folder).
name
modify-sql-fields
description
TRIGGER when user asks to change, rename, or retype fields, properties, or columns of 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:

Changing 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: Update Mappings of Column Names to Object Fields
- [ ] Step 6: Update 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 in the API directory of the microservice. Change the fields in the type definition of the struct appropriately. Change the field's dv8 tags and the code in the object's Validate method appropriately.

Step 3: Update the Type Definition of the Query

Find the type definition of the query in mynounapi/query.go in the API directory of the microservice. Change the fields in the type definition of the struct appropriately. Change the field's dv8 tags and the code in the query's Validate method appropriately.

Step 4: Update Database Schema

Skip this step if the changes do not necessitate a database schema change. For example, renaming only a Go field or JSON tag without changing the database column name does not require a schema change.

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

Append ALTER TABLE statements to change the type, size or constraints of columns, if applicable. For pgx, each aspect of the column (type, nullability, default) requires a separate statement - only include the statements relevant to the change. For mssql, if the column already has a default constraint from a prior migration, drop it before adding the new one.

sql
-- DRIVER: mysql
ALTER TABLE my_table
	MODIFY COLUMN modified_column VARCHAR(384) NOT NULL DEFAULT '',
	MODIFY COLUMN changed_column BIGINT NOT NULL DEFAULT 0;

-- DRIVER: pgx
ALTER TABLE my_table ALTER COLUMN modified_column TYPE VARCHAR(384);
-- DRIVER: pgx
ALTER TABLE my_table ALTER COLUMN modified_column SET NOT NULL;
-- DRIVER: pgx
ALTER TABLE my_table ALTER COLUMN modified_column SET DEFAULT '';
-- DRIVER: pgx
ALTER TABLE my_table ALTER COLUMN changed_column TYPE BIGINT;
-- DRIVER: pgx
ALTER TABLE my_table ALTER COLUMN changed_column SET NOT NULL;
-- DRIVER: pgx
ALTER TABLE my_table ALTER COLUMN changed_column SET DEFAULT 0;

-- DRIVER: mssql
ALTER TABLE my_table DROP CONSTRAINT my_table_df_modified_column;
-- DRIVER: mssql
ALTER TABLE my_table DROP CONSTRAINT my_table_df_changed_column;
-- DRIVER: mssql
ALTER TABLE my_table ALTER COLUMN modified_column NVARCHAR(384) NOT NULL;
-- DRIVER: mssql
ALTER TABLE my_table ALTER COLUMN changed_column BIGINT NOT NULL;
-- DRIVER: mssql
ALTER TABLE my_table ADD CONSTRAINT my_table_df_modified_column DEFAULT '' FOR modified_column;
-- DRIVER: mssql
ALTER TABLE my_table ADD CONSTRAINT my_table_df_changed_column DEFAULT 0 FOR changed_column;

Append ALTER TABLE or EXEC statements to rename columns, if applicable. For mysql, prefer using the new RENAME COLUMN syntax over the old CHANGE COLUMN syntax.

sql
-- DRIVER: mysql
ALTER TABLE my_table
    RENAME COLUMN old_column TO new_column;

-- DRIVER: pgx
ALTER TABLE my_table
    RENAME COLUMN old_column TO new_column;

-- DRIVER: mssql
EXEC sp_rename 'my_table.old_column', 'new_column', 'COLUMN';

Refer to the older .sql migration files to identify what if any indices were associated with renamed columns. Append statements to the migration script to rename these indices, if applicable.

sql
-- DRIVER: mysql
ALTER TABLE my_table RENAME INDEX my_table_idx_old_column TO my_table_idx_new_column;

-- DRIVER: pgx
ALTER INDEX my_table_idx_old_column RENAME TO my_table_idx_new_column;

-- DRIVER: mssql
EXEC sp_rename 'my_table_idx_old_column', 'my_table_idx_new_column', 'INDEX';
Show full SKILL.md (121 more words)Show less
Step 5: Update Mappings of Column Names to Object Fields

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

Step 6: Update Query Conditions

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

Step 7: Update Integration Tests

Adjust references to the changed fields in service_test.go, including in the NewObject constructor and TestMyNoun_ColumnMappings.

Adjust references to the changed fields in mynounapi/object_test.go and mynounapi/query_test.go.

Step 8: Housekeeping

Follow the housekeeping skill. Modifying 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/modify-sql-fields of microbus-io/fabric.

Open the folder on GitHubat commit fb98098

Compare with similar skills

Modify 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.

Modify SQL Fields compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Modify SQL Fields this skillmicrobus-io/fabric172—~1.4kAutomated 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 today
    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 Modify SQL Fields

What does Modify SQL Fields do?

TRIGGER when user asks to change, rename, or retype fields, properties, or columns of a SQL CRUD microservice's object. Modify SQL Fields is an agent skill from microbus-io/fabric. TRIGGER when user asks to change, rename, or retype fields, properties, or columns of a SQL CRUD microservice's object.

When should I use Modify SQL Fields?

Modify SQL Fields fits situations like: user asks to change; columns of a SQL CRUD microservices object.

How do I install Modify SQL Fields in Claude Code?

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

How do I install Modify SQL Fields in Codex?

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

Can I use Modify 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 modify-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/modify-sql-fields, .gemini/skills/modify-sql-fields, .github/skills/modify-sql-fields and .opencode/skills/modify-sql-fields in your project.

What does Modify SQL Fields need to run?

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

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

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

About 1.4k tokens (SKILL.md is roughly 5.7k 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 Modify SQL Fields?

Skills that share tags, products or a category with Modify 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 Modify 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.