PostgreSQLOLTP / Relational
psql -h postgres.internal -p 5432 -U enterprise_admin -d core_db
Driver: libpqPort: 5432
Microsoft SQL ServerOLTP / Relational
sqlcmd -S mssql.internal,1433 -U sa -P 'SecurePass123!' -d MasterLedger
Driver: OLE DB / ODBCPort: 1433
MySQLOLTP / Relational
mysql -h mysql.internal -P 3306 -u root -p'SecurePass123!' enterprise_prod
Driver: MySQL C APIPort: 3306
Oracle DatabaseOLTP / Relational
sqlplus sys/SecurePass123!@oraclerac.internal:1521/PRODDB as sysdba
Driver: Oracle NetPort: 1521
IBM DB2OLTP / Relational
db2 connect to PRODDB user db2admin using SecurePass123!
Driver: DB2 CLIPort: 50000
MariaDBOLTP / Relational
mariadb -h mariadb.internal -P 3306 -u admin -p'SecurePass123!'
Driver: MariaDB C APIPort: 3306
SQLiteOLTP / Relational
sqlite3 /var/lib/sqlite/enterprise_local.db
Driver: Embedded CPort: Local File
CockroachDBOLTP / Relational
cockroach sql --certs-dir=certs --host=roach-node-01:26257 --database=core
Driver: PostgreSQL WirePort: 26257
TiDBOLTP / Relational
mysql -h tidb-proxy.internal -P 4000 -u root -p'SecurePass123!'
Driver: MySQL WirePort: 4000
Amazon AuroraOLTP / Relational
psql -h aurora-cluster.cluster-xyz.us-east-1.rds.amazonaws.com -p 5432 -U postgres
Driver: PostgreSQL/MySQLPort: 5432/3306
SnowflakeOLAP Warehouse
snowsql -a xy12345.us-east-1 -u enterprise_admin -r ACCOUNTADMIN -w ENTERPRISE_WH
Driver: Snowflake JDBC/ODBCPort: 443 (HTTPS)
Google BigQueryOLAP Warehouse
bq query --use_legacy_sql=false 'SELECT current_timestamp()'
Driver: GCP REST APIPort: 443 (HTTPS)
Amazon RedshiftOLAP Warehouse
psql -h convoluted-cluster.redshift.amazonaws.com -p 5439 -U admin -d analytics
Driver: PostgreSQL WirePort: 5439
ClickHouseOLAP Warehouse
clickhouse-client --host clickhouse.internal --port 9000 --user default --password 'SecurePass123!'
Driver: ClickHouse NativePort: 9000/8123
Databricks Delta LakeOLAP Warehouse
databricks clusters spark-action --cluster-id 0412-182354-xyz --action-type run-sql
Driver: Spark Thrift JDBCPort: 10001
Apache DruidOLAP Warehouse
curl -X POST "http://druid-broker.internal:8888/druid/v2/sql" -H 'Content-Type: application/json' -d '{"query":"SELECT COUNT(*) FROM telemetry"}'
Driver: Druid SQL RESTPort: 8888
DuckDBOLAP Warehouse
duckdb /var/lib/duckdb/analytics.duckdb
Driver: In-Process C++Port: Local File
Trino (Presto)OLAP Warehouse
trino --server trino-coordinator.internal:8080 --user admin --catalog hive
Driver: Trino REST APIPort: 8080
Apache HiveOLAP Warehouse
beeline -u "jdbc:hive2://hive-server2.internal:10000/default" -n hiveadmin -p SecurePass123!
Driver: Hive JDBCPort: 10000
Apache IcebergOLAP Warehouse
spark-sql --conf spark.sql.catalog.enterprise_catalog=org.apache.iceberg.spark.SparkCatalog
Driver: Spark SQL CatalogPort: Catalog API
MongoDBNoSQL / Document
mongosh "mongodb://admin:SecurePass123!@mongos-router.internal:27017/enterprise_prod?authSource=admin"
Driver: MongoDB WirePort: 27017
Apache CassandraNoSQL / Wide-Column
cqlsh cassandra-node-01.internal 9042 -u cassandra -p SecurePass123!
Driver: Cassandra Native ProtocolPort: 9042
Apache HBaseNoSQL / Wide-Column
hbase shell --config /etc/hbase/conf
Driver: HBase Thrift / JavaPort: 16000 (Master)
CouchDBNoSQL / Document
curl -X GET "http://admin:SecurePass123!@couchdb.internal:5984/_all_dbs"
Driver: HTTP REST APIPort: 5984
Amazon DynamoDBNoSQL / Key-Value
aws dynamodb list-tables --region us-east-1 --endpoint-url https://dynamodb.us-east-1.amazonaws.com
Driver: AWS SigV4 RESTPort: 443 (HTTPS)
RedisKey-Value / Cache
redis-cli -h redis-node.internal -p 6379 -a 'SecurePass123!' --tls --cacert ca.crt
Driver: Redis RESP ProtocolPort: 6379
MemcachedKey-Value / Cache
echo "stats" | nc memcached.internal 11211
Driver: Memcached ASCII/BinaryPort: 11211
Apache FlinkStream Processing
./bin/flink run -m flink-jobmanager.internal:8081 /opt/jars/pipeline.jar
Driver: Flink REST APIPort: 8081
Apache KafkaEvent Streaming
bin/kafka-console-producer.sh --topic enterprise.stream --bootstrap-server kafka-broker:9092
Driver: Kafka TCP WirePort: 9092
InfluxDBTime-Series
influx --host https://influx.internal:8086 --org convoluted --token $INFLUX_TOKEN
Driver: InfluxQL / Flux APIPort: 8086
Neo4jGraph Database
cypher-shell -u neo4j -p 'SecurePass123!' -a bolt://neo4j-core.internal:7687
Driver: Bolt ProtocolPort: 7687
MilvusVector Database
python3 -c "from pymilvus import connections; connections.connect('default', host='milvus.internal', port='19530')"
Driver: Milvus gRPCPort: 19530
QdrantVector Database
curl -X GET "http://qdrant.internal:6333/collections" -H "api-key: $QDRANT_API_KEY"
Driver: Qdrant REST/gRPCPort: 6333
PineconeVector Database
python3 -c "from pinecone import Pinecone; pc = Pinecone(api_key='pc-secret-key')"
Driver: Pinecone SDK RESTPort: 443 (HTTPS)
###
Amazon NeptuneGraph Database
gremlin.sh -e connect.groovy --host neptune-cluster.us-east-1.neptune.amazonaws.com --port 8182
Driver: Apache TinkerPop GremlinPort: 8182