ChemMasters Data Platform

AI Data Platform

A comprehensive AI data platform for a chemicals company — unifying product data, customer information, and technical documentation through MCP servers and REST APIs. Features AI trip report generation, semantic product search, and a document management pipeline for Safety Data Sheets (SDS) and Technical Data Sheets (TDS).

Impact & Results

Hours of manual data entry replaced by automated AI trip reports

Instant semantic search across thousands of chemical products

Automated document classification with high accuracy

Slack integration for real-time notifications and queries

Technical Architecture

GCP Document AI for PDF extraction Vertex AI Search for semantic product search FastMCP server architecture Legacy system integration (Sage MySQL) FTP document ingestion pipeline

Challenges & Solutions

Challenge 1

Legacy Sage MySQL database with inconsistent data formats

Solution 1

GCP Document AI pipeline for automated SDS/TDS extraction and classification

Challenge 2

Hundreds of SDS/TDS PDF documents with varying layouts

Solution 2

Vertex AI Search for semantic product search across entire catalog

Challenge 3

Sales team needed fast product search across thousands of chemicals

Solution 3

AI trip report generator using Gemini for natural language summaries

Challenge 4

Manual trip report creation consuming significant sales rep time

Solution 4

FastMCP server exposing product/customer data to AI agents

Technology Stack

FastAPI FastMCP SQLModel PostgreSQL MySQL (legacy Sage) Vertex AI Search GCP Document AI Vertex AI / Gemini React Widget Slack SDK