American Group Consulting

Home repair services across Southern California

Project Overview

We're actively working on creating a website that acts as a platform for the business owner to oversee his business and manage clients.

The site is complete with a backend and allows the owner to change the contents of the site via role-based permissions.

Key Features

Business Management Platform

Complete platform for business owners to oversee operations and manage client relationships.

Backend Integration

Full-stack implementation with database integration, API endpoints, and secure data handling.

Role-Based Permissions

Content management system that allows authorized users to modify site content based on their role and permissions.

Client Management

Tools and interfaces for managing client information, service requests, and business operations.

Technical Stack

Frontend:

  • • Astro 4.x
  • • React 19
  • • TypeScript
  • • Tailwind CSS

Backend:

  • • Supabase (PostgreSQL)
  • • REST API
  • • Authentication & Authorization
  • • Email Notifications
  • • IBM Granite 4.0 (AI Assistant)

AI Assistant Features

We're integrating an intelligent AI assistant powered by IBM Granite 4.0 to help business owners manage their operations through natural language conversation.

Natural Language Database Management

The AI assistant transforms natural language commands into precise database operations, eliminating the need for technical database knowledge.

Service Management:

  • • Create, read, update, and delete business services through conversation
  • • Automatic name normalization and data validation
  • • Smart foreign key relationship handling

Example:

"add service Plumbing, HVAC, Electrical"

→ Creates three services with proper validation

Intent Detection & Classification

The system employs sophisticated intent detection that parses natural language to identify operations, extract entities, and maintain context across conversations.

  • • Automatic CRUD operation detection (Create, Read, Update, Delete)
  • • Entity extraction from unstructured text
  • • Context-aware multi-turn conversations
  • • Handles complex queries with multiple operations

Customer Inquiry Analysis

AI-powered analysis of customer inquiries to help business owners understand demand and prioritize responses.

  • • Automatic Classification: Extract service/issue from inquiry text
  • • Sentiment Analysis: Detect urgency and customer emotion
  • • Smart Summaries: Generate concise inquiry summaries
  • • Response Suggestions: Recommend appropriate responses
  • • Trend Analysis: Identify patterns in customer needs

Autonomous Data Manipulation with Safety

The AI can manipulate business data on the owner's behalf with built-in safety mechanisms.

  • • All data modifications require explicit confirmation
  • • Preview changes before execution with detailed summaries
  • • 30-second confirmation timeout for security
  • • Batch operations for multiple services or issues
  • • Rollback capabilities on operation failure

Real-Time Reasoning & Compute

Powered by IBM Granite 3.3-2B running locally for complete data privacy and fast responses.

  • • 100% Local Processing: No cloud dependencies for sensitive data
  • • Sub-second Response Times: Most operations complete in under 2 seconds
  • • Context-Aware: Multi-step problem solving for complex queries
  • • Optimized Performance: 4-bit quantization for efficient memory usage

Business Owner Benefits

No Technical Knowledge Required

Manage entire service catalog through natural conversation - no SQL or database commands needed.

Time Efficiency

Create multiple services in seconds, batch operations reduce repetitive tasks.

Data Accuracy

Automatic validation prevents errors, preview-before-execute prevents mistakes.

Decision Support

Data-driven recommendations, service popularity rankings, and trend analysis.