How to make SQL query on a local MySQL
👉 Install the Local SQL plugin 🧩
Drivers installed: Mysql, Postgres, Microsoft SQL server
//exec:node
const query = "select * from TABLE;";
const dialect = "mysql"; //'mysql' | 'postgres' | 'mssql'
const port = 3306; // mysql,mariadb=3306 postgres=5432 mssql=1433
const results = await getSQL(query, "localhost", port, dialect, "user", "password", "database");
printTable(results);
//printJSON(results);
//const results = await getSQLite(query, "/path/to/database.sqlite");