{"slug":"nlpchina-elasticsearch-sql","name":"Elasticsearch Sql","description":"Use SQL to query Elasticsearch","tagline":"Use SQL to query Elasticsearch","category":"data-analysis","tags":["sql","data-analysis","data","elasticsearch","java","github"],"author":{"name":"NLPchina","verified":true,"url":"https://github.com/NLPchina"},"attribution":{"status":"community_indexed","statusLabel":"Community indexed","shortLabel":"COMMUNITY INDEXED","sourceLabel":"GitHub star discovery","sourceDetail":"NLPchina/elasticsearch-sql","creatorName":"NLPchina","creatorUrl":"https://github.com/NLPchina","sourceUrl":"https://github.com/NLPchina/elasticsearch-sql","indexedBy":"OpenAgentSkill community index","claimUrl":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql#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":7014,"forks":1531,"downloads":0,"rating":0,"review_count":0,"quality_score":65.62},"quality":{"score":100,"tier":"excellent","label":"Excellent","summary":"High-confidence pick with strong adoption and healthy maintenance signals.","signals":[{"label":"GitHub stars","value":"7.0K","tone":"positive"},{"label":"Freshness","value":"3mo ago","tone":"positive"},{"label":"Install ready","value":"Yes","tone":"positive"},{"label":"License","value":"Apache-2.0","tone":"neutral"}],"warnings":[]},"trust":{"version":"trust-score-v4","score":86,"tier":"production","label":"Production candidate","summary":"Strong OpenAgentSkill Trust Score across adoption, recent maintenance, license clarity, documentation, dependency/runtime risk, install safety, permission surface, and install availability.","recommendedAction":"Shortlist for production use, then run a normal repository and dependency review.","dimensions":[{"id":"github_adoption","label":"GitHub adoption","score":94,"weight":0.13,"status":"pass","detail":"7.0K GitHub stars"},{"id":"repo_activity","label":"Stars/forks activity","score":93,"weight":0.08,"status":"pass","detail":"7.0K stars, 1.5K forks; issue activity unavailable in current metadata"},{"id":"maintenance","label":"Recent maintenance","score":76,"weight":0.14,"status":"info","detail":"3mo 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 NLPchina/elasticsearch-sql"},{"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":74,"weight":0.07,"status":"info","detail":"filesystem or document access, database access"},{"id":"repository","label":"Repository evidence","score":86,"weight":0.04,"status":"pass","detail":"https://github.com/NLPchina/elasticsearch-sql"},{"id":"review_status","label":"Review status","score":88,"weight":0.05,"status":"pass","detail":"AI review data available"},{"id":"agent_outcomes","label":"Agent Proven outcomes","score":54,"weight":0.13,"status":"info","detail":"No agent outcome data yet"}],"checks":[{"status":"pass","label":"GitHub adoption","detail":"7.0K GitHub stars"},{"status":"pass","label":"Stars/forks activity","detail":"7.0K stars, 1.5K forks; issue activity unavailable in current metadata"},{"status":"info","label":"Recent maintenance","detail":"3mo 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 NLPchina/elasticsearch-sql"},{"status":"pass","label":"Install command safety","detail":"standard package or runtime install path"},{"status":"info","label":"Permission surface","detail":"filesystem or document access, database access"},{"status":"pass","label":"Repository evidence","detail":"https://github.com/NLPchina/elasticsearch-sql"},{"status":"pass","label":"Review status","detail":"AI review data available"},{"status":"info","label":"Agent Proven outcomes","detail":"No agent outcome data yet"},{"status":"pass","label":"Ownership","detail":"Listing manually verified"},{"status":"info","label":"OpenAgentSkill usage","detail":"No local usage activity yet"},{"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":["Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"],"evidence":{"stars":"7.0K GitHub stars","repoActivity":"7.0K stars, 1.5K forks","lastPushed":"3mo since push","license":"Apache-2.0","repository":"https://github.com/NLPchina/elasticsearch-sql","install":"npx skills add NLPchina/elasticsearch-sql","installSafety":"standard package or runtime install path","permissionSurface":"filesystem or document access, database access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"installReadiness":{"ready":true,"command":"npx skills add NLPchina/elasticsearch-sql","policy":"human_review_before_install","label":"Human review before install","notes":["Install path is available","Repository evidence is available","License is declared","No Agent Proven outcome evidence yet","3mo since push","Financial domain: human review is required before use in a live investment workflow."]},"agentCompatibility":["Java","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI"],"riskSummary":{"level":"medium","label":"Review before production","notes":["Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"]},"outcomeEvidence":{"total":0,"successes":0,"failures":0,"notRelevant":0,"successRate":null,"installAttempts":0,"riskBlocked":0,"setupRequired":0,"installSuccessRate":null,"avgOutputQuality":null,"avgTimeToUsefulMs":null,"productionOutcomes":0,"humanReviewRequired":0,"recentSuccessRate":null,"recentFailureRate":null,"uniqueAgents":0,"agentProvenScore":0,"agentProvenLabel":"Needs first agent run","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","elasticsearch","java","github"],"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","Autonomous investment, trading, tax, or suitability decisions without a qualified human review"],"knownRisks":["Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"]},"safety":{"score":69,"level":"review_before_install","label":"Review before install","safety_tier":{"tier":"reviewed","label":"Reviewed with permission notes","badge":"REVIEWED","summary":"Usable candidate, but the agent should surface permission and audit notes before installation.","recommended_action":"Require human approval before installing into a real workspace.","auto_install_policy":"review","reasons":["Financial research output is not financial advice; require human review before any live investment decision","69/100 agent safety score"]},"auto_install_allowed":false,"human_review_required":true,"blocked":false,"audit_risk":"needs_review","permission_hints":[{"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":["Financial research output is not financial advice; require human review before any live investment decision"],"constraints_applied":{"max_risk":"medium","needs_install_command":true,"min_stars":0}},"safety_gate":{"tier":"reviewed","label":"Reviewed with permission notes","badge":"REVIEWED","auto_install_policy":"review","auto_install_allowed":false,"human_review_required":true,"blocked":false,"recommended_action":"Require human approval before installing into a real workspace.","reasons":["Financial research output is not financial advice; require human review before any live investment decision","69/100 agent safety score"]},"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":"RAG and knowledge","description":"I need my agent to build a RAG workflow over documents and retrieve reliable context.","useCases":[{"slug":"rag-knowledge","title":"RAG and knowledge"},{"slug":"coding-agents","title":"Coding agents"},{"slug":"research-agents","title":"Research agents"}]},"applicableAgents":["Claude Code","CLI","Codex","Cursor","Java"],"install":{"ready":true,"command":"npx skills add NLPchina/elasticsearch-sql","primaryTarget":"CLI","targetCount":4},"githubQuality":{"stars":7014,"starsLabel":"7.0K","forks":1531,"license":"Apache-2.0","qualityScore":100,"trustScore":86,"auditScore":89},"maintenance":{"status":"active","label":"3mo since push","daysSincePush":98,"lastPushedAt":"2026-05-04T10:59:18+00:00"},"risk":{"level":"needs_review","label":"Needs review","requiresReview":true,"notes":["Financial research output is not financial advice; require human review before any live investment decision","Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin","Needs review"]},"coverageTags":["Data","RAG and knowledge","data-analysis","sql","elasticsearch","java","github"]},"audit":{"audit_score":89,"risk_level":"needs_review","risk_label":"Needs review","warnings":["Financial research output is not financial advice; require human review before any live investment decision","Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"]},"decision":{"readiness_score":100,"readiness_label":"Production-ready","headline":"Primary pick for RAG and knowledge","role":"Primary pick","primary_fit":"RAG and knowledge","best_for":["RAG and knowledge workflows","Claude Code teams","teams that value GitHub adoption signals"],"risks":["No OpenAgentSkill engagement data yet"],"next_steps":["Install it in a sandbox agent and run one RAG and knowledge task end to end.","Compare output quality, latency, and failure behavior against at least one alternative.","Promote it into production only after reviewing repository permissions, license, and maintenance signals."]},"agent_readable_metadata":{"version":"openagentskill-agent-metadata-v2","skill":{"slug":"nlpchina-elasticsearch-sql","name":"Elasticsearch Sql","description":"Use SQL to query Elasticsearch","category":"data-analysis","url":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql","repository":"https://github.com/NLPchina/elasticsearch-sql","github_repo":"NLPchina/elasticsearch-sql"},"suited_tasks":["RAG and knowledge workflows","Claude Code teams","teams that value GitHub adoption signals","Chunk documents","Create embeddings","Retrieve and cite relevant passages","Inspect source files","Explain architecture"],"suited_agents":["Java","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI","CLI"],"install":{"command":"npx skills add NLPchina/elasticsearch-sql","ready":true,"targets":[{"id":"openagentskill-cli","label":"CLI","kind":"command","value":"npx skills add NLPchina/elasticsearch-sql"},{"id":"codex","label":"Codex","kind":"agent-prompt","value":"Install the \"Elasticsearch Sql\" agent skill from https://github.com/NLPchina/elasticsearch-sql. 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"codex\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes."},{"id":"claude-code","label":"Claude Code","kind":"agent-prompt","value":"Add \"Elasticsearch Sql\" as a Claude Code skill from https://github.com/NLPchina/elasticsearch-sql. 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"claude-code\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes."},{"id":"cursor","label":"Cursor","kind":"agent-prompt","value":"Turn \"Elasticsearch Sql\" from https://github.com/NLPchina/elasticsearch-sql 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"cursor\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes."}],"handoff_url":"https://www.openagentskill.com/api/skills/nlpchina-elasticsearch-sql/install","manifest_url":"https://www.openagentskill.com/api/registry/manifest/nlpchina-elasticsearch-sql"},"trust":{"score":86,"label":"Production candidate","version":"trust-score-v4","install_policy":"human_review_before_install","evidence":{"stars":"7.0K GitHub stars","repoActivity":"7.0K stars, 1.5K forks","lastPushed":"3mo since push","license":"Apache-2.0","repository":"https://github.com/NLPchina/elasticsearch-sql","install":"npx skills add NLPchina/elasticsearch-sql","installSafety":"standard package or runtime install path","permissionSurface":"filesystem or document access, database access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"outcome_evidence":{"total":0,"successes":0,"failures":0,"not_relevant":0,"success_rate":null,"recent_success_rate":null,"recent_failure_rate":null,"install_attempts":0,"install_success_rate":null,"risk_blocked":0,"setup_required":0,"avg_output_quality":null,"production_outcomes":0,"last_outcome_at":null,"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","elasticsearch","java","github"],"known_risks":["Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"]},"agent_proven":{"version":"agent-proven-v1","score":0,"tier":"unproven","label":"Needs first agent run","summary":"No agent outcome reports yet. Use Resolve, run one narrow sandbox task, then report the result.","metrics":{"totalOutcomes":0,"successfulOutcomes":0,"failedOutcomes":0,"installAttempts":0,"installSuccessRate":null,"successRate":null,"recentSuccessRate":null,"recentFailureRate":null,"riskBlocked":0,"setupRequired":0,"notRelevant":0,"avgOutputQuality":null,"avgTimeToUsefulMs":null,"productionOutcomes":0,"humanReviewRequired":0,"uniqueAgents":0,"lastOutcomeAt":null},"signals":[],"penalties":["No real agent outcome evidence yet"]},"audit":{"score":89,"risk_level":"needs_review","risk_label":"Needs review","warnings":["Financial research output is not financial advice; require human review before any live investment decision","Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"]},"safety_gate":{"tier":"reviewed","label":"Reviewed with permission notes","auto_install_policy":"review","auto_install_allowed":false,"human_review_required":true,"blocked":false,"recommended_action":"Require human approval before installing into a real workspace."},"quality":{"score":100,"label":"Excellent"},"supply":{"track":"Data, BI, and analytics","scenario":"RAG and knowledge","maintenance":"3mo since push","risk":"Needs review"},"alternative_skills":[],"do_not_use_when":["teams that need a vendor-supported SLA","high-compliance environments without internal security review","No OpenAgentSkill engagement data yet","Financial research output is not financial advice; require human review before any live investment decision","Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin","Production credentials, payments, or irreversible account changes without explicit human review","Sensitive private data before reviewing repository code, license, and permission surface"],"agent_contract":{"task_input":"Use Elasticsearch Sql in an agent workflow","recommended_action":"Require human approval before installing into a real workspace.","install_policy":"review","minimum_review_before_use":["Trust: 86/100 Production candidate","Audit: 89/100 Needs review","Safety: 69/100 Review before install","Review repository, license, install command, and permission surface before production use."],"expected_agent_output":{"selected_skill":"nlpchina-elasticsearch-sql (Elasticsearch Sql)","install_command":"npx skills add NLPchina/elasticsearch-sql","risk_summary":"Needs review; Reviewed with permission notes; Review before production","verification_result":"Report the smallest successful task, files touched, warnings, and any missing setup."}},"outcome_feedback":{"endpoint":"https://www.openagentskill.com/api/agent/outcome","method":"POST","requires_resolve_event_id":true,"event_id_source":"Use install_receipt.outcome_feedback.event_id or feedback.event_id returned by /api/agent/resolve for the current task.","expected_outcomes":["success","failed","not_relevant","blocked_by_risk","setup_required"],"payload_template":{"event_id":"<install_receipt.outcome_feedback.event_id or feedback.event_id from /api/agent/resolve>","skill_slug":"nlpchina-elasticsearch-sql","task":"Use Elasticsearch Sql in an agent workflow","agent":"codex","outcome":"success","install_used":true,"risk_blocked":false,"setup_required":false,"task_success":true,"output_quality":4,"error_type":null,"human_review_required":false,"workspace":"sandbox","time_to_useful_ms":120000,"notes":"Report the smallest successful task, setup friction, files touched, and risk notes."}},"endpoints":{"web":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql","api":"https://www.openagentskill.com/api/agent/skills/nlpchina-elasticsearch-sql","audit":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql/audit","eval":"https://www.openagentskill.com/api/agent/evals?slug=nlpchina-elasticsearch-sql&task=Use%20Elasticsearch%20Sql%20in%20an%20agent%20workflow&max_risk=medium","resolve":"https://www.openagentskill.com/api/agent/resolve?task=Use%20Elasticsearch%20Sql%20in%20an%20agent%20workflow&agent=codex&max_risk=medium","receipt":"https://www.openagentskill.com/api/agent/receipt?task=Use%20Elasticsearch%20Sql%20in%20an%20agent%20workflow&agent=codex&max_risk=medium&format=text","install":"https://www.openagentskill.com/api/skills/nlpchina-elasticsearch-sql/install","manifest":"https://www.openagentskill.com/api/registry/manifest/nlpchina-elasticsearch-sql"}},"machine_metadata":{"version":"openagentskill-agent-metadata-v2","skill":{"slug":"nlpchina-elasticsearch-sql","name":"Elasticsearch Sql","description":"Use SQL to query Elasticsearch","category":"data-analysis","url":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql","repository":"https://github.com/NLPchina/elasticsearch-sql","github_repo":"NLPchina/elasticsearch-sql"},"suited_tasks":["RAG and knowledge workflows","Claude Code teams","teams that value GitHub adoption signals","Chunk documents","Create embeddings","Retrieve and cite relevant passages","Inspect source files","Explain architecture"],"suited_agents":["Java","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI","CLI"],"install":{"command":"npx skills add NLPchina/elasticsearch-sql","ready":true,"targets":[{"id":"openagentskill-cli","label":"CLI","kind":"command","value":"npx skills add NLPchina/elasticsearch-sql"},{"id":"codex","label":"Codex","kind":"agent-prompt","value":"Install the \"Elasticsearch Sql\" agent skill from https://github.com/NLPchina/elasticsearch-sql. 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"codex\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes."},{"id":"claude-code","label":"Claude Code","kind":"agent-prompt","value":"Add \"Elasticsearch Sql\" as a Claude Code skill from https://github.com/NLPchina/elasticsearch-sql. 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"claude-code\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes."},{"id":"cursor","label":"Cursor","kind":"agent-prompt","value":"Turn \"Elasticsearch Sql\" from https://github.com/NLPchina/elasticsearch-sql 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"cursor\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes."}],"handoff_url":"https://www.openagentskill.com/api/skills/nlpchina-elasticsearch-sql/install","manifest_url":"https://www.openagentskill.com/api/registry/manifest/nlpchina-elasticsearch-sql"},"trust":{"score":86,"label":"Production candidate","version":"trust-score-v4","install_policy":"human_review_before_install","evidence":{"stars":"7.0K GitHub stars","repoActivity":"7.0K stars, 1.5K forks","lastPushed":"3mo since push","license":"Apache-2.0","repository":"https://github.com/NLPchina/elasticsearch-sql","install":"npx skills add NLPchina/elasticsearch-sql","installSafety":"standard package or runtime install path","permissionSurface":"filesystem or document access, database access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"outcome_evidence":{"total":0,"successes":0,"failures":0,"not_relevant":0,"success_rate":null,"recent_success_rate":null,"recent_failure_rate":null,"install_attempts":0,"install_success_rate":null,"risk_blocked":0,"setup_required":0,"avg_output_quality":null,"production_outcomes":0,"last_outcome_at":null,"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","elasticsearch","java","github"],"known_risks":["Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"]},"agent_proven":{"version":"agent-proven-v1","score":0,"tier":"unproven","label":"Needs first agent run","summary":"No agent outcome reports yet. Use Resolve, run one narrow sandbox task, then report the result.","metrics":{"totalOutcomes":0,"successfulOutcomes":0,"failedOutcomes":0,"installAttempts":0,"installSuccessRate":null,"successRate":null,"recentSuccessRate":null,"recentFailureRate":null,"riskBlocked":0,"setupRequired":0,"notRelevant":0,"avgOutputQuality":null,"avgTimeToUsefulMs":null,"productionOutcomes":0,"humanReviewRequired":0,"uniqueAgents":0,"lastOutcomeAt":null},"signals":[],"penalties":["No real agent outcome evidence yet"]},"audit":{"score":89,"risk_level":"needs_review","risk_label":"Needs review","warnings":["Financial research output is not financial advice; require human review before any live investment decision","Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin"]},"safety_gate":{"tier":"reviewed","label":"Reviewed with permission notes","auto_install_policy":"review","auto_install_allowed":false,"human_review_required":true,"blocked":false,"recommended_action":"Require human approval before installing into a real workspace."},"quality":{"score":100,"label":"Excellent"},"supply":{"track":"Data, BI, and analytics","scenario":"RAG and knowledge","maintenance":"3mo since push","risk":"Needs review"},"alternative_skills":[],"do_not_use_when":["teams that need a vendor-supported SLA","high-compliance environments without internal security review","No OpenAgentSkill engagement data yet","Financial research output is not financial advice; require human review before any live investment decision","Financial research output is not financial advice; require human review before any live investment decision.","Documentation summary is thin","Production credentials, payments, or irreversible account changes without explicit human review","Sensitive private data before reviewing repository code, license, and permission surface"],"agent_contract":{"task_input":"Use Elasticsearch Sql in an agent workflow","recommended_action":"Require human approval before installing into a real workspace.","install_policy":"review","minimum_review_before_use":["Trust: 86/100 Production candidate","Audit: 89/100 Needs review","Safety: 69/100 Review before install","Review repository, license, install command, and permission surface before production use."],"expected_agent_output":{"selected_skill":"nlpchina-elasticsearch-sql (Elasticsearch Sql)","install_command":"npx skills add NLPchina/elasticsearch-sql","risk_summary":"Needs review; Reviewed with permission notes; Review before production","verification_result":"Report the smallest successful task, files touched, warnings, and any missing setup."}},"outcome_feedback":{"endpoint":"https://www.openagentskill.com/api/agent/outcome","method":"POST","requires_resolve_event_id":true,"event_id_source":"Use install_receipt.outcome_feedback.event_id or feedback.event_id returned by /api/agent/resolve for the current task.","expected_outcomes":["success","failed","not_relevant","blocked_by_risk","setup_required"],"payload_template":{"event_id":"<install_receipt.outcome_feedback.event_id or feedback.event_id from /api/agent/resolve>","skill_slug":"nlpchina-elasticsearch-sql","task":"Use Elasticsearch Sql in an agent workflow","agent":"codex","outcome":"success","install_used":true,"risk_blocked":false,"setup_required":false,"task_success":true,"output_quality":4,"error_type":null,"human_review_required":false,"workspace":"sandbox","time_to_useful_ms":120000,"notes":"Report the smallest successful task, setup friction, files touched, and risk notes."}},"endpoints":{"web":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql","api":"https://www.openagentskill.com/api/agent/skills/nlpchina-elasticsearch-sql","audit":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql/audit","eval":"https://www.openagentskill.com/api/agent/evals?slug=nlpchina-elasticsearch-sql&task=Use%20Elasticsearch%20Sql%20in%20an%20agent%20workflow&max_risk=medium","resolve":"https://www.openagentskill.com/api/agent/resolve?task=Use%20Elasticsearch%20Sql%20in%20an%20agent%20workflow&agent=codex&max_risk=medium","receipt":"https://www.openagentskill.com/api/agent/receipt?task=Use%20Elasticsearch%20Sql%20in%20an%20agent%20workflow&agent=codex&max_risk=medium&format=text","install":"https://www.openagentskill.com/api/skills/nlpchina-elasticsearch-sql/install","manifest":"https://www.openagentskill.com/api/registry/manifest/nlpchina-elasticsearch-sql"}},"platforms":["Java","SQL","Claude Code"],"use_cases":[{"slug":"rag-knowledge","title":"RAG and knowledge","url":"https://www.openagentskill.com/use-cases/rag-knowledge"},{"slug":"coding-agents","title":"Coding agents","url":"https://www.openagentskill.com/use-cases/coding-agents"},{"slug":"research-agents","title":"Research agents","url":"https://www.openagentskill.com/use-cases/research-agents"},{"slug":"workflow-automation","title":"Workflow automation","url":"https://www.openagentskill.com/use-cases/workflow-automation"}],"install":"npx skills add NLPchina/elasticsearch-sql","install_targets":[{"id":"openagentskill-cli","label":"CLI","title":"OpenAgentSkill CLI","kind":"command","value":"npx skills add NLPchina/elasticsearch-sql","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 \"Elasticsearch Sql\" agent skill from https://github.com/NLPchina/elasticsearch-sql. 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"codex\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes.","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 \"Elasticsearch Sql\" as a Claude Code skill from https://github.com/NLPchina/elasticsearch-sql. 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"claude-code\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes.","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 \"Elasticsearch Sql\" from https://github.com/NLPchina/elasticsearch-sql 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: Use SQL to query Elasticsearch After the install attempt, report the result to https://www.openagentskill.com/api/agent/outcome with POST JSON {\"event_id\":\"install_<unique-id>\",\"skill_slug\":\"nlpchina-elasticsearch-sql\",\"task\":\"Install Elasticsearch Sql\",\"agent\":\"cursor\",\"outcome\":\"success\",\"install_used\":true}. Replace event_id with a unique value and outcome with success or failed. Report success only after the skill is installed and a minimal verification passes.","description":"Use this when installing as Cursor project rules or reusable agent instructions.","copyLabel":"Copy prompt"}],"repository":"https://github.com/NLPchina/elasticsearch-sql","github_repo":"NLPchina/elasticsearch-sql","version":"1.0.0","license":"Apache-2.0","updated_at":"2026-06-22T03:01:21.899691+00:00","canonical_key":"nlpchina/elasticsearch-sql","recommendation_reasons":["Useful GitHub adoption: 7,014 stars","Install handoff is available","Repository freshness signal is available"],"urls":{"web":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql","api":"https://www.openagentskill.com/api/agent/skills/nlpchina-elasticsearch-sql","install_api":"https://www.openagentskill.com/api/skills/nlpchina-elasticsearch-sql/install","audit":"https://www.openagentskill.com/skills/nlpchina-elasticsearch-sql/audit","repository":"https://github.com/NLPchina/elasticsearch-sql"},"meta":{"endpoint":"/api/registry/manifest/{slug}","canonical_agent_endpoint":"/api/agent/skills/nlpchina-elasticsearch-sql","agent_friendly":true,"api_version":"1.0","generated_at":"2026-08-11T00:29:06.950Z"}}