Author: fly Version: 0.0.2 Type: tool
This is a dify-db tool make it easy to query data from existing databases.
You can get different format of data, like json, csv, yaml, xlsx, html, md etc. Also support use a url to get those data.
- Supports Multiple Databases: dify-db is compatible with a wide range of databases, including MySQL, Doris, Oracle, PostgreSQL, and SQLite.
- Versatile Data Formats: The tool allows you to convert data into various formats, such as JSON, CSV, YAML, XLSX, HTML, and Markdown.
- Data Retrieval via URL: dify-db supports fetching data through URLs.
- db_type:
mysql/Doris/oracle/postgreSQL/SQLite - db_host:
127.0.0.1 - db_port:
3306 - db_username:
test - db_password:
123 - db_name:
test - db_properties:
alt_host=host1&alt_host=host2&ssl_cipher=/path/to/crt
sql: This tool is used to execute SQL queries against the database.query: This tool translates user input into a valid SQL query.endpoint: This feature allows you to retrieve data via URL requests.
curl -X POST 'http://localhost/e/ami75gr7a832qyw9/sql' \
-H 'Content-Type: application/json' \
-d '{"query":"select * from test", "format": "json"}'- 0.0.2 (Initial Release)