Inspiration

Managing complex, multi-step workflows and unstructured documents is a challenge for teams and organizations. I wanted to build an open-source, agentic platform that leverages semantic search and vector databases to make document and case management smarter, faster, and more collaborative.

What it does

Semantic Case Manager (SCM) is a full-stack web application that enables:

  • Secure document upload, preview, and management
  • Case creation, assignment, and tracking
  • Semantic search across all documents using vector embeddings
  • Role-based dashboards for admins and users
  • Modern, responsive UI with Tailwind CSS
  • FastAPI backend with TiDB Serverless for scalable, cloud-native storage

How we built it

  • Frontend: React (Vite), TypeScript, Tailwind CSS, Argon Dashboard theme
  • Backend: FastAPI, TiDB Serverless, S3-compatible storage, Docker Compose
  • Semantic Search: Amazon Bedrock Titan-V2 for embedding, vector search in TiDB and Claude Sonnet 3 for text summarization
  • Authentication: JWT-based, with modern login flow and role-based UI
  • Deployment: Dockerized for local and cloud deployment

Challenges we ran into

  • Integrating vector search with TiDB Serverless
  • Handling file uploads and previews securely
  • Ensuring robust error handling and retry logic
  • Creating a seamless, modern UI for both admin and user roles
  • Managing authentication tokens and session state in a secure, user-friendly way

Accomplishments that we're proud of

  • End-to-end agentic workflow for document and case management
  • Deployment-ready, open-source codebase
  • Responsive and accessible UI
  • Robust backend with error handling and retry logic
  • Clean project structure and documentation

What we learned

  • How to integrate semantic search and vector databases into real-world workflows
  • Best practices for secure authentication and role-based access
  • UI/UX design for complex, multi-role applications
  • Cloud-native deployment with Docker and TiDB Serverless

What's next for Semantic Case Manager

  • Add more agentic workflow automation.
  • Integrate with more cloud storage and AI services
  • Expand user management and audit logging
  • Polish UI/UX and add more customization options
  • Prepare for public open-source release and community contributions

Built With

Share this project:

Updates