{"slug":"xiaomi-soar","name":"Soar","description":"SQL Optimizer And Rewriter","long_description":"SQL Optimizer And Rewriter\n\nImported by the skill-only GitHub discovery pipeline because it matches agent skill, automation, domain workflow, RAG, document-processing, data, finance, security, or developer-tool signals. Protocol-server projects are excluded from automated imports.","tagline":"SQL Optimizer And Rewriter","category":"data-analysis","tags":["sql","data-analysis","data","advisor","auditor","command-line","database","indexing","mysql","optimizer"],"author":"XiaoMi","verified":true,"attribution":{"status":"community_indexed","statusLabel":"Community indexed","shortLabel":"COMMUNITY INDEXED","sourceLabel":"GitHub star discovery","sourceDetail":"XiaoMi/soar","creatorName":"XiaoMi","creatorUrl":"https://github.com/XiaoMi","sourceUrl":"https://github.com/XiaoMi/soar","indexedBy":"OpenAgentSkill community index","claimUrl":"https://www.openagentskill.com/skills/xiaomi-soar#claim-this-skill","claimCta":"Claim this skill","trustNote":"This listing was indexed from public sources and is not marked official until a maintainer claim is approved.","publicNote":"Attribution links to the public repository or creator profile. Creators can claim the listing to update ownership signals."},"stats":{"stars":8771,"forks":1320,"downloads":0,"rating":0,"review_count":0,"quality_score":54.3},"quality":{"score":80,"tier":"strong","label":"Strong","summary":"Solid option that is likely worth shortlisting for production workflows.","signals":[{"label":"GitHub stars","value":"8.8K","tone":"positive"},{"label":"Freshness","value":"3y ago","tone":"warning"},{"label":"Install ready","value":"Yes","tone":"positive"},{"label":"License","value":"Apache-2.0","tone":"neutral"}],"warnings":["Repository looks stale"]},"trust":{"version":"trust-score-v4","score":80,"tier":"strong","label":"Strong shortlist","summary":"Good trust signals with a few areas worth checking before rollout.","recommendedAction":"Test in a sandbox workflow and compare its install path with close alternatives.","dimensions":[{"id":"github_adoption","label":"GitHub adoption","score":94,"weight":0.13,"status":"pass","detail":"8.8K GitHub stars"},{"id":"repo_activity","label":"Stars/forks activity","score":93,"weight":0.08,"status":"pass","detail":"8.8K stars, 1.3K forks; issue activity unavailable in current metadata"},{"id":"maintenance","label":"Recent maintenance","score":22,"weight":0.14,"status":"fail","detail":"3y since push"},{"id":"license","label":"License clarity","score":86,"weight":0.09,"status":"pass","detail":"Apache-2.0"},{"id":"documentation","label":"README/SKILL.md completeness","score":74,"weight":0.14,"status":"info","detail":"Public metadata needs stronger README/SKILL.md context"},{"id":"dependency_risk","label":"Dependency/runtime risk","score":82,"weight":0.12,"status":"pass","detail":"database surface"},{"id":"installability","label":"Install availability","score":92,"weight":0.1,"status":"pass","detail":"npx skills add XiaoMi/soar"},{"id":"install_safety","label":"Install command safety","score":92,"weight":0.1,"status":"pass","detail":"standard package or runtime install path"},{"id":"permission_surface","label":"Permission surface","score":50,"weight":0.07,"status":"warn","detail":"shell or command execution, filesystem or document access"},{"id":"repository","label":"Repository evidence","score":86,"weight":0.04,"status":"pass","detail":"https://github.com/XiaoMi/soar"},{"id":"review_status","label":"Review status","score":88,"weight":0.05,"status":"pass","detail":"AI review data available"},{"id":"agent_outcomes","label":"Real agent outcomes","score":58,"weight":0.08,"status":"info","detail":"No agent outcome data yet"}],"checks":[{"status":"pass","label":"GitHub adoption","detail":"8.8K GitHub stars"},{"status":"pass","label":"Stars/forks activity","detail":"8.8K stars, 1.3K forks; issue activity unavailable in current metadata"},{"status":"fail","label":"Recent maintenance","detail":"3y since push"},{"status":"pass","label":"License clarity","detail":"Apache-2.0"},{"status":"info","label":"README/SKILL.md completeness","detail":"Public metadata needs stronger README/SKILL.md context"},{"status":"pass","label":"Dependency/runtime risk","detail":"database surface"},{"status":"pass","label":"Install availability","detail":"npx skills add XiaoMi/soar"},{"status":"pass","label":"Install command safety","detail":"standard package or runtime install path"},{"status":"warn","label":"Permission surface","detail":"shell or command execution, filesystem or document access"},{"status":"pass","label":"Repository evidence","detail":"https://github.com/XiaoMi/soar"},{"status":"pass","label":"Review status","detail":"AI review data available"},{"status":"info","label":"Real agent outcomes","detail":"No agent outcome data yet"},{"status":"pass","label":"Ownership","detail":"Listing manually verified"},{"status":"pass","label":"OpenAgentSkill usage","detail":"1 views, 0 install copies"},{"status":"info","label":"Agent outcomes","detail":"No agent outcome data yet"}],"strengths":["Manually verified listing","AI review approved","Install path is available","Repository evidence is available","Large GitHub adoption signal","Install command has no obvious high-risk pattern"],"warnings":["Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push","Permission surface: shell or command execution, filesystem or document access"],"evidence":{"stars":"8.8K GitHub stars","repoActivity":"8.8K stars, 1.3K forks","lastPushed":"3y since push","license":"Apache-2.0","repository":"https://github.com/XiaoMi/soar","install":"npx skills add XiaoMi/soar","installSafety":"standard package or runtime install path","permissionSurface":"shell or command execution, filesystem or document access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"installReadiness":{"ready":true,"command":"npx skills add XiaoMi/soar","policy":"human_review_before_install","label":"Human review before install","notes":["Install path is available","Repository evidence is available","License is declared","3y since push"]},"agentCompatibility":["Go","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI"],"riskSummary":{"level":"medium","label":"Review before production","notes":["Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push"]},"outcomeEvidence":{"total":0,"successes":0,"successRate":null,"installAttempts":0,"riskBlocked":0,"setupRequired":0,"lastOutcomeAt":null,"label":"No agent outcome data yet"},"autoInstall":{"allowed":false,"sandboxRequired":true,"policy":"human_review_before_install","reason":"Human review or sandbox validation is required before automatic installation."},"bestFor":["data-analysis","sql","data","advisor","auditor","command-line"],"doNotUseFor":["Production credentials, payments, or irreversible account changes without explicit human review","Sensitive private data before reviewing repository code, license, and permission surface","Automatic installation in a production workspace"],"knownRisks":["Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push","Permission surface: shell or command execution, filesystem or document access"]},"safety":{"score":42,"level":"avoid_auto_install","label":"Avoid automatic install","safety_tier":{"tier":"experimental","label":"Experimental","badge":"EXPERIMENTAL","summary":"Sparse or mixed signals. Useful for discovery, but not for autonomous installation.","recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","auto_install_policy":"review","reasons":["High-risk permission hints: Shell or command execution","42/100 agent safety score"]},"auto_install_allowed":false,"human_review_required":true,"blocked":false,"audit_risk":"needs_review","permission_hints":[{"id":"shell","label":"Shell or command execution","reason":"Skill metadata references terminal, CLI, shell, subprocess, or command execution workflows.","severity":"high"},{"id":"network","label":"Network access","reason":"Skill likely fetches remote pages, APIs, repositories, or external services.","severity":"medium"},{"id":"filesystem","label":"Filesystem access","reason":"Skill may read or write project files, documents, generated artifacts, or local workspace state.","severity":"medium"},{"id":"database","label":"Database access","reason":"Skill may inspect schemas, query databases, or work with persistent stores.","severity":"medium"}],"policy_warnings":["High-risk permission hints: Shell or command execution","Permission surface may require sandboxing"],"constraints_applied":{"max_risk":"medium","needs_install_command":true,"min_stars":0}},"safety_gate":{"tier":"experimental","label":"Experimental","badge":"EXPERIMENTAL","auto_install_policy":"review","auto_install_allowed":false,"blocked":false,"human_review_required":true,"recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","reasons":["High-risk permission hints: Shell or command execution","42/100 agent safety score"]},"eval":{"version":"openagentskill-skill-eval-v1","status":"failed","score":71,"risk_level":"high","decision":{"recommendation":"do_not_auto_install","reason":"Permission surface: shell or command execution, filesystem or document access","auto_install_allowed":false,"policy":"block","human_review_required":true},"blockers":["Permission surface: shell or command execution, filesystem or document access"],"warnings":["Trust score: Good trust signals with a few areas worth checking before rollout.","Audit score: Needs review","Agent safety gate: Sparse or mixed signals. Useful for discovery, but not for autonomous installation.","README/SKILL.md completeness: Public metadata needs stronger README/SKILL.md context","High-risk permission hints: Shell or command execution","Permission surface may require sandboxing","Repository appears stale","Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push"],"validation_plan":["Inspect repository, README/SKILL.md, license, and recent commits before production use.","Install in an isolated workspace or sandbox with no production secrets available.","Run the smallest representative task and record files touched, commands run, network access, and outputs.","Compare the selected skill against at least one alternative when the eval status is review or failed.","Promote only after the agent reports a successful verification result and unresolved warnings are accepted."],"checks":[{"id":"task_fit","label":"Task fit","status":"pass","score":84,"required_for_auto_install":true,"detail":"Task wording matches this skill metadata.","evidence":["Evaluate Soar before installing it in an agent workflow","data-analysis","Database and SQL workflows; Claude Code teams; teams that value GitHub adoption signals"]},{"id":"install_path","label":"Install path","status":"pass","score":92,"required_for_auto_install":true,"detail":"Install handoff is available.","evidence":["npx skills add XiaoMi/soar"]},{"id":"install_safety","label":"Install command safety","status":"pass","score":92,"required_for_auto_install":true,"detail":"standard package or runtime install path","evidence":["npx skills add XiaoMi/soar"]},{"id":"trust_score","label":"Trust score","status":"warn","score":80,"required_for_auto_install":true,"detail":"Good trust signals with a few areas worth checking before rollout.","evidence":["Strong shortlist","8.8K GitHub stars","Apache-2.0"]},{"id":"audit_score","label":"Audit score","status":"warn","score":74,"required_for_auto_install":true,"detail":"Needs review","evidence":["Permission surface may require sandboxing"]},{"id":"agent_safety_gate","label":"Agent safety gate","status":"warn","score":42,"required_for_auto_install":true,"detail":"Sparse or mixed signals. Useful for discovery, but not for autonomous installation.","evidence":["Test manually in an isolated workspace and compare against safer alternatives.","High-risk permission hints: Shell or command execution"]},{"id":"readme_skillmd_completeness","label":"README/SKILL.md completeness","status":"warn","score":74,"required_for_auto_install":false,"detail":"Public metadata needs stronger README/SKILL.md context","evidence":["Usable metadata, review docs"]},{"id":"license_clarity","label":"License clarity","status":"pass","score":86,"required_for_auto_install":true,"detail":"Apache-2.0","evidence":["Apache-2.0"]},{"id":"recent_maintenance","label":"Recent maintenance","status":"fail","score":22,"required_for_auto_install":false,"detail":"3y since push","evidence":["3y since push"]},{"id":"permission_surface","label":"Permission surface","status":"fail","score":50,"required_for_auto_install":true,"detail":"shell or command execution, filesystem or document access","evidence":["Shell or command execution: high","Network access: medium","Filesystem access: medium"]},{"id":"alternatives","label":"Alternatives available","status":"info","score":55,"required_for_auto_install":false,"detail":"No close alternatives were found in the current shortlist.","evidence":[]}],"endpoints":{"web":"https://www.openagentskill.com/skills/xiaomi-soar/evals","api":"/api/agent/evals?slug=xiaomi-soar","text":"/api/agent/evals?slug=xiaomi-soar&format=text"}},"agent_readable_metadata":{"version":"openagentskill-agent-metadata-v2","skill":{"slug":"xiaomi-soar","name":"Soar","description":"SQL Optimizer And Rewriter","category":"data-analysis","url":"https://www.openagentskill.com/skills/xiaomi-soar","repository":"https://github.com/XiaoMi/soar","github_repo":"XiaoMi/soar"},"suited_tasks":["Database and SQL workflows","Claude Code teams","teams that value GitHub adoption signals","Understand table relationships","Write safer queries","Explain database changes","Inspect source files","Explain architecture"],"suited_agents":["Go","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI","CLI"],"install":{"command":"npx skills add XiaoMi/soar","ready":true,"targets":[{"id":"openagentskill-cli","label":"CLI","kind":"command","value":"npx skills add XiaoMi/soar"},{"id":"codex","label":"Codex","kind":"agent-prompt","value":"Install the \"Soar\" agent skill from https://github.com/XiaoMi/soar. Read its SKILL.md or equivalent instructions first, install only the files needed for this workspace, and summarize any required setup before using it. Skill purpose: SQL Optimizer And Rewriter"},{"id":"claude-code","label":"Claude Code","kind":"agent-prompt","value":"Add \"Soar\" as a Claude Code skill from https://github.com/XiaoMi/soar. Inspect the skill instructions, place the reusable skill files in the appropriate local skills location for this project, and report the activation steps. Skill purpose: SQL Optimizer And Rewriter"},{"id":"cursor","label":"Cursor","kind":"agent-prompt","value":"Turn \"Soar\" from https://github.com/XiaoMi/soar into a reusable Cursor project rule or agent instruction. Preserve the core workflow, adapt paths to this repo, and keep the rule scoped to tasks where it is relevant. Skill purpose: SQL Optimizer And Rewriter"}],"handoff_url":"https://www.openagentskill.com/api/skills/xiaomi-soar/install","manifest_url":"https://www.openagentskill.com/api/registry/manifest/xiaomi-soar"},"trust":{"score":80,"label":"Strong shortlist","version":"trust-score-v4","install_policy":"human_review_before_install","evidence":{"stars":"8.8K GitHub stars","repoActivity":"8.8K stars, 1.3K forks","lastPushed":"3y since push","license":"Apache-2.0","repository":"https://github.com/XiaoMi/soar","install":"npx skills add XiaoMi/soar","installSafety":"standard package or runtime install path","permissionSurface":"shell or command execution, filesystem or document access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"outcome_evidence":{"total":0,"success_rate":null,"install_attempts":0,"risk_blocked":0,"setup_required":0,"label":"No agent outcome data yet"},"auto_install":{"allowed":false,"sandbox_required":true,"reason":"Human review or sandbox validation is required before automatic installation."},"best_for":["data-analysis","sql","data","advisor","auditor","command-line"],"known_risks":["Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push","Permission surface: shell or command execution, filesystem or document access"]},"audit":{"score":74,"risk_level":"needs_review","risk_label":"Needs review","warnings":["Permission surface may require sandboxing","Repository appears stale","Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push","Permission surface: shell or command execution, filesystem or document access"]},"safety_gate":{"tier":"experimental","label":"Experimental","auto_install_policy":"review","auto_install_allowed":false,"human_review_required":true,"blocked":false,"recommended_action":"Test manually in an isolated workspace and compare against safer alternatives."},"quality":{"score":80,"label":"Strong"},"supply":{"track":"Data, BI, and analytics","scenario":"Database and SQL","maintenance":"3y since push","risk":"Needs review"},"alternative_skills":[],"do_not_use_when":["teams that require actively maintained dependencies","production agents without a repository review","Repository looks stale","High-risk permission hints: Shell or command execution","Permission surface may require sandboxing","Repository appears stale","Quality score needs review","Documentation summary is thin"],"agent_contract":{"task_input":"Use Soar in an agent workflow","recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","install_policy":"review","minimum_review_before_use":["Trust: 80/100 Strong shortlist","Audit: 74/100 Needs review","Safety: 42/100 Avoid automatic install","Review repository, license, install command, and permission surface before production use."],"expected_agent_output":{"selected_skill":"xiaomi-soar (Soar)","install_command":"npx skills add XiaoMi/soar","risk_summary":"Needs review; Experimental; Review before production","verification_result":"Report the smallest successful task, files touched, warnings, and any missing setup."}},"endpoints":{"web":"https://www.openagentskill.com/skills/xiaomi-soar","api":"https://www.openagentskill.com/api/agent/skills/xiaomi-soar","audit":"https://www.openagentskill.com/skills/xiaomi-soar/audit","eval":"https://www.openagentskill.com/api/agent/evals?slug=xiaomi-soar&task=Use%20Soar%20in%20an%20agent%20workflow&max_risk=medium","resolve":"https://www.openagentskill.com/api/agent/resolve?task=Use%20Soar%20in%20an%20agent%20workflow&agent=codex&max_risk=medium","install":"https://www.openagentskill.com/api/skills/xiaomi-soar/install","manifest":"https://www.openagentskill.com/api/registry/manifest/xiaomi-soar"}},"machine_metadata":{"version":"openagentskill-agent-metadata-v2","skill":{"slug":"xiaomi-soar","name":"Soar","description":"SQL Optimizer And Rewriter","category":"data-analysis","url":"https://www.openagentskill.com/skills/xiaomi-soar","repository":"https://github.com/XiaoMi/soar","github_repo":"XiaoMi/soar"},"suited_tasks":["Database and SQL workflows","Claude Code teams","teams that value GitHub adoption signals","Understand table relationships","Write safer queries","Explain database changes","Inspect source files","Explain architecture"],"suited_agents":["Go","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI","CLI"],"install":{"command":"npx skills add XiaoMi/soar","ready":true,"targets":[{"id":"openagentskill-cli","label":"CLI","kind":"command","value":"npx skills add XiaoMi/soar"},{"id":"codex","label":"Codex","kind":"agent-prompt","value":"Install the \"Soar\" agent skill from https://github.com/XiaoMi/soar. Read its SKILL.md or equivalent instructions first, install only the files needed for this workspace, and summarize any required setup before using it. Skill purpose: SQL Optimizer And Rewriter"},{"id":"claude-code","label":"Claude Code","kind":"agent-prompt","value":"Add \"Soar\" as a Claude Code skill from https://github.com/XiaoMi/soar. Inspect the skill instructions, place the reusable skill files in the appropriate local skills location for this project, and report the activation steps. Skill purpose: SQL Optimizer And Rewriter"},{"id":"cursor","label":"Cursor","kind":"agent-prompt","value":"Turn \"Soar\" from https://github.com/XiaoMi/soar into a reusable Cursor project rule or agent instruction. Preserve the core workflow, adapt paths to this repo, and keep the rule scoped to tasks where it is relevant. Skill purpose: SQL Optimizer And Rewriter"}],"handoff_url":"https://www.openagentskill.com/api/skills/xiaomi-soar/install","manifest_url":"https://www.openagentskill.com/api/registry/manifest/xiaomi-soar"},"trust":{"score":80,"label":"Strong shortlist","version":"trust-score-v4","install_policy":"human_review_before_install","evidence":{"stars":"8.8K GitHub stars","repoActivity":"8.8K stars, 1.3K forks","lastPushed":"3y since push","license":"Apache-2.0","repository":"https://github.com/XiaoMi/soar","install":"npx skills add XiaoMi/soar","installSafety":"standard package or runtime install path","permissionSurface":"shell or command execution, filesystem or document access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"outcome_evidence":{"total":0,"success_rate":null,"install_attempts":0,"risk_blocked":0,"setup_required":0,"label":"No agent outcome data yet"},"auto_install":{"allowed":false,"sandbox_required":true,"reason":"Human review or sandbox validation is required before automatic installation."},"best_for":["data-analysis","sql","data","advisor","auditor","command-line"],"known_risks":["Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push","Permission surface: shell or command execution, filesystem or document access"]},"audit":{"score":74,"risk_level":"needs_review","risk_label":"Needs review","warnings":["Permission surface may require sandboxing","Repository appears stale","Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push","Permission surface: shell or command execution, filesystem or document access"]},"safety_gate":{"tier":"experimental","label":"Experimental","auto_install_policy":"review","auto_install_allowed":false,"human_review_required":true,"blocked":false,"recommended_action":"Test manually in an isolated workspace and compare against safer alternatives."},"quality":{"score":80,"label":"Strong"},"supply":{"track":"Data, BI, and analytics","scenario":"Database and SQL","maintenance":"3y since push","risk":"Needs review"},"alternative_skills":[],"do_not_use_when":["teams that require actively maintained dependencies","production agents without a repository review","Repository looks stale","High-risk permission hints: Shell or command execution","Permission surface may require sandboxing","Repository appears stale","Quality score needs review","Documentation summary is thin"],"agent_contract":{"task_input":"Use Soar in an agent workflow","recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","install_policy":"review","minimum_review_before_use":["Trust: 80/100 Strong shortlist","Audit: 74/100 Needs review","Safety: 42/100 Avoid automatic install","Review repository, license, install command, and permission surface before production use."],"expected_agent_output":{"selected_skill":"xiaomi-soar (Soar)","install_command":"npx skills add XiaoMi/soar","risk_summary":"Needs review; Experimental; Review before production","verification_result":"Report the smallest successful task, files touched, warnings, and any missing setup."}},"endpoints":{"web":"https://www.openagentskill.com/skills/xiaomi-soar","api":"https://www.openagentskill.com/api/agent/skills/xiaomi-soar","audit":"https://www.openagentskill.com/skills/xiaomi-soar/audit","eval":"https://www.openagentskill.com/api/agent/evals?slug=xiaomi-soar&task=Use%20Soar%20in%20an%20agent%20workflow&max_risk=medium","resolve":"https://www.openagentskill.com/api/agent/resolve?task=Use%20Soar%20in%20an%20agent%20workflow&agent=codex&max_risk=medium","install":"https://www.openagentskill.com/api/skills/xiaomi-soar/install","manifest":"https://www.openagentskill.com/api/registry/manifest/xiaomi-soar"}},"supply_profile":{"track":{"slug":"data","label":"Data, BI, and analytics","shortLabel":"Data","description":"CSV, SQL, notebooks, dashboards, data pipelines, BI, ETL, and spreadsheet analysis."},"scenario":{"label":"Database and SQL","description":"I need my agent to inspect database schemas, write SQL, and explain query results.","useCases":[{"slug":"database-sql","title":"Database and SQL"},{"slug":"coding-agents","title":"Coding agents"},{"slug":"rag-knowledge","title":"RAG and knowledge"}]},"applicableAgents":["Claude Code","CLI","Codex","Cursor","Go"],"install":{"ready":true,"command":"npx skills add XiaoMi/soar","primaryTarget":"CLI","targetCount":4},"githubQuality":{"stars":8771,"starsLabel":"8.8K","forks":1320,"license":"Apache-2.0","qualityScore":80,"trustScore":80,"auditScore":74},"maintenance":{"status":"stale","label":"3y since push","daysSincePush":920,"lastPushedAt":"2023-12-15T09:13:07+00:00"},"risk":{"level":"needs_review","label":"Needs review","requiresReview":true,"notes":["Permission surface may require sandboxing","Repository appears stale","Repository looks stale","Quality score needs review","Documentation summary is thin"]},"coverageTags":["Data","Database and SQL","data-analysis","sql","advisor","auditor","command-line","database"]},"audit":{"audit_score":74,"risk_level":"needs_review","risk_label":"Needs review","quality_score":80,"trust_score":80,"maintenance_score":20,"security_score":84,"install_score":92,"warnings":["Permission surface may require sandboxing","Repository appears stale","Repository looks stale","Quality score needs review","Documentation summary is thin","Permission surface needs review: shell or command execution, filesystem or document access","Recent maintenance: 3y since push","Permission surface: shell or command execution, filesystem or document access"]},"quality_signals":{"model":"v1","star_score":27.6,"usage_score":0,"review_score":11.7,"metadata_score":15,"freshness_score":0},"platforms":["Go","SQL","Claude Code"],"use_cases":[{"slug":"database-sql","title":"Database and SQL","url":"https://www.openagentskill.com/use-cases/database-sql"},{"slug":"coding-agents","title":"Coding agents","url":"https://www.openagentskill.com/use-cases/coding-agents"},{"slug":"rag-knowledge","title":"RAG and knowledge","url":"https://www.openagentskill.com/use-cases/rag-knowledge"},{"slug":"workflow-automation","title":"Workflow automation","url":"https://www.openagentskill.com/use-cases/workflow-automation"}],"stacks":[{"slug":"content-growth-agent","title":"Content growth agent","url":"https://www.openagentskill.com/collections/content-growth-agent"},{"slug":"coding-review-agent","title":"Coding review agent","url":"https://www.openagentskill.com/collections/coding-review-agent"},{"slug":"rag-knowledge-base","title":"RAG knowledge base","url":"https://www.openagentskill.com/collections/rag-knowledge-base"}],"install":"npx skills add XiaoMi/soar","install_targets":[{"id":"openagentskill-cli","label":"CLI","title":"OpenAgentSkill CLI","kind":"command","value":"npx skills add XiaoMi/soar","description":"Use the registry command when your workflow supports the OpenAgentSkill installer.","copyLabel":"Copy command"},{"id":"codex","label":"Codex","title":"Codex install prompt","kind":"agent-prompt","value":"Install the \"Soar\" agent skill from https://github.com/XiaoMi/soar. Read its SKILL.md or equivalent instructions first, install only the files needed for this workspace, and summarize any required setup before using it. Skill purpose: SQL Optimizer And Rewriter","description":"Give Codex a repo-aware install prompt when the skill is not available through a local CLI.","copyLabel":"Copy prompt"},{"id":"claude-code","label":"Claude Code","title":"Claude Code skill prompt","kind":"agent-prompt","value":"Add \"Soar\" as a Claude Code skill from https://github.com/XiaoMi/soar. Inspect the skill instructions, place the reusable skill files in the appropriate local skills location for this project, and report the activation steps. Skill purpose: SQL Optimizer And Rewriter","description":"Use this prompt to ask Claude Code to add the skill and explain the local activation steps.","copyLabel":"Copy prompt"},{"id":"cursor","label":"Cursor","title":"Cursor rule prompt","kind":"agent-prompt","value":"Turn \"Soar\" from https://github.com/XiaoMi/soar into a reusable Cursor project rule or agent instruction. Preserve the core workflow, adapt paths to this repo, and keep the rule scoped to tasks where it is relevant. Skill purpose: SQL Optimizer And Rewriter","description":"Use this when installing as Cursor project rules or reusable agent instructions.","copyLabel":"Copy prompt"}],"repository":"https://github.com/XiaoMi/soar","github_repo":"XiaoMi/soar","version":"1.0.0","license":"Apache-2.0","urls":{"web":"https://www.openagentskill.com/skills/xiaomi-soar","repository":"https://github.com/XiaoMi/soar","api":"/api/agent/skills/xiaomi-soar","install_api":"/api/skills/xiaomi-soar/install"},"meta":{"created_at":"2026-06-21T00:11:07.874326+00:00","updated_at":"2026-06-22T03:00:14.966334+00:00","agent_friendly":true}}