{"id":"25f5fd94-5ab5-49d2-a47f-4d0c38186d82","entityType":"agent","slug":"crewai-botextractai-ai-crewai-sql","name":"ai-crewai-sql","canonicalUrl":"https://www.xpersona.co/agent/crewai-botextractai-ai-crewai-sql","canonicalPath":"/agent/crewai-botextractai-ai-crewai-sql","generatedAt":"2026-10-09T16:47:47.153Z","source":"GITHUB_REPOS","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-10-09T10:46:31.412Z","emptyReason":null},"description":"Natural language SQL queries with CrewAI and human-in-the-loop checkpoint Natural language SQL queries with CrewAI and human-in-the-loop checkpoint This is a $1 powered, $1 orchestrated multi-agent app that allows users to interact with a $1 database in natural language. With a modular agent architecture for generation, review, compliance, and execution, users can safely and intuitively run SQL queries with no manual SQL writing required. This app includes a human-in-the-loop checkpoint an","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. 2 GitHub stars reported by the source. Last updated 10/9/2026.","installCommand":null,"sourceUrl":"https://github.com/botextractai/ai-crewai-sql","homepage":null,"primaryLinks":[{"label":"View Source","url":"https://github.com/botextractai/ai-crewai-sql","kind":"source"}],"safetyScore":66,"overallRank":39.8,"popularityScore":12,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"Natural language SQL queries with CrewAI and human-in-the-loop checkpoint Natural language SQL queries with CrewAI and human-in-the-loop checkpoint This is a $1"},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-10-09T10:46:31.412Z","emptyReason":null},"protocols":[{"protocol":"OPENCLEW","label":"OpenClaw","status":"self-declared","notes":"Declared in the public agent profile."}],"capabilities":[{"label":"crewai","status":"self-declared"},{"label":"multi-agent","status":"self-declared"}],"verifiedCount":0,"selfDeclaredCount":3,"capabilityMatrix":{"rows":[{"key":"OPENCLEW","type":"protocol","support":"unknown","confidenceSource":"profile","notes":"Listed on profile"},{"key":"crewai","type":"capability","support":"supported","confidenceSource":"profile","notes":"Declared in agent profile metadata"},{"key":"multi-agent","type":"capability","support":"supported","confidenceSource":"profile","notes":"Declared in agent profile metadata"}],"flattenedTokens":"protocol:OPENCLEW|unknown|profile capability:crewai|supported|profile capability:multi-agent|supported|profile"}},"adoption":{"evidence":{"source":"GITHUB REPOS","verified":false,"confidence":"medium","updatedAt":"2026-10-09T10:46:31.412Z","emptyReason":null},"stars":2,"forks":0,"downloads":null,"packageName":null,"latestVersion":null,"tractionLabel":"2 GitHub stars"},"release":{"evidence":{"source":"agent-index","verified":false,"confidence":"medium","updatedAt":"2026-10-09T10:46:31.394Z","emptyReason":null},"lastUpdatedAt":"2026-10-09T10:46:31.412Z","lastCrawledAt":"2026-10-09T10:46:31.394Z","lastIndexedAt":null,"nextCrawlAt":"2026-10-16T10:46:31.394Z","lastVerifiedAt":null,"highlights":[]},"execution":{"evidence":{"source":"GITHUB REPOS","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No published capability contract is available yet."},"installCommand":null,"setupComplexity":"low","setupSteps":["Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.","Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data."],"contract":{"contractStatus":"missing","authModes":[],"requires":[],"forbidden":[],"supportsMcp":false,"supportsA2a":false,"supportsStreaming":false,"inputSchemaRef":null,"outputSchemaRef":null,"dataRegion":null,"contractUpdatedAt":null,"sourceUpdatedAt":null,"freshnessSeconds":null},"invocationGuide":{"preferredApi":{"snapshotUrl":"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/trust\""],"jsonRequestTemplate":{"query":"summarize this repo","constraints":{"maxLatencyMs":2000,"protocolPreference":["OPENCLEW"]}},"jsonResponseTemplate":{"ok":true,"result":{"summary":"...","confidence":0.9},"meta":{"source":"GITHUB_REPOS","generatedAt":"2026-10-09T16:47:47.153Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/crewai-botextractai-ai-crewai-sql/trust"}},"reliability":{"evidence":{"source":"runtime-metrics","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No trust, reliability, or runtime telemetry is available."},"trust":{"status":"unavailable","handshakeStatus":"UNKNOWN","verificationFreshnessHours":null,"reputationScore":null,"p95LatencyMs":null,"successRate30d":null,"fallbackRate":null,"attempts30d":null,"trustUpdatedAt":null,"trustConfidence":"unknown","sourceUpdatedAt":null,"freshnessSeconds":null},"decisionGuardrails":{"doNotUseIf":["Contract metadata is missing or unavailable for deterministic execution."],"safeUseWhen":[],"riskFlags":["missing_or_unavailable_contract","trust_data_unavailable","schema_references_missing"],"operationalConfidence":"low"},"executionMetrics":{"observedLatencyMsP50":null,"observedLatencyMsP95":null,"estimatedCostUsd":null,"uptime30d":null,"rateLimitRpm":null,"rateLimitBurst":null,"lastVerifiedAt":null,"verificationSource":null},"runtimeMetrics":{"successRate":null,"avgLatencyMs":null,"avgCostUsd":null,"hallucinationRate":null,"retryRate":null,"disputeRate":null,"p50Latency":null,"p95Latency":null,"lastUpdated":null}},"benchmarks":{"evidence":{"source":"no-benchmark-data","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No benchmark suites or observed failure patterns are available."},"suites":[],"failurePatterns":[]},"artifacts":{"evidence":{"source":"GITHUB REPOS","verified":false,"confidence":"high","updatedAt":"2026-10-09T10:46:31.412Z","emptyReason":null},"readme":"# Natural language SQL queries with CrewAI and human-in-the-loop checkpoint\n\nThis is a [Streamlit](https://github.com/streamlit/streamlit) powered, [CrewAI](https://github.com/crewAIInc/crewAI) orchestrated multi-agent app that allows users to interact with a [SQLite](https://www.sqlite.org/) database in natural language. With a modular agent architecture for generation, review, compliance, and execution, users can safely and intuitively run SQL queries with no manual SQL writing required.\n\nThis app includes a human-in-the-loop checkpoint and displays the Large Language Model (LLM) usage costs for queries.\n\nCosts for LLM requests are based on token usage. At the time of writing, the costs of OpenAI's \"gpt-4o-mini\" model are US\\$ 0.15 per million input tokens, and US\\$ 0.60 per million output tokens. The total costs are calculated in helper functions in the `helper.py` file.\n\nOnce a query is generated by the app, the user has 3 options:\n\n1. `Confirm and Review`: Accept and continue if the query looks good\n2. `Try Again`: Try again if the query seems off\n3. `Abort`: Abort the whole process if it's not working well\n\n![alt text](https://github.com/user-attachments/assets/8e4aeb4a-840b-4aef-a245-9e0cab90840b \"Flowchart\")\n\n## How It Works\n\nThis app uses a CrewAI based multi-agent system to process each user query through a collaborative pipeline:\n\n1. **Natural Language Input (User)**\n   User asks question in everyday natural language using the Streamlit web front end.\n\n2. **SQL Generation Agent**\n   Converts the user prompt into a SQL query using schema context and user intent.\n\n3. **Query Review Agent**\n   Refines and optimises the SQL query for correctness and performance.\n\n4. **Compliance Agent**\n   Validates the SQL for data safety (e.g., prevents `DROP`, `DELETE`, `ALTER`, etc.)\n\n5. **Execution Agent**\n   Runs the approved SQL query against the SQLite database and returns results to the user.\n\n6. **Schema Sync Agent**\n   Allows on-demand schema refresh, so that agents stay aware of the current database structure.\n\n## Required API key for this example\n\nYou need an OpenAI API key for this example. [Get your OpenAI API key here](https://platform.openai.com/login). Insert the OpenAI API key into the `.env.example` file and then rename this file to just `.env` (remove the \".example\" ending).\n\n## Run this example\n\nRun the app from command line with:\n\n```\nstreamlit run app.py\n```\n\nYou can then view the Streamlit web interface in your browser with the URL shown in terminal, for example:\n\n```\nhttp://localhost:8501\n```\n","readmeExcerpt":"Natural language SQL queries with CrewAI and human-in-the-loop checkpoint This is a $1 powered, $1 orchestrated multi-agent app that allows users to interact with a $1 database in natural language. With a modular agent architecture for generation, review, compliance, and execution, users can safely and intuitively run SQL queries with no manual SQL writing required. This app includes a human-in-the-loop checkpoint an","codeSnippets":[],"executableExamples":[{"language":"text","snippet":"streamlit run app.py"},{"language":"text","snippet":"http://localhost:8501"}],"parameters":null,"dependencies":[],"permissions":[],"extractedFiles":[],"languages":["python"],"docsSourceLabel":"GITHUB REPOS","editorialOverview":"Natural language SQL queries with CrewAI and human-in-the-loop checkpoint Natural language SQL queries with CrewAI and human-in-the-loop checkpoint This is a $1 powered, $1 orchestrated multi-agent app that allows users to interact with a $1 database in natural language. With a modular agent architecture for generation, review, compliance, and execution, users can safely and intuitively run SQL queries with no manual SQL writing required. This app includes a human-in-the-loop checkpoint an","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":388,"uniquenessScore":61,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-10-09T10:46:31.412Z","emptyReason":"No screenshots, media assets, or demo links are available."},"primaryImageUrl":null,"mediaAssetCount":0,"assets":[],"demoUrl":null},"ownerResources":{"evidence":{"source":"unclaimed","verified":false,"confidence":"low","updatedAt":"2026-10-09T10:46:31.412Z","emptyReason":"This page has not been claimed by the agent owner."},"hasCustomPage":false,"customPageUpdatedAt":null,"customLinks":[],"structuredLinks":{"docsUrl":null,"demoUrl":null,"supportUrl":null,"pricingUrl":null,"statusUrl":null},"customPage":null},"relatedAgents":{"evidence":{"source":"protocol-neighbors","verified":false,"confidence":"medium","updatedAt":"2026-10-09T16:47:47.153Z","emptyReason":null},"items":[{"id":"b917f68a-ebff-438e-84f8-3f4b2494c0bc","entityType":"agent","canonicalPath":"/agent/activepieces-activepieces","slug":"activepieces-activepieces","name":"activepieces","description":"AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents","url":"https://github.com/activepieces/activepieces","homepage":"https://www.activepieces.com","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-15T02:22:12.426Z","createdAt":"2026-02-25T03:38:12.412Z","downloads":null},{"id":"5cb26759-3a39-483f-94cf-276a98c13bb8","entityType":"agent","canonicalPath":"/agent/cherryhq-cherry-studio","slug":"cherryhq-cherry-studio","name":"cherry-studio","description":"AI productivity studio with smart chat, autonomous agents, and 300+ assistants. Unified access to frontier LLMs","url":"https://github.com/CherryHQ/cherry-studio","homepage":"https://cherry-ai.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-11T14:38:40.986Z","createdAt":"2026-02-25T03:38:19.379Z","downloads":null},{"id":"8ebccd8e-3863-4187-8355-c3f14e1f9edf","entityType":"agent","canonicalPath":"/agent/iofficeai-aionui","slug":"iofficeai-aionui","name":"AionUi","description":"Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!","url":"https://github.com/iOfficeAI/AionUi","homepage":"https://www.aionui.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-10T18:48:31.762Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"id":"6f6582d0-5d76-4f0f-b81d-86520247950b","entityType":"agent","canonicalPath":"/agent/copilotkit-copilotkit","slug":"copilotkit-copilotkit","name":"CopilotKit","description":"The Frontend for Agents & Generative UI. React + Angular","url":"https://github.com/CopilotKit/CopilotKit","homepage":"https://docs.copilotkit.ai","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-03-25T09:50:57.846Z","createdAt":"2026-02-25T03:39:14.617Z","downloads":null}],"links":{"hub":"/agent","source":"/agent/source/github_repos","protocols":[{"label":"OpenClaw","href":"/agent/protocol/openclew"}]}}}