Connection String Builder

Read a connection string into its parts, or build one from fields, for SQL Server, PostgreSQL, Redis, RabbitMQ, MongoDB and Azure; then copy it for appsettings.json, an environment variable or a Kubernetes Secret.

  • SQL Server (Microsoft.Data.SqlClient’s names, the old ones read too), PostgreSQL (Npgsql’s key=value and the postgres:// address, each turned into the other), Redis (StackExchange.Redis and redis://, rediss:// for TLS), RabbitMQ (amqp:// and amqps://, the virtual host escaped), MongoDB (mongodb:// and mongodb+srv://, the replica set, authSource) and Azure (Service Bus’s Endpoint=sb://, Storage’s DefaultEndpointsProtocol, the emulators’ own).
  • Out as the string, appsettings.json, an environment variable (ConnectionStrings__Orders), a Kubernetes Secret or docker run -e; the password can be a ${PLACEHOLDER} instead, so what you copy can be kept in a repo.
  • It warns about what bites later: a certificate trusted without checking, a password with a ; or a quote that needs quoting, an address’s password with @ or : that must be percent-encoded, Encrypt off on Azure SQL.

More tools

Keep exploring.

All tools

Markdown Editor

Write Markdown and see it as you type, with GitHub alerts, tables, tasks, math, Mermaid and PlantUML.

Text Compare

Two texts or files side by side, every change lined up to the character.

Code Practice

Puzzles that compile, to keep a developer's mind sharp.