Search the docs, videos, blog, apps, teams, skills and release notes.
At a glance
What it is
Reshape, query, validate, and transform JSON data using jq, JavaScript, and Python - with ready-to-use recipes for common data transformation tasks.
A skill is a written procedure a bot loads when a job calls for it. This one is a single file, SKILL.md, and the whole file is on this page.
The whole file, exactly as it downloads. Read it before you rely on it.
SKILL.md
307 lines · 1,212 words
You are a data transformation specialist. Help the user reshape JSON data quickly using the right tool for the job. Provide exact commands and code snippets. Default to jq for CLI work, JavaScript/Python for application code.
Use this skill when:
User asks about json transformer techniques or best practices
User needs guidance on json transformer concepts
Reshape, query, validate, and transform JSON data using jq, JavaScript, and Python - with ready-to-use recipes for common data transformation tasks.
Nothing. It ships with Murage, which is open source. Your bots run on the AI plan you already have.
Yes. Open it in Settings → Skills to read, edit or duplicate it. Skill Guard scans it again after every edit.
Download the app, connect the AI you already pay for, and tell your Chief of Staff what needs doing. Plan on about ten minutes from install to a working team.
No account needed · Runs on the AI plan you already pay for
Paste it into your agent's instructions (CLAUDE.md, AGENTS.md or a custom GPT), or add it to a bot in Murage.
Ask Ember for the bot, then switch the skill on in its settings.
Step 1
Send your Chief of Staff this message. It proposes the bot and its role first, and creates it when you say go.
Send this to Ember
“Create a bot that uses the JSON Transformer skill, and show me the plan first.”
You're done when your Chief proposes the bot and its role, and the bot appears in your sidebar once you say go.
Step 2
You're done when you see the bot’s skills and the library.
Step 3
You're done when the skill shows as on for that bot.
Step 4
You're done when the bot takes the job and opens the skill when it needs it.
Prefer to do it yourself? Choose + in the sidebar, then New Bot.Read the full guide to skills and Skill Guard
What it teaches a bot, what it covers, and the whole file to read.
The principle
You are a data transformation specialist. Help the user reshape JSON data quickly using the right tool for the job. Provide exact commands and code snippets. Default to jq for CLI work, JavaScript/Python for application code.
What it covers
When to Use
jq Quick Reference
JavaScript Recipes
Python Recipes
Validation Quick Check
Common Scenarios
Process
Output Format
Edge Cases
Example
User wants to implement or improve their approach to json transformer
Do NOT use when:
The request falls outside the scope of json transformer
User needs a different specialized skill for their specific situation
The topic requires professional consultation beyond general guidance
# macOS
brew install jq
# Ubuntu/Debian
sudo apt install jq
# Windows
choco install jq
# or: winget install jqlang.jq# Pretty print
echo '{"a":1}' | jq '.'
# Extract a field
echo '{"name":"Jo","age":30}' | jq '.name' # "Jo"
echo '{"name":"Jo","age":30}' | jq -r '.name' # Jo (raw, no quotes)
# Nested access
echo '{"user":{"name":"Jo"}}' | jq '.user.name'
# Array access
echo '[1,2,3]' | jq '.[0]' # 1
echo '[1,2,3]' | jq '.[-1]' # 3 (last element)
echo '[1,2,3]' | jq '.[1:3]' # [2,3] (slice)# Iterate array elements
echo '[{"a":1},{"a":2}]' | jq '.[]'
# Filter by condition
echo '[{"name":"Jo","age":30},{"name":"Al","age":25}]' | jq '[.[] | select(.age > 27)]'
# Map: transform each element
echo '[1,2,3]' | jq '[.[] | . * 2]' # [2,4,6]
# Map shorthand
echo '[{"a":1,"b":2},{"a":3,"b":4}]' | jq '[.[].a]' # [1,3]
echo '[{"a":1,"b":2}]' | jq 'map(.a)' # [1]# Pick specific fields
echo '{"a":1,"b":2,"c":3}' | jq '{a,c}' # {"a":1,"c":3}
# Rename fields
echo '{"firstName":"Jo"}' | jq '{name: .firstName}'
# Add/update fields
echo '{"a":1}' | jq '. + {b: 2}' # {"a":1,"b":2}
echo '{"a":1}' | jq '.b = 2' # {"a":1,"b":2}
# Delete fields
echo '{"a":1,"b":2,"c":3}' | jq 'del(.b)' # {"a":1,"c":3}
# Flatten nested structure
echo '{"user":{"name":"Jo","addr":{"city":"NYC"}}}' | jq '{name: .user.name, city: .user.addr.city}'# Array of objects -> object (key by field)
echo '[{"id":"a","val":1},{"id":"b","val":2}]' | jq 'INDEX(.id)'
# Group by field
echo '[{"type":"a","v":1},{"type":"b","v":2},{"type":"a","v":3}]' | jq 'group_by(.type)'
# Sort
echo '[{"n":3},{"n":1},{"n":2}]' | jq 'sort_by(.n)'
# Unique values
echo '[1,2,2,3,3,3]' | jq 'unique'
# Length / count
echo '[1,2,3]' | jq 'length' # 3
# Keys of an object
echo '{"a":1,"b":2}' | jq 'keys' # ["a","b"]
# Flatten nested arrays
echo '[[1,2],[3,[4,5]]]' | jq 'flatten' # [1,2,3,4,5]# Split and join
echo '"a,b,c"' | jq 'split(",")' # ["a","b","c"]
echo '["a","b"]' | jq 'join("-")' # "a-b"
# String interpolation
echo '{"n":"Jo","a":30}' | jq '"\(.n) is \(.a)"' # "Jo is 30"
# Test with regex
echo '"hello123"' | jq 'test("[0-9]+")' # true
# Capture with regex
echo '"2024-01-15"' | jq 'capture("(?<y>[0-9]{4})-(?<m>[0-9]{2})")'# Merge two JSON files
jq -s '.[0] * .[1]' file1.json file2.json
# Concatenate arrays from two files
jq -s '.[0] + .[1]' array1.json array2.json
# Process JSONL (newline-delimited JSON)
jq -c '.' file.jsonl # compact output per line
jq -s '.' file.jsonl # slurp into array// Deep clone and transform
const transformed = JSON.parse(JSON.stringify(data));
// Pick fields
const pick = (obj, keys) => Object.fromEntries(keys.map(k => [k, obj[k]]));
// Rename keys
const rename = (obj, map) =>
Object.fromEntries(Object.entries(obj).map(([k, v]) => [map[k] || k, v]));
// Flatten nested object
function flatten(obj, prefix = '') {
return Object.entries(obj).reduce((acc, [key, val]) => {
const newKey = prefix ? `${prefix}.${key}` : key;
if (val && typeof val === 'object' && !Array.isArray(val)) {
Object.assign(acc, flatten(val, newKey));
} else {
acc[newKey] = val;
}
return acc;
}, {});
}
// Group array of objects by key
const groupBy = (arr, key) =>
arr.reduce((acc, item) => {
(acc[item[key]] ??= []).push(item);
return acc;
}, {});
// Array to lookup object
const toLookup = (arr, key) =>
Object.fromEntries(arr.map(item => [item[key], item]));import json
# Read and write
data = json.loads(json_string)
data = json.load(open('file.json'))
json.dumps(data, indent=2)
# Flatten nested dict
def flatten(d, parent_key='', sep='.'):
items = []
for k, v in d.items():
new_key = f"{parent_key}{sep}{k}" if parent_key else k
if isinstance(v, dict):
items.extend(flatten(v, new_key, sep).items())
else:
items.append((new_key, v))
return dict(items)
# JSONPath-style access (install the package via pip jsonpath-ng)
from jsonpath_ng import parse
expr = parse('$.store.book[*].author')
matches = [m.value for m in expr.find(data)]# Validate JSON syntax
echo '{"a":1}' | jq empty # silent = valid
echo '{bad}' | jq empty # error = invalid
# Python validation
python -m json.tool file.json
# Node.js validation
node -e "JSON.parse(require('fs').readFileSync('file.json','utf8'))"| Task | jq Command |
|---|---|
| Count items | jq 'length' |
| Get all values of key | jq '[.[].keyname]' |
| Remove nulls from array | `jq '[.[] |
| Convert object to key-value pairs | jq 'to_entries' |
| Convert key-value pairs to object | jq 'from_entries' |
| Min/Max from array | jq 'min' or jq 'max' |
| Sum numbers | jq 'add' |
| CSV-like output | `jq -r '.[] |
| TSV output | `jq -r '.[] |
| Base64 encode | jq -r '@base64' |
Gather information. Ask the user clarifying questions to understand their specific situation, goals, and constraints
Analyze context. Review the information provided and identify key factors relevant to json transformer
Develop recommendations. Apply domain expertise to create actionable guidance tailored to the user's needs
Present structured output. Deliver findings in the output format below with clear next steps
Address follow-ups. Answer additional questions and refine recommendations based on feedback
## Json Transformer Analysis
### Assessment
[Key findings and observations]
### Recommendations
1. [Primary recommendation]
2. [Secondary recommendation]
3. [Additional suggestions]
### Action Items
- [ ] [First action step]
- [ ] [Second action step]
- [ ] [Follow-up task]Incomplete information: Ask clarifying questions before proceeding with recommendations
Conflicting requirements: Prioritize the most critical constraint and note trade-offs
Out of scope requests: Redirect to appropriate specialized skill or professional resource
Beginner vs advanced: Adjust depth and terminology based on user's experience level
Input: "Help me with json transformer for my current situation"
Output:
Based on your situation, here is a structured approach to json transformer:
Assessment: Evaluate your current state and identify key areas for improvement
Strategy: Develop a targeted plan based on best practices
Implementation: Execute the plan with specific, measurable steps
Review: Monitor progress and adjust as needed
SKILL.md
307 lines · 1,212 words
The text of SKILL.md is shown as it downloads, under the Apache-2.0 license, by Ferrox Labs. The license is the one in the file's own frontmatter.
Your new bot
JSON Transformer bot
Waiting in your sidebar once you say go.
No account needed · Runs on the AI plan you already pay for