Bring Lims
to Pydantic AI

Each audit log entry contains the precise timestamp (ISO 8601), performing user name and ID, action type (sample created, result modified, CoA issued, workflow step completed, user permission changed, instrument calibration recorded), affected record ID and type, previous and new values for any modifications, IP address and user agent, and justification comment (if required for critical changes). Fundamental for regulatory inspections, data integrity investigations, deviation root cause analysis, FDA 21 CFR Part 11 compliance, and ISO/IEC 17025 quality system requirements. AI agents use this to reconstruct event sequences during quality investigations, identify unauthorized or suspicious changes, monitor user activity patterns, generate audit-ready documentation packages, and demonstrate data integrity to regulatory inspectors. List all audit trail entries for laboratory operations and data modifications

Each batch entry contains the batch ID, producing facility license number, batch size and unit of measure, cannabis product type, harvest or manufacture date, linked samples submitted for testing, batch testing status (pending, partial, complete, failed), final disposition (released, quarantined, rejected, destroyed, reworked), and seed-to-sale tracking identifiers (Metrc UID, state compliance tags). Essential for batch-level compliance monitoring, recall management, regulatory reporting, and inventory reconciliation. AI agents reference this when tracing contamination issues, verifying batch clearance for distribution, generating lot-based compliance reports, or investigating quality deviations. List all cannabis production batches tracked through laboratory testing

Each CoA record includes the certificate number, linked sample and batch, issuing laboratory name and accreditation number, comprehensive analytical results (potency profile with THC/CBD percentages, terpene fingerprint with individual concentrations, contaminant screening results for pesticides, heavy metals, mycotoxins, and microbials), regulatory compliance statement, authorized signatory name and signature, issuance date, expiration date, and QR code for consumer verification. Critical for product release decisions, regulatory audit documentation, consumer transparency programs, and integration with state traceability systems (Metrc) and retail platforms (WeedMaps). AI agents use this to verify CoA authenticity, confirm batch compliance status, generate client-facing documentation packages, and ensure automatic regulatory submissions. List all Certificates of Analysis (CoA) issued by the laboratory

Each client record contains company name, license number and type (cultivation facility, processing plant, dispensary, distributor, third-party tester), primary contact information, account status (active, suspended, pending), billing terms, sample volume history, preferred communication methods, and any special testing requirements or custom panels configured. Essential for laboratory client relationship management, sample intake workflows, account-based reporting, and regulatory compliance documentation. AI agents should reference this when identifying sample ownership, generating client-specific reports, verifying active testing contracts, communicating results, and analyzing client testing patterns. List all clients (cultivators, processors, retailers) using laboratory services

Each instrument record contains the instrument name (HPLC system, GC-MS, ICP-MS, qPCR thermocycler, spectrophotometer), manufacturer, model number, serial number, installation location, calibration status, last calibration date, next scheduled maintenance, qualification status (IQ/OQ/PQ completion), associated test methods, and current operational status (active, under maintenance, offline, decommissioned). Critical for instrument qualification management, preventive maintenance scheduling, analytical data integrity verification, and regulatory inspection readiness. AI agents should reference this to verify instrument readiness before assigning tests, schedule calibration activities, troubleshoot analytical failures, and generate equipment utilization reports. List all laboratory instruments with calibration and maintenance status

Each order record contains the order ID, requesting client company, order date, requested test panels, number of samples included, priority level (standard, rush, priority), order status (pending, in-progress, completed, invoiced), assigned laboratory team, estimated completion date, and billing information. Critical for order management, client communication, laboratory capacity planning, and revenue tracking. AI agents use this to monitor order progress, identify bottlenecks, prioritize workflow assignments, communicate status updates to clients, and generate order fulfillment reports. List all testing orders and service requests from clients

Each plate entry contains the plate ID, plate format (96-well, 384-well), assay type assigned, number of samples loaded, number of standards and controls, run date, associated instrument, and processing status (prepared, in-run, completed, failed). Critical for managing high-volume testing operations, optimizing throughput, tracking reagent usage, and ensuring data integrity for multi-sample analytical runs. AI agents use this to monitor plate preparation status, identify incomplete runs, optimize well assignments, and troubleshoot analytical failures at the plate level. List all laboratory plates used for batch sample processing

Each result contains the result ID, linked sample and batch, test panel performed, comprehensive analytical findings (THC/CBD potency percentages, full terpene profiles, pesticide residue levels, heavy metal concentrations, mycotoxin detection, microbial counts), pass/fail determination against regulatory limits, analyst who performed the test, reviewer approval status, and date of completion. Fundamental for quality assurance workflows, client notification processes, regulatory data submissions, and product release decisions. AI agents should query this to verify sample compliance before releasing Certificates of Analysis, advising clients on product disposition, or preparing regulatory reports. List all laboratory test results with complete analytical data

Each run entry contains the run ID, instrument name and type (HPLC, GC-MS, ICP-MS, spectrophotometer), method or assay performed, start and end timestamps, operating analyst or technician, number of samples processed, quality control results (standard recoveries, blank checks, duplicate precision), system suitability status, and overall run disposition (accepted, rejected, requires review). Essential for instrument utilization tracking, method performance monitoring, analyst productivity assessment, and regulatory audit preparation. AI agents should query this to verify run completion status, identify failed runs requiring reanalysis, schedule instrument maintenance, and generate throughput reports. List all analytical runs executed on laboratory instruments

Each sample contains the unique sample ID, submitting client or cultivator, sample type (flower, edible, concentrate, topical, cartridge), received date, testing priority level, sample condition upon receipt, chain of custody documentation, and current testing status (received, in-progress, completed, failed, on-hold). Critical for laboratory workflow management, sample intake tracking, turnaround time monitoring, and seed-to-sale traceability compliance. AI agents use this to manage sample queues, predict completion dates, prioritize rush orders, and notify clients about status changes. List all cannabis samples submitted for laboratory testing

Each test entry includes the test name (potency, terpenes, pesticides, heavy metals, mycotoxins, microbials, residual solvents, water activity, moisture content, homogeneity), test methodology (HPLC, GC-MS, ICP-MS, ELISA, qPCR, LC-MS/MS), accreditation status, standard turnaround time, pricing tier, and regulatory limits per jurisdiction. Essential for test panel configuration, method validation, ISO/IEC 17025 compliance, and state-specific cannabis testing requirements. AI agents reference this when configuring sample test orders, explaining testing scopes to clients, verifying analytical method accreditation, and ensuring compliance with regulatory testing mandates. List all analytical test panels and methods available in the laboratory

Each workflow entry contains the workflow name (sample intake and login, potency testing, contaminant screening, CoA review and approval, sample disposal, non-conformance investigation), step definitions with sequential order, assigned roles and responsibilities at each step, quality control checkpoints and decision gates, average completion time, current instances in progress, and bottleneck indicators. Essential for laboratory operations management, staff task assignment, process optimization, and ISO/IEC 17025 quality management system compliance. AI agents use this to guide technicians through standardized testing procedures, identify workflow bottlenecks causing delays, ensure quality checkpoints are not bypassed, and generate process efficiency reports. List all laboratory workflow templates and active processes