Smart Query - Intelligent Data Query

Trigger Scenarios

• When users ask "Check xxx data", "Help me view the xxx table"
• When users need to query online databases
• When users ask "What tables are there", "What is the table structure"

Quick Start

1. Test Connection

python .opencode/skills/smart-query/scripts/db_connector.py

2. Execute SQL Query

python .opencode/skills/smart-query/scripts/query.py "SELECT * FROM table_name LIMIT 10"
python .opencode/skills/smart-query/scripts/query.py "SHOW TABLES"
python .opencode/skills/smart-query/scripts/query.py "DESC table_name"

• -n 50

  : Limit the number of returned rows

• -f json

  : Output in JSON format

• --raw

  : Output raw results (including metadata)

3. Generate Table Structure Documentation

python .opencode/skills/smart-query/scripts/schema_loader.py

references/schema.md

Natural Language Query Process

1. Understand User Intent: Analyze what data the user wants to query
2. Check Table Structure: Read

   references/schema.md

   to understand the table structure
3. Generate SQL: Write correct SQL based on the table structure
4. Execute Query: Execute using

   query.py

5. Interpret Results: Explain query results in plain language

Configuration Instructions

config/settings.json

{
  "ssh": {
    "host": "SSH bastion host address",
    "port": 22,
    "username": "Username",
    "password": "Password",
    "key_file": null
  },
  "database": {
    "type": "mysql",
    "host": "Database intranet address",
    "port": 3306,
    "database": "Database name",
    "username": "Database user",
    "password": "Database password"
  }
}

Share with Colleagues

1. Copy the entire

   smart-query/

   directory
2. Colleagues copy

   config/settings.json.example

   to

   settings.json

3. Fill in their own SSH and database connection information
4. Install dependencies:

   pip install paramiko sshtunnel pymysql

Security Tips

• config/settings.json

  contains sensitive information, do not commit it to Git
• It is recommended to add

  config/settings.json

  to

  .gitignore

• Only execute SELECT queries, avoid UPDATE/DELETE operations

Dependency Installation

pip install paramiko sshtunnel pymysql

Script List

scripts/db_connector.py

scripts/query.py

scripts/schema_loader.py

Reference Documents

references/schema.md