Allows connecting to any SQL database/datasource over HTTP without the need of drivers.
Clone the repo.
Install Java, Gradle, and Docker
Step 1: Build with build script:
./build.sh Step 2: Run the container
docker run -p 8081:8081 -t gs-springboot-sql-proxy Using IntelliJ with Gradle just run the application.
Step 1: Connect
- using POSTMAN or CURL (or whatever http client you want)
POST to localhost:8081/connect
{ "username": "[database user]", "password": "[database password]", "type": "[database type (sqlserver, oracle, mysql, postgres, snowflake, etc)]", "host": "[database host]", "port": "[database port]", "database": "[defaut database]", "params": {"[custom]": "[value]", "[custom2]": "[value]", ...} } Sql Server Example
{ "username": "sa", "password": "abcd123", "type": "sqlserver", "host": "localhost", "port": "1433", "database": "", } Snowflake example:
curl -XPOST localhost:8081/connect -H 'Content-type: application/json' -d '{"username": "user","password": "password","type": "snowflake","host": "my.db.host","port": "1234","database": "MY_DB"}' Step 2: Query
http://localhost:8081/query?sql=[sql statement]
Example (sql server):
http://localhost:8081/query?sql=select * from spt_monitor
Example (Snowflake):
curl -XGET "http://localhost:8081/query?sql=SELECT%20*%20FROM%20mytable;" Deploy the container with Docker, Kubernetes, Portainer, etc
- Gradle
- Docker
- Spring Boot
We use SemVer for versioning. For the versions available, see the tags on this repository.
- Scott Lepper
This project is licensed under the MIT License - see the LICENSE.md file for details