Text2Sql.Net

# Tool List ## Text2Sql.Net - Natural Language to SQL .NET Implementation ### Project Background Text2Sql.Net is a .NET-based natural language to SQL tool designed to help developers and data analysts quickly generate database query statements through simple natural language descriptions. The project combines large language models (LLM) and traditional SQL parsing techniques, supporting multiple mainstream databases. ### Core Features - Natural Language to SQL: Input everyday language descriptions and automatically generate corresponding SQL query statements - Multi-Database Support: Compatible with SQL Server, MySQL, PostgreSQL, and SQLite - Intelligent Context Understanding: Understand user query intentions based on chat history - Vector Search Integration: Support semantic similarity search - Syntax Verification: Automatically check the generated SQL syntax correctness - **MCP Protocol Support**: Seamlessly integrate with IDE tools (Cursor, Trae, etc.) - **Intelligent Q&A Example System**: Improve SQL generation accuracy through example learning ## Technical Architecture      Configuration file. The project supports running with sqlite or pgsql, and supports configuring SqlService, MySql, PgSql, Sqlite for Text2Sql ``` "Text2SqlOpenAI": { "Key": "your key", "EndPoint": "https://api.antsk.cn/", "ChatModel": "gpt-4o", "EmbeddingModel": "text-embedding-ada-002" }, "Text2SqlConnection": { "DbType": "Sqlite", //PostgreSQL "DBConnection": "Data Source=text2sql.db", "VectorConnection": "text2sqlmem.db", "VectorSize": 1536 //PostgreSQL needs to be set, sqlite can not be set } ``` ## Core Modules **Database Adapter Layer** **Vector Database Integration** - Implement