RowDex
Get startedDownload
Documentation

Connection URLs and the URL builder

Connect with a single URL such as postgresql://user:pass@host:5432/db. Build one with the interactive helper and see the exact format RowDex accepts.

2 min readUpdated

On this page

Instead of filling in each field, you can paste one URL. In the connection form, switch Connection method from Standard to URL. RowDex fills in the host, port, user, database and SSL settings for you.

URL mode is available for PostgreSQL, Amazon Redshift, MySQL, MariaDB and Redis. MongoDB has its own Connection string mode, and SQLite uses a file path.

Try the URL builder#

Fill in the fields to see the URL for each engine. It runs in your browser and nothing is sent anywhere.

Build a connection URL

postgresql://analyst:p%40ss%3Aword%2F1@db.example.com:5432/app?sslmode=require

Special characters in the user and password are percent-encoded for you. Nothing you type here leaves your browser. Use dummy values rather than a real password.

Formats#

PostgreSQL and Redshift
postgresql://user:password@localhost:5432/mydb?sslmode=require
MySQL and MariaDB
mysql://user:password@localhost:3306/mydb?ssl-mode=REQUIRED
Redis (rediss:// switches TLS on)
redis://:password@localhost:6379/0
rediss://:password@cache.example.com:6380/0
MongoDB (connection string mode)
mongodb+srv://user:password@cluster.xxxxx.mongodb.net/mydb

What RowDex accepts#

EngineSchemesSSL options in the URL
PostgreSQLpostgresql://, postgres://sslmode=disable|prefer|require|verify-ca|verify-full
Redshiftpostgresql://, postgres://, redshift://sslmode=..., as for PostgreSQL
MySQL, MariaDBmysql://, mariadb://ssl-mode=DISABLED|REQUIRED|VERIFY_CA|VERIFY_IDENTITY
Redisredis://, rediss://rediss:// enables TLS; tls=true also works
  • The scheme must match the database type you chose. A mysql:// URL on a PostgreSQL connection is rejected with a clear message.
  • If you leave out the port, RowDex uses the engine's default: 5432, 5439 for Redshift, 3306 or 6379.
  • For Redis, the path is the database number, so /2 selects database 2.
  • Once a URL connection is saved, the password is masked in the stored URL and kept in your OS keychain instead.

Special characters in passwords#

If a password contains characters such as @, :, /, ? or #, they must be percent-encoded in a URL, for example @ becomes %40. The builder above does this for you. If that sounds fiddly, switch back to Standard mode, where the password is typed as-is.

Was this page helpful?