Database Commands Generator

ssh root@your-server-ip

# Find your docker-compose file
cat /opt/apps/myapp/docker-compose.yml | grep -A 20 "postgres"
# Or for .env files
cat /opt/apps/myapp/.env | grep -i password

# Now remember these values for the next command...

# Get into container shell first
docker exec -it mysql_container bash

# Or connect directly
mysql -h localhost -P 3306 -u root -p'YourPasswordHere' mydb

# List tables
SHOW TABLES;

# Query data
SELECT * FROM users LIMIT 20;

# Set password in env to avoid prompt
PGPASSWORD='YourPassword' psql -h localhost -p 5432 -U postgres -d mydb

# Or via docker
docker exec -it postgres psql -U postgres

# List tables
\dt

# Query data
SELECT * FROM users LIMIT 20;

# Connect with auth
mongosh "mongodb://admin:password@localhost:27017/mydb?authSource=admin"

# Or via docker
docker exec -it mongo mongosh -u admin -p password

# List collections
db.getCollectionNames()

# Query documents
db.users.find().limit(20).pretty()

# Direct connection
redis-cli -h localhost -p 6379 -a 'YourPassword'

# Or via docker
docker exec -it redis redis-cli

# List keys
KEYS "*"

# Get a value
GET mykey

# ClickHouse - uses HTTP API
curl "http://localhost:8123/?user=default&password=xxx" --data "SHOW TABLES"

# Elasticsearch - REST API
curl -u "elastic:password" "http://localhost:9200/_cat/indices?v"

# Microsoft SQL Server - sqlcmd
sqlcmd -S localhost,1433 -U sa -P 'YourPassword' -Q "SELECT name FROM sys.tables"

# Cassandra - cqlsh
cqlsh localhost 9042 -u cassandra -p cassandra -e "DESCRIBE KEYSPACES"

# InfluxDB - influx CLI
influx query 'from(bucket:"mybucket") |> range(start:-1h)' --host http://localhost:8086 --token xxx

# Kafka - kafka-topics
kafka-topics --bootstrap-server localhost:9092 --list

# Each one different. Each one to memorize.

# MySQL
mysqldump -h localhost -u root -p'xxx' mydb > backup.sql

# PostgreSQL
PGPASSWORD='xxx' pg_dump -h localhost -U postgres mydb > backup.sql

# MongoDB
mongodump --uri="mongodb://admin:xxx@localhost:27017/mydb?authSource=admin" --out=./backup

# Redis
redis-cli -a 'xxx' BGSAVE

# Different tool, different flags, every single time.