x402

SQL Optimize (x402)

Analyze and optimize a SQL query for performance. Returns rewritten query, index recommendations, and explanation of improvements.

get/x402/v2/sql-optimize

Request

  • Base URL: https://api.strale.io
  • URL: https://api.strale.io/x402/v2/sql-optimize
  • Auth: none required

Query parameters

sqlstring required
dialectstring
table_schemastring

Response

Success

optimized_sqlstring
estimated_improvementstring

Example response

{
  "dialect": "postgres",
  "explanation": "The provided SQL query 'test' is not a valid SQL statement. Please provide a valid SELECT, INSERT, UPDATE, or DELETE query for optimization analysis.",
  "changes_made": [],
  "original_sql": "test",
  "optimized_sql": "Unable to optimize - invalid input provided",
  "estimated_improvement": "N/A",
  "index_recommendations": []
}

Changes

No recorded changes to this operation across all 1 revision of this API.