MySQL / MariaDB
Connect to the database
mysql -h IP -P 3306 -u [USERNAME] -p[PASSWORD]
Get Server Versions
SELECT @@version, @@version_compile_machine;
Show databases
SHOW DATABASES;
Use Database
USE [DBNAME];
List Tables
SHOW TABLES;
List data in the table
SELECT * FROM [TABLE];
SQLite
Open the database file
sqlite3 [DATABASE.db]
List Tables
.tables
List schemas for all tables
.schema
List the database schema for a table
.schema TABLE_NAME
List data in the table
SELECT * FROM [TABLE];
MongoDB
Get versions
db.version()
db.runCommand({ buildInfo: 1 })
List databases
show dbs
or
db.adminCommand({ listDatabases: 1 })
Select a database
use [DATABASE]
List collections
show collections
or
db.getCollectionNames()
db.getCollectionInfos()
List users in current DB (requires privileges)
db.getUsers()