PawSQL/pawsql-vscode: PawSQL for VSCode enables developers to access core capabilities of the PawSQL directly within VSCode enviroment. PawSQL provides sophisticated SQL optimization features including smart index recommendations and query rewrites. · GitHub

Name		Name	Last commit message	Last commit date
.vscode		.vscode
resources		resources
src		src
.gitignore		.gitignore
.vscode-test.mjs		.vscode-test.mjs
.vscodeignore		.vscodeignore
CHANGELOG.md		CHANGELOG.md
DEVELOPMENT.md		DEVELOPMENT.md
LICENSE.txt		LICENSE.txt
PRIVACY.md		PRIVACY.md
README.md		README.md
README_zh-CN.md		README_zh-CN.md
eslint.config.mjs		eslint.config.mjs
image.png		image.png
package-lock.json		package-lock.json
package.json		package.json
package.nls.en.json		package.nls.en.json
package.nls.json		package.nls.json
tsconfig.json		tsconfig.json
webpack.config.js		webpack.config.js

Repository files navigation

Optimize your SQL Queries by Clicks within your VSCode!

Optimize a SQL Query

Optimize in Default Workspace:
- Click the "Optimize" button in the SQL statement prompt
Optimize in Specific Workspace:
- Click the "Optimize..." button in the SQL statement prompt
- Select a workspace from the dropdown menu

Features

Index Advise: Recommend optimal indexes based on input SQL syntax, database objects and statistics information
Query Rewrite: Recommend semantically equivalent, but more efficient SQLs
Performance Validation: Ensure better performance after SQL rewrite and index recommendation

Supported Databases

MySQL, PostgreSQL, MariaDB, Oracle, openGauss, KingbaseES, GaussDB, Dameng, RDS for MySQL and etc.

Resources

About

PawSQL for VSCode enables developers to access core capabilities of the PawSQL directly within VSCode enviroment. PawSQL provides sophisticated SQL optimization features including smart index recommendations and query rewrites.

www.pawsql.com

indexing mariadb mysql optimization oracle performance postgresql query sql tuning

0 stars

0 watching

0 forks

Report repository