narinzar agents sql mcp

WHAT IT CONNECTS

narinzar agents sql mcp 为 AI Agent 提供什么

• **Natural Language Queries**: Ask questions about your data in plain English
• **SQL Query Generation**: Automatically generates SQL queries based on user input
• **Query Execution**: Executes the generated queries against a connected SQLite database
• **Result Formatting**: Displays query results in a readable format
• **Error Handling**: Provides clear explanations when queries fail
• **Example Queries**: Includes sample queries to help users get started
• **Web Interface** (`app.py`): A Gradio web interface that allows users to interact with the AI
• **MCP Server** (`mcp_server.py`): A server that handles SQL query execution
• **MCP Client** (`mcp_client.py`): A client that facilitates communication between the web interface and the MCP server
• Python 3.8+
• An Anthropic API key (to access Claude)
• Clone this repository:
• Install dependencies:
• Create a `.env` file in the project root with your Anthropic API key:
• Start the application:
• Open your web browser and navigate to:
• Type in a natural language query and press Enter or click Submit.
• "List all tables in the database"
• "Show me all users"
• "Count how many products cost more than $300"
• "What's the total value of all products in stock?"
• "Insert a new product called 'Tablet' with price $499.99 and stock 5"
• "Update the price of Laptop to $1099.99"
• `id`: INTEGER (Primary Key)
• `name`: TEXT
• `email`: TEXT
• `created_at`: TIMESTAMP
• `id`: INTEGER (Primary Key)
• `name`: TEXT
• `price`: REAL
• `stock`: INTEGER
• Understand natural language queries
• Generate appropriate SQL queries
• Explain query results to users
• Lightweight
• Serverless
• Self-contained
• Zero-configuration
• Replace the database initialization in `app.py` with your own database file path
• Update the sample table documentation in the UI to match your schema
• Currently only supports SQLite databases
• Complex queries might require refinement
• Limited error recovery for malformed queries