DB AI Agent

AI tools

• AI assistant

  • ChatGPT
  • Gemini

• LibreChat

  • ClickHouse MCP
    • ability access to database
  • Skill
    • Best practice and guideline

Case studies

• Silver layer data pipeline design
  • table schema and batch job
• Data pipeline performance issue
  • High CPU usage
  • Query performance insight
  • Primary key review
• Table schema upgrade and data migration plan
  • make plan
  • review
  • exam and validation
  • perform and evaluation
• Why server workload so high?
  • Dashboard
    • query log
    • metrics
  • investigation with LLM
• Aggregation algorithm
  • documentation to code
  • end to end test

What’s Next?

• Context enhancement
  • RAG
  • Wiki
  • memory lifecycle
• Sandbox for AI agent
  • test environment
  • reusable dataset