export_to_json
Execute SQL queries and save results as JSON files for data export and analysis from SQL Server databases.
Instructions
Export query results to a JSON file.
Args:
query: SQL SELECT query to execute
filename: Output filename (relative or absolute path)
Returns:
Dictionary with:
- status: 'success' or error
- path: Absolute path to created file
- row_count: Number of rows exported
- file_size: Size of created file in bytesInput Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| filename | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||