| --- |
| title: Chatbot SQL Agent with Gemini |
| emoji: 🔍 |
| colorFrom: blue |
| colorTo: purple |
| sdk: gradio |
| sdk_version: "5.41.1" |
| app_file: app.py |
| pinned: false |
| --- |
| |
| # Chatbot SQL Agent with Gemini |
|
|
| A powerful chatbot that can answer questions by querying your SQL database using Google's Gemini model. |
|
|
| ## Features |
|
|
| - Natural language to SQL query conversion |
| - Interactive chat interface |
| - Direct database connectivity |
| - Powered by Google's Gemini AI |
| - RESTful API endpoints for integration |
|
|
| ## Setup |
|
|
| 1. Set up your environment variables in `.env` file: |
| ```env |
| DB_USER=tu_usuario |
| DB_PASSWORD=tu_contraseña |
| DB_HOST=tu_servidor |
| DB_NAME=tu_base_de_datos |
| GOOGLE_API_KEY=tu_api_key_de_google |
| ``` |
|
|
| 2. Install dependencies: |
| ```bash |
| pip install -r requirements.txt |
| ``` |
|
|
| 3. Run the web interface: |
| ```bash |
| python app.py |
| ``` |
|
|
| 4. Run the API server: |
| ```bash |
| python api.py |
| ``` |
|
|
| ## API Usage |
|
|
| La API proporciona dos endpoints principales: |
|
|
| ### 1. Enviar Mensaje de Usuario |
|
|
| **Endpoint:** `/user_message` |
|
|
| **Método:** POST |
|
|
| **Headers:** |
| ``` |
| Content-Type: application/json |
| ``` |
|
|
| **Body:** |
| ```json |
| { |
| "message": "tu pregunta aquí" |
| } |
| ``` |
|
|
| **Respuesta exitosa:** |
| ```json |
| { |
| "message_id": "uuid-generado", |
| "status": "success" |
| } |
| ``` |
|
|
| ### 2. Obtener Respuesta |
|
|
| **Endpoint:** `/ask` |
|
|
| **Método:** POST |
|
|
| **Headers:** |
| ``` |
| Content-Type: application/json |
| ``` |
|
|
| **Body:** |
| ```json |
| { |
| "message_id": "uuid-del-mensaje" |
| } |
| ``` |
|
|
| **Respuesta exitosa:** |
| ```json |
| { |
| "response": "respuesta del chatbot", |
| "status": "success" |
| } |
| ``` |
|
|
| ## Ejemplo de uso de la API |
|
|
| 1. Primero, envía tu pregunta: |
| ```bash |
| curl -X POST http://localhost:5000/user_message \ |
| -H "Content-Type: application/json" \ |
| -d '{"message": "¿Cuántos usuarios hay en la base de datos?"}' |
| ``` |
|
|
| 2. Luego, usa el message_id recibido para obtener la respuesta: |
| ```bash |
| curl -X POST http://localhost:5000/ask \ |
| -H "Content-Type: application/json" \ |
| -d '{"message_id": "uuid-recibido"}' |
| ``` |
| |
| Check out the [configuration reference](https://huggingface.co/docs/hub/spaces-config-reference) for more options. |
| |
