Databases

Connect to MySQL, ClickHouse, MongoDB, Redis and Kafka, browse schemas and keys, and run read-only queries, find commands and SCANs safely.

• Connect to MySQL

  Add a MySQL connection in DevOpsPad with host, port, credentials, optional default database, TLS and SSH, then test it before you save it.

• Run read-only MySQL queries

  How DevOpsPad runs MySQL queries inside server-side read-only transactions, which statements fail, and why you should still use a read-only MySQL account.

• View MySQL table structure and DDL

  Inspect a MySQL table's columns, indexes and CREATE TABLE statement in DevOpsPad, switch databases per tab and copy the DDL without running any query by hand.

• Connect to ClickHouse over HTTP

  Connect DevOpsPad to self-hosted ClickHouse or ClickHouse Cloud through the HTTP interface on port 8123, or 8443 with TLS, and test the connection.

• Run read-only ClickHouse queries

  Run SQL against ClickHouse in DevOpsPad with readonly=1, a 500-row cap and a 15-second execution limit, and inspect columns, skipping indexes and DDL.

• Connect to MongoDB

  Add a MongoDB connection in DevOpsPad with host, port, database and authentication database (authSource), plus optional TLS and SSH tunneling.

• Write MongoDB find queries

  The JSON find format DevOpsPad uses for MongoDB, with collection, filter, projection, sort, skip and limit fields, defaults, validation rules and limits.

• Use Extended JSON in MongoDB filters

  Filter MongoDB by ObjectId, date, Long and Decimal128 in DevOpsPad with Extended JSON, and read the canonical Extended JSON that results come back in.

• Page through MongoDB results in batches

  How Previous batch and Next batch page through MongoDB results in DevOpsPad, why _id is added to the sort, and when to switch to range filters.

• Connect to Redis

  Add a Redis connection in DevOpsPad with host, port, database index, optional ACL user, TLS and SSH tunnel, then test it with PING before saving.

• Browse Redis keys with SCAN

  How DevOpsPad lists Redis keys with cursor-based SCAN and MATCH patterns, why batches can be empty or repeat keys, and how Load more keys works.

• Run read-only Redis commands

  The Redis commands DevOpsPad allows in the query editor, how to quote keys with spaces using a JSON array, and the 8 MiB response limit.

• Connect to Redis with ACL users and TLS

  Use a Redis 6+ ACL user, TLS or an SSH tunnel with DevOpsPad, what happens to certificate verification, and a minimal read-only ACL rule.

• Inspect Kafka topics and partitions

  Connect DevOpsPad to Kafka with optional SASL/PLAIN and TLS, list topics and see each partition's leader, replica count and in-sync replica count.