Author: jaguarliuu Version: 1.0.1 Type: tool
A tool that converts natural language into secure and optimized SQL queries, supporting both MySQL and PostgreSQL databases.
We are truly grateful for the overwhelming interest in this experimental project. Your feedback is invaluable for improving this plugin. Join our WeChat group for discussions and collaboration opportunities!
Contact:
- Wechat： L1763077056
- Native support for MySQL and PostgreSQL syntax differences
- Automatic SQL syntax adaptation based on database type (e.g., LIMIT vs FETCH FIRST)
- Mandatory result set limits (default LIMIT 100)
- DML operation prohibition (SELECT statements only)
- Field whitelist validation (based on database metadata)
- Least privilege principle for query execution
MySQL PostgreSQL
Compatible with all non-deep-thinking models
- ChatGLM-6B
- DeepSeek V3
- Qwen-max ...
- Import the rookie_text2data plugin
- Configure basic parameters:
| Parameter | Type | Required | Description | Multilingual Support |
|---|---|---|---|---|
| db_type | select | Yes | Database type (MySQL/PostgreSQL) | CN/EN/PT |
| host | string | Yes | Database host/IP address | CN/EN/PT |
| port | number | Yes | Database port (1-65535) | CN/EN/PT |
| db_name | string | Yes | Target database name | CN/EN/PT |
| table_name | string | No | Comma-separated table names (empty for all tables) | CN (format hints) |
| username | string | Yes | Database username | CN/EN/PT |
| password | secret-input | Yes | Database password | CN/EN/PT |
| model | model-selector | Yes | LLM model configuration | CN/EN/PT |
| query | string | Yes | Natural language query statement | CN/EN/PT |
- Select Model，We recommend using the Qwen-max model. Other models can be tested but deep-thinking models are unsupported.
- Generate SQL queries using natural language
- Import the rookie_execute_sql plugin
- Configure basic parameters:
| Parameter | Type | Required | Description | Multilingual Support |
|---|---|---|---|---|
| db_type | select | Yes | Database type (MySQL/PostgreSQL) | CN/EN/PT |
| host | string | Yes | Database host/IP address | CN/EN/PT |
| port | number | Yes | Database port (1-65535) | CN/EN/PT |
| db_name | string | Yes | Target database name | CN/EN/PT |
| sql | string | Yes | SQL query to execute | CN/EN/PT |
- Click "Execute" to run the SQL statement
This project is licensed under the Apache License 2.0 - see the LICENSE file for details.
