Sign inSign up

daniellindemann/sql-test-connection

By daniellindemann

•Updated 7 months ago

A small console tool to verify Microsoft SQL connectivity

Image
Developer tools
0

548

daniellindemann/sql-test-connection repository overview

Github: https://github.com/daniellindemann/sql-test-connection⁠

⁠Features

  • Test SQL connectivity with a connection string.
  • Optional query execution with tab-separated output.
  • Optional loop mode with configurable wait time between checks.
  • Container-friendly usage for quick diagnostics.

⁠Usage

Usage: sql-test-connection --connectionString <value> [--query <value>] [--wait <seconds>]
       sql-test-connection -c <value> [-q <value>] [-w <seconds>]

Parameters:

  • --connectionString / -c (required): The SQL connection string.
  • --query / -q (optional): SQL to execute after connecting.
  • --wait / -w (optional): Loop the test; default wait is 10 seconds. Pass a number to override.

⁠Container Image

The tool is available as a container image: https://hub.docker.com/r/daniellindemann/sql-test-connection⁠

⁠Docker
docker run --rm daniellindemann/sql-test-connection \
  -c 'Server={some_server};Initial Catalog={some-db};User ID={some_user};Password={some_password};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;'

Run a query:

docker run --rm daniellindemann/sql-test-connection \
  -c 'Server={some_server};Initial Catalog={some-db};User ID={some_user};Password={some_password};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;' \
  -q 'SELECT 1'

Loop every 10 seconds:

docker run --rm daniellindemann/sql-test-connection \
  -c 'Server={some_server};Initial Catalog={some-db};User ID={some_user};Password={some_password};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;' \
  -w
⁠Kubernetes

With kubectl run:

kubectl run -it --rm --image=daniellindemann/sql-test-connection --restart=Never sql-test-connection -- \
  -c 'Server={some_server};Initial Catalog={some-db};User ID={some_user};Password={some_password};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;'

With YAML manifest:

apiVersion: v1
kind: Pod
metadata:
  name: sql-test-connection
spec:
  containers:
  - name: sqltest
    image: daniellindemann/sql-test-connection
    imagePullPolicy: Always
    args:
    - '--connectionString'
    - 'Server={some_server};Initial Catalog={some-db};User ID={some_user};Password={some_password};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;'
    - '--wait'

Check the logs with kubectl logs -f sql-test-connection. If an error occurred, check previous pod logs with kubectl logs -p sql-test-connection.

Tag summary

Content type

Image

Digest

sha256:9df5b7f51…

Size

92.3 MB

Last updated

7 months ago

docker pull daniellindemann/sql-test-connection