The latest articles on DEV Community by JAGADEESH K (@jagadeesh_k_28bc7b0070e17). https://dev.to/jagadeesh_k_28bc7b0070e17 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4006828%2F00f6bcd8-ce4b-4e6d-93d7-4053a3d49e38.png https://dev.to/jagadeesh_k_28bc7b0070e17 en JAGADEESH K Sun, 28 Jun 2026 17:51:03 +0000 https://dev.to/jagadeesh_k_28bc7b0070e17/building-procureai-an-ai-powered-procurement-platform-with-aurora-postgresql-1n14 https://dev.to/jagadeesh_k_28bc7b0070e17/building-procureai-an-ai-powered-procurement-platform-with-aurora-postgresql-1n14 <p>Procurement processes in many small and medium businesses still rely heavily on emails, spreadsheets, and manual vendor comparisons. This often results in delayed approvals, fragmented communication, and inefficient supplier selection.</p> <p>To address these challenges, we built <strong>ProcureAI</strong>, an AI-powered procurement platform that digitizes the complete procurement lifecycle.</p> <p>*<em>The Problem<br> *</em><br> Traditional procurement workflows involve multiple disconnected steps:</p> <ul> <li>Purchase requests submitted manually</li> <li>Approval processes through emails</li> <li>Vendor quotations managed in spreadsheets</li> <li>Difficult comparison of supplier responses</li> <li>Delayed purchase decisions</li> </ul> <p>These inefficiencies increase procurement cycle time and make vendor selection challenging.</p> <h2> Our Solution </h2> <p>ProcureAI provides a centralized procurement workflow:</p> <ul> <li>Purchase Request Management</li> <li>Approval Workflow</li> <li>Request for Quotation (RFQ)</li> <li>Vendor Quotation Collection</li> <li>AI-Powered Vendor Analysis</li> <li>Purchase Order Generation</li> </ul> <p>The platform helps organizations streamline procurement operations and make better purchasing decisions.</p> <h2> Why Aurora PostgreSQL? </h2> <p>Procurement data is highly relational.</p> <p>Purchase requests, RFQs, vendors, quotations, approvals, and purchase orders are all interconnected entities that require transactional consistency and reliable relationships.</p> <p>Aurora PostgreSQL was chosen because it provides:</p> <ul> <li>Relational data modeling</li> <li>ACID transactions</li> <li>Complex SQL queries</li> <li>Serverless scalability</li> <li>High availability</li> </ul> <p>This makes it well suited for procurement workflows that require data integrity and consistency.</p> <h2> Technology Stack </h2> <ul> <li>Next.js</li> <li>React</li> <li>Drizzle ORM</li> <li>Aurora PostgreSQL Serverless</li> <li>Gemini AI</li> </ul> <h2> AI-Powered Vendor Analysis </h2> <p>One of the key features of ProcureAI is AI-assisted vendor evaluation.</p> <p>The system analyzes vendor quotations, pricing, delivery schedules, and supplier information to help procurement teams identify the most suitable vendor.</p> <p>This reduces manual effort and supports better decision-making.</p> <h2> Conclusion </h2> <p>ProcureAI demonstrates how modern cloud databases and AI can improve procurement processes for small and medium businesses.</p> <p>Future improvements include advanced analytics, supplier performance tracking, and deeper AI-driven procurement insights.</p> <h1> H0Hackathon #AWS #AuroraPostgreSQL #NextJS #AI </h1> ai aws postgres productivity