PawSQL API
Overviewβ
The PawSQL optimization engine is a query optimization engine for MySQL/PostgreSQL and their derivative database management systems developed by the PawSQL team for developers and database administrators. It integrates the best practices of query optimization in the database industry and provides powerful SQL audit and rewrite optimization functions. It also integrates the Paw Index Advisor index recommendation engine to provide cost-based index recommendations for slow queries. PawSQL optimization engine can be deployed independently via docker image and provides SQL optimization services through http/json interfaces.
API Listβ
ποΈ 1. Create a Workspace
Description: Create a workspace and return the workspace ID (workspaceId).
ποΈ 2 Create an Optimization
Description: Create an optimization task using an existing workspace ID (workspaceId) or DDL statements and SQL statements to be optimized, and return the optimization result status and corresponding optimization result ID (analysisId).
ποΈ 3 Query the Summary of an Optimization
Description: Query the summary of an optimization by optimization ID (analysisId).
ποΈ 4 Query the details of an Optimization
Description: Query the details of an optimization using optimization ID (analysisId).
ποΈ 5 Query the list of Workspace
Description: Get user's all workspace list information.
ποΈ 6 Query the list of optimizations in a workspace
Description: Get user's (specified workspace) optimization list
ποΈ 7 List Rules
Description: List available rule name, code, and default threshold information, which can be used as a reference when creating optimizations.