{"id":"4119a5fd-a2fe-4bf1-9ced-87b330b2d50b","entityType":"agent","slug":"crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases","name":"db2-enterprise-ai-use-cases","canonicalUrl":"https://www.xpersona.co/agent/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases","canonicalPath":"/agent/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases","generatedAt":"2026-10-10T07:59:40.573Z","source":"GITHUB_REPOS","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-10-09T11:50:37.999Z","emptyReason":null},"description":"Practical enterprise AI use cases with IBM Db2 using Haystack, LangChain, and CrewAI. IBM Db2 AI Use Cases 20 enterprise-grade AI examples on IBM Db2 using Haystack, LangChain, and CrewAI. Designed to be production-ready reference implementations and learning resources. --- What this repository demonstrates --- Requirements - Python 3.10+ - IBM Db2 (IBM FyRe or local Docker) - $1 with granite3.1-dense:8b pulled (used as the primary LLM) - IBM VPN (if connecting to FyRe) --- Quick start --- Repository","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. Last updated 10/9/2026.","installCommand":null,"sourceUrl":"https://github.com/DhruvChaturvediIBM/db2-enterprise-ai-use-cases","homepage":null,"primaryLinks":[{"label":"View Source","url":"https://github.com/DhruvChaturvediIBM/db2-enterprise-ai-use-cases","kind":"source"}],"safetyScore":66,"overallRank":34.4,"popularityScore":0,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"Practical enterprise AI use cases with IBM Db2 using Haystack, LangChain, and CrewAI. IBM Db2 AI Use Cases 20 enterprise-grade AI examples on IBM Db2 using Hays"},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-10-09T11:50:37.999Z","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":"no-adoption-signals","verified":false,"confidence":"low","updatedAt":"2026-10-09T11:50:37.999Z","emptyReason":"No source adoption metrics were available."},"stars":0,"forks":0,"downloads":null,"packageName":null,"latestVersion":null,"tractionLabel":null},"release":{"evidence":{"source":"agent-index","verified":false,"confidence":"medium","updatedAt":"2026-10-09T11:50:37.994Z","emptyReason":null},"lastUpdatedAt":"2026-10-09T11:50:37.999Z","lastCrawledAt":"2026-10-09T11:50:37.994Z","lastIndexedAt":null,"nextCrawlAt":"2026-10-16T11:50:37.994Z","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-dhruvchaturvediibm-db2-enterprise-ai-use-cases/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/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-10T07:59:40.573Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/crewai-dhruvchaturvediibm-db2-enterprise-ai-use-cases/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-09T11:50:37.999Z","emptyReason":null},"readme":"# IBM Db2 AI Use Cases\n\n> 20 enterprise-grade AI examples on IBM Db2 using Haystack, LangChain, and CrewAI.  \n> Designed to be production-ready reference implementations and learning resources.\n\n---\n\n## What this repository demonstrates\n\n```\nIBM Db2\n  |\n  +-- structured enterprise data\n  +-- documents / knowledge\n  +-- metadata\n  +-- native VECTOR storage\n  +-- vector similarity\n  |\n  +-------------------------------+\n                                  |\n                         AI framework layer\n                                  |\n             +--------------------+--------------------+\n             |                    |                    |\n          Haystack             LangChain            CrewAI\n             |                    |                    |\n        pipelines             VectorStore             tools\n        retrieval             search/MMR              agents\n        reranking             scores                  crews\n```\n\n---\n\n## Requirements\n\n- Python 3.10+\n- IBM Db2 (IBM FyRe or local Docker)\n- [Ollama](https://ollama.com/) with `granite3.1-dense:8b` pulled (used as the primary LLM)\n- IBM VPN (if connecting to FyRe)\n\n---\n\n## Quick start\n\n```bash\n# 1. Clone\ngit clone <repo-url>\ncd ibm-db2-ai-use-cases\n\n# 2. Install all dependencies (Python + IBM Db2 drivers + AI frameworks)\nbash install.sh\n\n# 3. Configure environment\ncp .env.example .env\n# Edit .env with your Db2 credentials\n\n# 4. Pull the Ollama Granite model\nollama pull granite3.1-dense:8b\n\n# 5. Run any use case\ncd 01_enterprise_knowledge_rag\npython main.py\n```\n\n---\n\n## Repository structure\n\n```\nibm-db2-ai-use-cases/\n│\n├── README.md                    ← this file\n├── install.sh                   ← one-command setup script\n├── requirements.txt             ← all Python dependencies\n├── .env.example                 ← environment variable template\n├── .gitignore\n│\n├── common/                      ← shared utilities (reused by all UCs)\n│   ├── db2.py                   ← Db2 connection helper\n│   ├── embeddings.py            ← embedding helper (Ollama + sentence-transformers)\n│   ├── config.py                ← env var loader\n│   ├── sample_data.py           ← shared enterprise knowledge corpus loader\n│   └── evaluation.py           ← lightweight evaluation helpers\n│\n├── data/                        ← shared enterprise document corpus\n│   ├── policies/\n│   ├── incidents/\n│   ├── architecture/\n│   ├── support/\n│   ├── procurement/\n│   └── compliance/\n│\n├── 01_enterprise_knowledge_rag/\n├── 02_policy_metadata_filtering/\n├── 03_technical_document_search/\n├── 04_date_aware_compliance/\n├── 05_reranked_search/\n├── 06_ollama_local_reranking/\n├── 07_similarity_scores/\n├── 08_mmr_retrieval/\n├── 09_duplicate_detection/\n├── 10_semantic_recommendation/\n├── 11_incident_discovery/\n├── 12_architecture_decisions/\n├── 13_crewai_research_agent/\n├── 14_incident_investigation_crew/\n├── 15_procurement_crew/\n├── 16_compliance_crew/\n├── 17_ticket_routing/\n├── 18_operational_memory/\n├── 19_change_impact/\n└── 20_knowledge_maintenance/\n```\n\n---\n\n## Development waves\n\n| Wave | Use Cases | Capability |\n|------|-----------|------------|\n| 1 – Foundation | UC01, UC02, UC03 | Db2 connect → embed → vector retrieve |\n| 2 – Retrieval quality | UC04–UC08 | filters, scores, reranking, MMR |\n| 3 – Vector applications | UC09–UC12 | duplicates, recommendations, incident search |\n| 4 – Agents | UC13–UC16 | single agent, multi-agent crews |\n| 5 – Enterprise intelligence | UC17–UC20 | routing, memory, change impact, maintenance |\n\n---\n\n## LLM strategy\n\nAll use cases default to **Ollama + `granite3.1-dense:8b`** for:\n- local-first execution\n- no API key required\n- enterprise data privacy\n\nTo switch to a cloud LLM, set `LLM_PROVIDER=openai` and `OPENAI_API_KEY` in `.env`.\n\n---\n\n## Environment variables\n\nSee [`.env.example`](.env.example) for all required variables.\n\n---\n\n## Contributing / extending\n\nEach use case is intentionally self-contained.  \nAfter reviewing the scope README in each folder, run the example and check the SQL validation queries to confirm what was written to Db2.\n\n---\n\n## Security\n\n- Never commit `.env`\n- Use `.env.example` as the template\n- All credentials flow through environment variables only\n","readmeExcerpt":"IBM Db2 AI Use Cases 20 enterprise-grade AI examples on IBM Db2 using Haystack, LangChain, and CrewAI. Designed to be production-ready reference implementations and learning resources. --- What this repository demonstrates --- Requirements - Python 3.10+ - IBM Db2 (IBM FyRe or local Docker) - $1 with granite3.1-dense:8b pulled (used as the primary LLM) - IBM VPN (if connecting to FyRe) --- Quick start --- Repository ","codeSnippets":[],"executableExamples":[{"language":"text","snippet":"IBM Db2\n  |\n  +-- structured enterprise data\n  +-- documents / knowledge\n  +-- metadata\n  +-- native VECTOR storage\n  +-- vector similarity\n  |\n  +-------------------------------+\n                                  |\n                         AI framework layer\n                                  |\n             +--------------------+--------------------+\n             |                    |                    |\n          Haystack             LangChain            CrewAI\n             |                    |                    |\n        pipelines             VectorStore             tools\n        retrieval             search/MMR              agents\n        reranking             scores                  crews"},{"language":"bash","snippet":"# 1. Clone\ngit clone <repo-url>\ncd ibm-db2-ai-use-cases\n\n# 2. Install all dependencies (Python + IBM Db2 drivers + AI frameworks)\nbash install.sh\n\n# 3. Configure environment\ncp .env.example .env\n# Edit .env with your Db2 credentials\n\n# 4. Pull the Ollama Granite model\nollama pull granite3.1-dense:8b\n\n# 5. Run any use case\ncd 01_enterprise_knowledge_rag\npython main.py"},{"language":"text","snippet":"ibm-db2-ai-use-cases/\n│\n├── README.md                    ← this file\n├── install.sh                   ← one-command setup script\n├── requirements.txt             ← all Python dependencies\n├── .env.example                 ← environment variable template\n├── .gitignore\n│\n├── common/                      ← shared utilities (reused by all UCs)\n│   ├── db2.py                   ← Db2 connection helper\n│   ├── embeddings.py            ← embedding helper (Ollama + sentence-transformers)\n│   ├── config.py                ← env var loader\n│   ├── sample_data.py           ← shared enterprise knowledge corpus loader\n│   └── evaluation.py           ← lightweight evaluation helpers\n│\n├── data/                        ← shared enterprise document corpus\n│   ├── policies/\n│   ├── incidents/\n│   ├── architecture/\n│   ├── support/\n│   ├── procurement/\n│   └── compliance/\n│\n├── 01_enterprise_knowledge_rag/\n├── 02_policy_metadata_filtering/\n├── 03_technical_document_search/\n├── 04_date_aware_compliance/\n├── 05_reranked_search/\n├── 06_ollama_local_reranking/\n├── 07_similarity_scores/\n├── 08_mmr_retrieval/\n├── 09_duplicate_detection/\n├── 10_semantic_recommendation/\n├── 11_incident_discovery/\n├── 12_architecture_decisions/\n├── 13_crewai_research_agent/\n├── 14_incident_investigation_crew/\n├── 15_procurement_crew/\n├── 16_compliance_crew/\n├── 17_ticket_routing/\n├── 18_operational_memory/\n├── 19_change_impact/\n└── 20_knowledge_maintenance/"}],"parameters":null,"dependencies":[],"permissions":[],"extractedFiles":[],"languages":["python"],"docsSourceLabel":"GITHUB REPOS","editorialOverview":"Practical enterprise AI use cases with IBM Db2 using Haystack, LangChain, and CrewAI. IBM Db2 AI Use Cases 20 enterprise-grade AI examples on IBM Db2 using Haystack, LangChain, and CrewAI. Designed to be production-ready reference implementations and learning resources. --- What this repository demonstrates --- Requirements - Python 3.10+ - IBM Db2 (IBM FyRe or local Docker) - $1 with granite3.1-dense:8b pulled (used as the primary LLM) - IBM VPN (if connecting to FyRe) --- Quick start --- Repository","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":410,"uniquenessScore":60,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-10-09T11:50:37.999Z","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-09T11:50:37.999Z","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-10T07:59:40.573Z","emptyReason":null},"items":[{"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-10-09T19:11:12.944Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"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":"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"}]}}}