Databases & SQL

367 commands

psql -U alice -d mydb -h db.example.com psql -c 'SELECT version();'psql -f schema.sql psql -d mydb \dt \d users \l \c otherdb \du \x \timing \password \q \copy users TO 'users.csv' CSV HEADER psql -Atc 'SELECT count(*) FROM users;'createdb mydb dropdb mydb pg_dump mydb > mydb.sql pg_dump -Fc mydb > mydb.dump pg_dump --table=users mydb > users.sql pg_dump --schema-only mydb > schema.sql pg_dump -j 4 -Fd mydb -f mydb_dir pg_restore -d mydb mydb.dump pg_restore -j 4 -d mydb mydb.dump pg_restore --list mydb.dump pg_isready -h db.example.com psql -U alice -d mydb -c 'EXPLAIN ANALYZE SELECT * FROM users WHERE id=1;'psql -l \i schema.sql vacuumdb -d mydb reindexdb -d mydb pg_dumpall > all.sql pg_dumpall --roles-only > roles.sql PGPASSWORD=secret psql -U alice -h db.example.com mydb \dn \di \df \d+ users \conninfo \watch 5 \pset pager off \e pg_ctlcluster 16 main start \copy (SELECT id, email FROM users WHERE active) TO 'active_users.csv' CSV HEADER psql -o out.txt -c 'SELECT * FROM users;'mysql -u alice -p -h db.example.com mydb mysql -e 'SHOW DATABASES;'mysql -e 'CREATE DATABASE mydb CHARACTER SET utf8mb4;'mysql -e "GRANT ALL PRIVILEGES ON mydb.* TO 'alice'@'localhost';"mysql -e 'FLUSH PRIVILEGES;'mysql mydb < dump.sql mysqldump -u root -p mydb > mydb.sql mysqldump --all-databases > all.sql mysqldump --single-transaction mydb > mydb.sql mysqladmin ping mysqladmin status mysqladmin processlist mysql -e 'SHOW PROCESSLIST;'mysql -e "SELECT user, host FROM mysql.user;"mysql -B -N -e 'SELECT COUNT(*) FROM users;' mydb mysql -e 'SHOW TABLES;' mydb mysql -e 'DESCRIBE users;' mydb mysql -e 'SHOW CREATE TABLE users;' mydb mysql -e "SHOW GRANTS FOR 'alice'@'localhost';"mysqldump --no-data mydb > schema.sql mysqldump --routines --triggers mydb > mydb.sql mysqlcheck -u root -p mydb mysqladmin kill 1234 mysql -e 'SHOW VARIABLES LIKE "character_set_server";'mysql -e 'SHOW STATUS LIKE "Threads_connected";'mysql -e 'SHOW ENGINES;'mariadb -u root -p mydb mysql -t -e 'SELECT * FROM users LIMIT 5;' mydb mysqldump -w "created_at > '2024-01-01'" mydb users > old_users.sql mysql -e "REVOKE ALL PRIVILEGES ON mydb.* FROM 'alice'@'localhost';"mongosh 'mongodb://localhost:27017/mydb'mongosh --eval 'db.stats()'mongosh mydb --eval 'db.users.find().limit(5)'show dbs use mydb show collections db.users.find({age: {$gt: 30}})db.users.findOne({email: 'a@b.com'})db.users.insertOne({name: 'Alice'})db.users.updateOne({email: 'a@b.com'}, {$set: {name: 'Alice2'}})db.users.deleteOne({email: 'a@b.com'})db.users.deleteMany({})db.users.createIndex({email: 1}, {unique: true})db.users.countDocuments({})db.users.aggregate([{$group: {_id: '$city', n: {$sum: 1}}}])mongodump --db mydb --out ./backup mongodump --uri 'mongodb://localhost:27017' --db mydb mongorestore --db mydb ./backup/mydb mongosh admin --eval 'db.shutdownServer()'mongostat 5 mongotop 5 mongosh --file seed.js db.users.find({age: {$gt: 30}}).sort({age: -1}).limit(10)db.users.updateMany({city: 'NYC'}, {$set: {active: true}})db.users.drop()db.dropDatabase()db.users.getIndexes()db.users.insertMany([{name: 'Alice'}, {name: 'Bob'}])mongodump --archive=mydb.archive --gzip redis-cli -h cache01.example.com -p 6380 PING redis-cli SET user:1 'Alice'redis-cli GET user:1 redis-cli DEL user:1 redis-cli EXPIRE session:abc 3600 redis-cli TTL session:abc redis-cli INCR pageviews redis-cli HSET user:1 name Alice redis-cli HGETALL user:1 redis-cli KEYS 'user:*'redis-cli --scan --pattern 'user:*'redis-cli SCAN 0 MATCH 'user:*' COUNT 100 redis-cli INFO redis-cli CONFIG GET maxmemory redis-cli -n 3 SET k v redis-cli BGSAVE redis-cli FLUSHALL redis-cli --bigkeys REDISCLI_AUTH=secret redis-cli PING redis-cli EXISTS user:1 redis-cli LPUSH queue job1 redis-cli LRANGE queue 0 -1 redis-cli RPOP queue redis-cli SADD tags 'linux'redis-cli SMEMBERS tags redis-cli ZADD scores 95 alice redis-cli ZRANGE scores 0 -1 WITHSCORES redis-cli INCRBY pageviews 10 redis-cli MSET user:1 'Alice' user:2 'Bob'redis-cli DBSIZE redis-cli CLIENT LIST redis-cli --stat redis-cli -u redis://default:secret@cache01.example.com:6379/0 PING redis-cli CONFIG SET maxmemory 256mb redis-cli SLOWLOG GET 5 redis-cli SUBSCRIBE news sqlite3 app.db '.tables'sqlite3 app.db '.schema users'sqlite3 app.db 'SELECT * FROM users LIMIT 5;'sqlite3 app.db '.mode column' '.headers on' 'SELECT * FROM users;'sqlite3 app.db '.import users.csv users'sqlite3 app.db '.output dump.sql' '.dump'sqlite3 app.db '.backup backup.db'sqlite3 app.db 'CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);'sqlite3 app.db '.indexes'sqlite3 :memory: 'SELECT 1;'sqlite3 app.db 'PRAGMA table_info(users);'sqlite3 app.db -cmd '.mode csv' -cmd '.headers on' 'SELECT * FROM users;'sqlite3 -readonly app.db 'SELECT * FROM users;'sqlite3 app.db 'VACUUM;'sqlite3 app.db 'ANALYZE;'sqlite3 app.db '.timer on'sqlite3 app.db 'PRAGMA journal_mode=WAL;'sqlite3 app.db 'CREATE INDEX idx_users_email ON users(email);'sqlite3 app.db 'DROP TABLE users;'sqlite3 app.db 'EXPLAIN QUERY PLAN SELECT * FROM users WHERE email="a@b.com";'sqlite3 app.db '.mode json' 'SELECT * FROM users;'sqlite3 app.db '.nullvalue NULL'sqlite3 app.db '.databases'sqlite3 app.db "ATTACH DATABASE 'archive.db' AS archive;"sqlite3 app.db '.eqp on'duckdb mydb.duckdb 'SELECT * FROM users;'duckdb mydb.duckdb -c "SELECT count(*) FROM users;"duckdb -c "SELECT * FROM read_csv_auto('data.csv');"duckdb -c "ATTACH 'other.duckdb' AS o;"duckdb -readonly mydb.duckdb 'SELECT 1;'duckdb -list -csv mydb.duckdb 'SELECT 1;'duckdb -json mydb.duckdb -c "SELECT * FROM users;"duckdb mydb.duckdb -c "COPY users TO 'users.csv' (HEADER, DELIMITER ',');"duckdb -c "SELECT * FROM read_parquet('users.parquet');"duckdb mydb.duckdb -c "SHOW TABLES;"duckdb mydb.duckdb -c "DESCRIBE users;"duckdb -c "INSTALL httpfs; LOAD httpfs;"duckdb -f setup.sql redis-cli INFO memory redis-cli SAVE redis-cli MONITOR sudo apt install postgresql postgresql-contrib sudo apt install postgresql-16 postgresql-client-16 sudo apt install postgresql-client sudo pg_ctlcluster 16 main stop sudo pg_ctlcluster 16 main restart sudo pg_ctlcluster 16 main status sudo pg_ctlcluster 16 main reload sudo pg_ctlcluster 16 main promote sudo pg_createcluster 16 mycluster --start sudo pg_dropcluster 16 mycluster sudo pg_upgradecluster 15 main sudo systemctl enable --now postgresql sudo systemctl status postgresql sudo systemctl restart postgresql sudo systemctl reload postgresql sudo -u postgres psql -d postgres -c 'SELECT version();'sudo -u postgres createuser -P app sudo -u postgres createdb -O app appdb sudo -u postgres dropdb appdb sudo -u postgres dropuser app psql -U app -h 127.0.0.1 -d appdb PGPASSWORD=secret psql -U app -h localhost appdb psql 'postgresql://app:secret@localhost:5432/appdb'psql -d appdb -c '\dt'psql -d appdb -c '\d+ users'psql -d appdb -c '\l'psql -d appdb -c '\du'psql -d appdb -c '\conninfo'psql -d appdb -c '\dn'psql -d appdb -x -c 'SELECT * FROM users;'psql -d postgres -c "CREATE USER app WITH PASSWORD 'secret';"psql -d postgres -c "CREATE DATABASE appdb OWNER app;"psql -d postgres -c "GRANT ALL PRIVILEGES ON DATABASE appdb TO app;"psql -d appdb -c "GRANT USAGE ON SCHEMA public TO app;"psql -d appdb -c "GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO app;"psql -d appdb -c "ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO app;"psql -d postgres -c "ALTER USER app WITH SUPERUSER;"psql -d postgres -c "ALTER USER app PASSWORD 'newpass';"psql -d postgres -c "DROP DATABASE appdb WITH (FORCE);"psql -d postgres -c "DROP USER app;"psql -d postgres -c "REASSIGN OWNED BY app TO postgres;"psql -d postgres -c "DROP OWNED BY app;"psql -d postgres -c "SELECT pg_size_pretty(pg_database_size('appdb'));"psql -d postgres -c "SELECT datname, pg_size_pretty(pg_database_size(datname)) FROM pg_database ORDER BY pg_database_size(datname) DESC;"psql -d appdb -c "SELECT pg_size_pretty(pg_total_relation_size('users'));"psql -d appdb -c "SELECT pg_size_pretty(pg_indexes_size('users'));"psql -d appdb -c "SELECT * FROM pg_stat_activity WHERE state = 'active';"psql -d appdb -c "SELECT pid, query FROM pg_stat_activity WHERE state = 'active';"psql -d appdb -c "SELECT pg_terminate_backend(12345);"psql -d appdb -c "SELECT pg_cancel_backend(12345);"psql -d appdb -c "SELECT pid, pg_blocking_pids(pid) FROM pg_stat_activity;"psql -d appdb -c "SELECT * FROM pg_locks WHERE NOT granted;"psql -d appdb -c "VACUUM;"psql -d appdb -c "VACUUM (VERBOSE) users;"psql -d appdb -c "VACUUM FULL users;"psql -d appdb -c "ANALYZE;"psql -d appdb -c "ANALYZE users;"psql -d appdb -c "REINDEX TABLE users;"psql -d appdb -c "REINDEX DATABASE appdb;"psql -d appdb -c "SELECT relname, n_live_tup, n_dead_tup FROM pg_stat_user_tables ORDER BY n_dead_tup DESC;"psql -d appdb -c "SELECT indexname, pg_size_pretty(pg_relation_size(indexrelid)) FROM pg_indexes WHERE tablename = 'users';"psql -d appdb -c "SHOW work_mem;"psql -d appdb -c "SHOW max_connections;"psql -d appdb -c "SELECT name, setting FROM pg_settings WHERE name LIKE 'autovacuum%';"psql -d postgres -c "ALTER SYSTEM SET work_mem = '64MB';"psql -d postgres -c "ALTER SYSTEM SET max_connections = '200';"psql -d postgres -c "SELECT pg_reload_conf();"psql -d appdb -c "EXPLAIN SELECT * FROM users WHERE email = 'a@b.com';"psql -d appdb -c "EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM orders WHERE user_id = 7;"psql -d appdb -c "EXPLAIN ANALYZE SELECT * FROM users WHERE id = 1;"psql -d appdb -c "CREATE INDEX idx_users_email ON users (email);"psql -d appdb -c "CREATE UNIQUE INDEX idx_users_email_unique ON users (email);"psql -d appdb -c "DROP INDEX idx_users_email;"psql -d appdb -c "CREATE INDEX idx_orders_user ON orders (user_id) WHERE status = 'open';"psql -d appdb -c "CREATE TABLE IF NOT EXISTS users (id serial PRIMARY KEY, email text UNIQUE);"psql -d appdb -c "ALTER TABLE users ADD COLUMN age int;"psql -d appdb -c "ALTER TABLE users DROP COLUMN age;"psql -d appdb -c "ALTER TABLE users RENAME TO members;"psql -d appdb -c "ALTER TABLE users ALTER COLUMN email SET NOT NULL;"psql -d appdb -c "TRUNCATE TABLE users RESTART IDENTITY;"psql -d appdb -c "CHECKPOINT;"psql -d appdb -c "SELECT pg_is_in_recovery();"psql -d appdb -c "SELECT * FROM pg_stat_replication;"psql -d appdb -c "SELECT datname, age(datfrozenxid) FROM pg_database;"psql -d appdb -c "SELECT * FROM pg_stat_database WHERE datname = 'appdb';"psql -d appdb -c "SELECT * FROM pg_stat_user_tables WHERE relname = 'users';"psql -d appdb -c "CREATE EXTENSION IF NOT EXISTS pg_stat_statements;"psql -d appdb -c "SELECT query, total_exec_time FROM pg_stat_statements ORDER BY total_exec_time DESC LIMIT 10;"psql -d appdb -c "\copy users TO '/tmp/users.csv' DELIMITER ',' CSV HEADER"psql -d appdb -c "\copy users FROM '/tmp/users.csv' DELIMITER ',' CSV HEADER"vacuumdb -d appdb vacuumdb --analyze -d appdb vacuumdb --all -v vacuumdb -d appdb --full reindexdb -d appdb reindexdb --all pg_dump -U app -d appdb -Fc -f appdb.dump pg_restore -U app -d appdb -j 4 appdb.dump pg_restore -U app -d appdb --clean --if-exists appdb.dump pg_dumpall -U postgres > all.sql pg_dump -U app -d appdb -t users -Fc -f users.dump pg_basebackup -h 127.0.0.1 -U replicator -D /var/lib/postgresql/16/standby -X stream -P pg_isready -h 127.0.0.1 -p 5432 sudo apt install mysql-client sudo systemctl enable --now mysql sudo systemctl status mysql sudo mysql -u root mysql -u app -p appdb mysql -u app -p -e 'SHOW DATABASES;'mysql -u app -p appdb -e 'SHOW TABLES;'mysqladmin -u root -p status mysqladmin -u root -p ping mysqladmin -u root -p processlist mysqladmin -u root -p shutdown sudo mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'secret';"mysql -u root -p -e "CREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"mysql -u root -p -e "CREATE USER 'app'@'localhost' IDENTIFIED BY 'secret';"mysql -u root -p -e "GRANT ALL PRIVILEGES ON appdb.* TO 'app'@'localhost';"mysql -u root -p -e "GRANT SELECT, INSERT, UPDATE, DELETE ON appdb.* TO 'app'@'localhost';"mysql -u root -p -e "ALTER USER 'app'@'localhost' IDENTIFIED BY 'newpass';"mysql -u root -p -e "DROP USER 'app'@'localhost';"mysql -u root -p -e "DROP DATABASE appdb;"mysql -u root -p -e 'FLUSH PRIVILEGES;'mysqldump -u app -p appdb > appdb.sql mysql -u app -p appdb < appdb.sql mysqldump --single-transaction --routines --triggers --events appdb > appdb.sql mysqlcheck -u app -p --check appdb mysqlcheck -u app -p --optimize appdb mysqlcheck -u app -p --analyze appdb mysqlcheck -u app -p --repair appdb mysql -u root -p -e "SELECT table_schema, ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS size_mb FROM information_schema.tables GROUP BY table_schema;"mysql -u root -p -e "SELECT table_name, ROUND((data_length + index_length) / 1024 / 1024, 2) AS size_mb FROM information_schema.tables WHERE table_schema = 'appdb' ORDER BY size_mb DESC;"mysql -u root -p -e "SHOW VARIABLES LIKE 'max_connections';"mysql -u root -p -e "SHOW VARIABLES LIKE 'innodb_buffer_pool_size';"mysql -u root -p -e "SET GLOBAL max_connections = 200;"mysql -u root -p -e "SHOW ENGINE INNODB STATUS\G"mysql -u root -p -e "SELECT user, host, plugin FROM mysql.user;"mysql -u root -p -e "SHOW GRANTS FOR 'app'@'localhost';"mysql -u root -p -e "OPTIMIZE TABLE appdb.users;"mysql -u root -p -e "PURGE BINARY LOGS BEFORE NOW() - INTERVAL 7 DAY;"redis-cli INFO server redis-cli INFO persistence redis-cli INFO replication redis-cli INFO clients redis-cli INFO stats redis-cli FLUSHALL ASYNC redis-cli --scan --pattern 'session:*' --count 100 redis-cli SLOWLOG GET 10 redis-cli SLOWLOG RESET redis-cli CLIENT KILL ID 123 redis-cli -a secret --no-auth-warning PING redis-check-rdb /var/lib/redis/dump.rdb sudo systemctl enable --now redis-server sudo systemctl status redis-server redis-cli CONFIG GET save redis-cli CONFIG SET maxmemory-policy allkeys-lru redis-cli CONFIG REWRITE redis-cli SHUTDOWN NOSAVE redis-cli MEMORY USAGE user:1 redis-cli --rdb /tmp/backup.rdb redis-cli MIGRATE 10.0.0.5 6379 user:1 0 5000 redis-cli ACL LIST redis-cli ACL SETUSER app on '>secret' '~app:*' +get +set redis-cli ACL DELUSER app sudo systemctl enable --now mongod sudo systemctl status mongod mongosh --eval 'db.runCommand({ping: 1})'mongosh appdb --eval 'db.users.find().limit(5)'mongosh appdb --eval 'db.users.createIndex({email: 1}, {unique: true})'mongosh appdb --eval 'db.stats()'mongosh --eval 'db.adminCommand({serverStatus: 1})'mongodump --db appdb --out /backups/mongo mongodump --db appdb --gzip --archive=/backups/appdb.archive mongorestore --drop --db appdb /backups/mongo/appdb mongoexport --db appdb --collection users --out users.json mongoexport --db appdb --collection users --type=csv --fields=email,name --out users.csv mongoimport --db appdb --collection users --file users.json mongosh appdb --eval 'db.users.getIndexes()'mongosh appdb --eval 'db.users.dropIndex({email: 1})'mongosh appdb --eval 'db.runCommand({collStats: "users"})'mongosh admin --eval 'db.currentOp()'mongosh admin --eval 'db.killOp(12345)'mongosh appdb --eval 'db.users.explain("executionStats").find({email: "a@b.com"})'mongosh --username app --password secret --authenticationDatabase admin appdb mongosh admin --eval 'db.createUser({user: "app", pwd: "secret", roles: [{role: "readWrite", db: "appdb"}]})'mongosh admin --eval 'db.dropUser("app")'

Search all 7,657 commands instead.