Projects using PostgreSQL in RanchiProjects using PostgreSQL in Ranchi
Projects
People
Cover image for Introducing live RAG ,VIXIT Cortex:
Introducing live RAG ,VIXIT Cortex: Enterprise AI That Turns Your Data Into Instant Answers Category: AI & Machine Learning / Web Development Tools Used: Node.js, PostgreSQL, Vector Embeddings, REST API, Natural Language Processing, Zero-Trust Security and many more stuff Project Description: The Problem: Data-heavy teams — hospitals, law firms, banks, insurers — spend weeks extracting insights from their data. SQL queries, data teams, manual reports. Slow, expensive, error-prone. The Solution: VIXIT Cortex is an enterprise AI agent that lets teams ask questions in plain English and get instant answers. No SQL. No data teams. No waiting. What I Built: Natural language query engine that understands domain-specific terminology Vector embedding system that processes 18 years of data in under 3 minutes Real-time analytics with sub-second query response (1.2s latency) Zero-trust security architecture (HIPAA, SOC 2 Type II, GDPR compliant) Tenant-isolated PostgreSQL databases with SHA256 token hashing Human-in-the-loop oversight for critical decisions Export capabilities (PDF, Excel, CSV) with source citations Key Features: Ask questions like "How many patients have eye power above 8?" and get instant answers Multi-step reasoning that breaks complex queries into logical steps Persistent memory that remembers context across conversations 99.99% uptime SLA with 24/7 priority support Integration with existing systems (Postgres, MySQL, Snowflake, BigQuery, Epic, Cerner)
2
3
78
Cover image for AI Document Intelligence & Invoice
AI Document Intelligence & Invoice Processing Platform Description Built an AI-powered document intelligence platform designed to automate invoice processing, document classification, data extraction, and approval workflows. The system uses AI, OCR, and workflow automation to process business documents automatically, eliminating manual data entry and reducing processing delays across finance and operations teams. By integrating with existing databases and business systems, the platform transforms unstructured documents into actionable business data. Key Features • AI-powered document analysis • Invoice data extraction • OCR-based document processing • Automated approval workflows • Purchase order matching • Vendor management integration • Document classification • Data validation system • Real-time processing dashboard • Automated reporting and audit trails Business Impact ✓ Reduced manual data entry ✓ Faster invoice processing ✓ Reduced processing errors ✓ Improved financial visibility ✓ Faster approval cycles ✓ Reduced operational costs ✓ Increased productivity across teams Technology Stack • Java • Spring Boot • PostgreSQL • OpenAI API • OCR Processing • REST APIs • Workflow Automation • Analytics Dashboard Results • Automated document processing workflows • Reduced invoice processing time by approximately 75% • Improved data accuracy • Reduced manual administrative effort • Accelerated approval and payment cycles This solution demonstrates how AI-powered document intelligence can automate finance and operational processes while improving accuracy, compliance, and efficiency.
0
23
Cover image for AI Customer Support Assistant Built an
AI Customer Support Assistant Built an AI-powered customer support platform designed to automate customer interactions, reduce support workload, and provide instant assistance using company documentation and knowledge base content. The system leverages OpenAI, enterprise knowledge bases, and backend automation to deliver accurate, context-aware responses while seamlessly escalating complex issues to human agents when needed. Key Features: • OpenAI-powered conversational assistant • Knowledge base search and retrieval • FAQ automation system • Context-aware customer responses • Human escalation workflow • Multi-channel support integration • Customer interaction analytics • Real-time response monitoring • REST API architecture • Enterprise-grade backend services Business Impact: ✓ Reduced repetitive support workload ✓ Faster customer response times ✓ 24/7 automated customer assistance ✓ Improved customer satisfaction ✓ Consistent support experiences ✓ Lower operational costs ✓ Increased support team efficiency Technology Stack: • Java • Spring Boot • PostgreSQL • OpenAI API • REST APIs • Docker • Maven • Knowledge Base Integration Results: • Automated approximately 80% of common support requests • Reduced average response time from hours to seconds • Reduced manual support workload by approximately 60% • Improved scalability without increasing support staff This solution demonstrates how AI-powered customer support systems can improve customer experience while significantly reducing operational overhead.
0
31
Cover image for VixitAI Studios Full-Stack Digital
VixitAI Studios Full-Stack Digital Agency & Product Studio Not a template shop. Not a freelancer with a Canva account. A full engineering studio that builds production-grade digital products from scratch. What we build: From simple blogs to Blinkit-tier enterprise platforms — websites, e-commerce systems, SaaS apps, mobile-first products, and AI-powered software. Every project is custom coded, zero templates. Core capabilities: Node.js + Express — custom REST/GraphQL APIs PostgreSQL + Redis — tenant-isolated databases PM2 + Nginx — zero-downtime deployments Cloudflare R2 — automated encrypted backups WhatsApp Automation — reminders, alerts, real-time triggers Auth Systems — signup/login, RBAC, JWT, SHA256 React/Next.js — modular SPA, lazy loading SEO Optimized — Schema.org (http://Schema.org), OG tags, Core Web Vitals Socket.io (http://Socket.io) real-time, Telegram bots, GST billing, multi-tenant architecture Pricing that makes sense: more sensible from other overcharging agencies The difference: Every project gets production-grade architecture. No lock-in. No hidden costs. Transparent pricing, real engineering.
0
128
Cover image for AI Business Operations Automation Suite Built
AI Business Operations Automation Suite Built a centralized AI-powered automation platform designed to streamline internal business operations and eliminate repetitive manual work. The system automates workflows across departments including operations, finance, customer support, reporting, and administration. By integrating AI, APIs, databases, and business tools, the platform significantly reduces operational overhead while improving efficiency and accuracy. Key Features: • Automated invoice processing • AI-powered document analysis • Internal workflow automation • Approval and task management system • Automated report generation • Email and notification automation • CRM and database integration • Real-time analytics dashboard • Role-based access control • Custom business process automation Business Impact: ✓ Reduced manual operational workload ✓ Faster processing of business tasks ✓ Improved team productivity ✓ Reduced human errors ✓ Centralized operational visibility ✓ Scalable automation infrastructure Technology Stack: • Java • Spring Boot • PostgreSQL • OpenAI API • REST APIs • Workflow Automation • Dashboard Analytics This solution demonstrates how AI and automation can transform traditional business operations into efficient, scalable, and data-driven workflows.
0
37
Cover image for Ekdant Dental Clinic Smart Clinic
Ekdant Dental Clinic Smart Clinic Website with Live Queue Integration A fully custom clinic website built and integrated with VIXIT Clinic ERP turning a static dental clinic presence into a fully automated patient experience. The Problem: Patients had to call the clinic to book appointments. Receptionists wasted time on the phone. Patients had no idea how long they'd be waiting. What I Built: A professional clinic website with a "Book Now" button powered by VIXIT automation — patients fill a form, pick their reason for visit, and the system handles everything from there. How it works end to end: Patient clicks Book Now → fills form with details and reason for visit Receptionist and doctor get instant notification Patient receives a Token Number automatically When they arrive, the clinic's Live Queue TV screen (powered by VIXIT) shows real-time token updates Patients sit calmly in the waiting room — they know exactly when their turn is coming Result: Zero phone calls for bookings. Zero confusion in the waiting room. Fully automated from website click to doctor's chair. Tech behind it: VIXIT Clinic ERP · Live Queue System · Real-time token display · Automated notifications · Custom website integration · Node.js · PostgreSQL and many more stacked for a powerful and premium experience Live: Ekdant Dental Clinic , integrated with clinic.vixitai.com (http://clinic.vixitai.com)
0
125
Cover image for CricAI , Real-Time Cricket Intelligence
CricAI , Real-Time Cricket Intelligence Platform Built for fans who never want to miss a moment. CricAI is a live cricket tracking platform with real-time scores, player following, and instant alerts so fans get notified the second something big happens, even with their phone screen off. Core Features: Follow your favourite players across all teams Real-time ball-by-ball score ticker Instant push + Telegram alerts — six hit, wicket taken, milestone reached Live match previews and AI-powered news Dark mode, mobile-first UI Subscription tiers most features completely free The problem it solves: Most fans are busy. They can't watch every match. But missing Virat's century or Jasprit's hat-trick moment hurts. CricAI makes sure your phone tells you exactly when your player does something worth knowing no noise, just the moments that matter. Tech behind it: Node.js · PostgreSQL · Cron Jobs · Web Scraping · Real-time data pipelines · Telegram Bot API · SEO-optimized frontend Live at: cricai.site (http://cricai.site)
0
114
Cover image for VIXIT Clinic ERP — Smart
VIXIT Clinic ERP — Smart Healthcare Management for Modern Hospitals and Clinics including Medical Billing shops A production-grade, multi-tenant clinic ERP I designed, built, and deployed solo — currently live with 50+ clinics and 2,400+ patients managed. What it does: Handles everything a clinic needs — patient registration, queue management, appointments, consultations, prescriptions, pharmacy POS, lab orders, billing with GST, and digital Rx delivery via WhatsApp and PDF. Tech Stack: Node.js · PostgreSQL · Redis · Express · PM2 (4-instance cluster) · Nginx · Hetzner VPS · JWT Auth · ioredis caching Security hardened: AES-256 encryption 5-attempt login lockout with 15-min cooldown Full audit logs on every auth event Fail2ban actively blocking 8,700+ malicious IPs 99.9% uptime SLA Why it's different: Most clinic software in India costs ₹5,000–₹15,000/month per clinic. VIXIT delivers the same — queue systems, digital prescriptions, pharmacy, billing at a fraction of the cost. Built lean, deployed fast, no bloat. Built by one person. No agency. No team of five. Just focused engineering with experienced years of 5 🔗 Live: clinic.vixitai.com (http://clinic.vixitai.com)
0
127