用户注册聊天机器人

┌─────────────────┐    HTTP/JSON-RPC    ┌─────────────────┐    CSV Operations    ┌─────────────────┐
│ Streamlit UI    │ ◄─────────────────► │   MCP Server    │ ◄─────────────────► │ user_registrations│
│ (Chat Interface)│                     │ (Python Server) │                     │     .csv         │
└─────────────────┘                     └─────────────────┘                     └─────────────────┘

# Install MCP SDK for the server
pip install mcp

# Install Streamlit for the chatbot interface
pip install streamlit requests

python registration_mcp_server.py

🚀 Starting Registration MCP Server...
📁 Data file: user_registrations.csv

🛠️  Available tools:
   • add_registration - Add new user registration
   • get_all_registrations - Retrieve all registrations
   • search_registrations - Search by name or email
   • get_registration_statistics - View registration stats
   • validate_registration_data - Validate data before saving

📚 Available resources:
   • file://user_registrations.csv - Direct CSV file access

✅ Server ready for connections!
   Connect your AI model to use these tools...

streamlit run streamlit_chatbot.py

User: register
Bot: Great! Let's start your registration. 📝
     What's your full name?

User: John Doe
Bot: Nice to meet you, John Doe! 👋
     Now, please provide your email address:

User: john@example.com
Bot: Perfect! 📧
     Now please enter your date of birth.
     Format: YYYY-MM-DD (e.g., 1990-05-15)

User: 1990-05-15
Bot: 📋 Please confirm your registration details:
     • Name: John Doe
     • Email: john@example.com
     • Date of Birth: 1990-05-15
     
     ✅ Everything looks good!
     • Type 'confirm' to complete registration

User: confirm
Bot: 🎉 Registration Completed Successfully!
     ✅ Successfully registered John Doe
     
     Registration Details:
     • Name: John Doe
     • Email: john@example.com
     • Date of Birth: 1990-05-15
     • Registered: 2025-01-15 14:30:25

Name,Email,Date_of_Birth,Registration_Date
John Doe,john@example.com,1990-05-15,2025-01-15 14:30:25
Jane Smith,jane@example.com,1985-03-20,2025-01-15 14:35:12
Mike Johnson,mike@example.com,1992-07-08,2025-01-15 14:40:33

📊 Registration Statistics:

📋 Total Registrations: 25
🌐 Unique Email Domains: 12
📅 First Registration: 2025-01-10 09:15:30
🆕 Latest Registration: 2025-01-15 16:45:22
💾 File Size: 1,234 bytes

👥 Age Demographics:
   Average Age: 32.4 years
   Youngest User: 18 years
   Oldest User: 67 years

📁 Data File: user_registrations.csv

🔍 Search Results for 'john' (3 matches):

1. John Doe
   📧 Email: john@example.com
   🎂 Date of Birth: 1990-05-15
   📅 Registered: 2025-01-15 14:30:25

2. Johnny Smith
   📧 Email: johnny.smith@gmail.com
   🎂 Date of Birth: 1988-11-22
   📅 Registered: 2025-01-14 11:20:15
``

### **Common Issues**

**1. "MCP Server: Disconnected"**
- **Cause**: MCP server not running
- **Solution**: Start the server with `python registration_mcp_server.py`

**2. "Invalid email format"**
- **Cause**: Incorrect email format
- **Solution**: Use format like `user@domain.com`

**3. "Invalid date format"**
- **Cause**: Wrong date format
- **Solution**: Use YYYY-MM-DD format (e.g., `1990-05-15`)

**4. "Email already registered"**
- **Cause**: Duplicate email address
- **Solution**: Use a different email address

**5. "Failed to call MCP tool"**
- **Cause**: Communication issue between client and server
- **Solution**: Restart both the MCP server and Streamlit app

### **File Permissions**
- Ensure the directory is writable (for CSV file creation)
- Check that `user_registrations.csv` isn't locked by another program

### **Port Conflicts**
- MCP server uses stdio communication (no port needed)
- Streamlit uses port 8501 (changeable with `--server.port` flag)

## 📁 **Project Structure**

## 🔄 **Extending the System**

### **Adding New Fields**
1. Update `REQUIRED_FIELDS` in the MCP server
2. Add validation in `RegistrationValidator` class
3. Extend the chatbot conversation flow
4. Update CSV operations

### **Database Integration**
Replace CSV operations with database calls:
```python
# Instead of CSV operations
def add_registration(self, name, email, dob):
    # Database insert logic here
    cursor.execute("INSERT INTO users VALUES (?, ?, ?)", (name, email, dob))

@app.list_tools()
async def list_tools():
    return [
        Tool(name="send_email", description="Send welcome email"),
        Tool(name="sync_to_crm", description="Sync to CRM system")
    ]