kineviz/proxy-mssql repository overview

docker run -d -it \
--name proxy-mssql  \
--restart always  \
-p 8088:8088 \
-v "$HOME"/proxy-mssql/:/data:rw \
kineviz/proxy-mssql:latest

GET http://localhost:8088/?sql=<QUERY>[&params=<JSON>][&jdbc=<CONNECTION>][&alwaysEncrypted=true]

fetch(`http://localhost:8088/?sql=${encodeURIComponent("SELECT GETDATE()")}`)
  .then(r => r.json())
  .then(data => console.log(data));

let sql = "SELECT * FROM users WHERE name = ? AND age > ?";
let params = JSON.stringify(["John", 25]);
fetch(`http://localhost:8088/?sql=${encodeURIComponent(sql)}&params=${encodeURIComponent(params)}`)
  .then(r => r.json())
  .then(data => console.log(data));

// Include the MSSQLQuery function from USAGE.md first, then:
MSSQLQuery("SELECT TOP 5 * FROM products WHERE price > ?", [100])
  .then(result => console.log(result));

// Basic connection
"jdbc:sqlserver://localhost:1433;databaseName=mydb;user=sa;password=mypass"

// With encryption
"jdbc:sqlserver://server:1433;databaseName=mydb;user=sa;password=mypass;encrypt=true"

// Always Encrypted
"jdbc:sqlserver://server:1433;databaseName=mydb;user=sa;password=mypass;columnEncryptionSetting=Enabled"

{
  "status": 1,
  "message": "Detailed error message"
}