Skip to main content

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​

  • Create a workspace
  • Create an optimization
  • Get the optimization summary
  • Get optimization details
  • Query the list of workspaces under a user
  • Query the optimization list for a workspace
  • Query rule metadata