Which databases can I work with from the terminal?
Independent drivers cover MySQL/MariaDB, PostgreSQL, Redis, SQLite and MongoDB; db provides one short mirror over whichever driver you select.
Drivers
Install only the engines you use. mysql also covers MariaDB; postgresql, redis, sqlite and mongodb remain separate modules.
One shared workflow
Common flags cover connection, database or namespace selection, structure, preview, search, export and backups. Text after : is always native to the selected engine.
db mirror
Run db mysql, db postgresql, db redis, db sqlite or db mongodb once. db then forwards later operations to that installed driver without translating its language.
Examples
install mysql postgresql redis sqlite mongodbdb sqlitedb -c \sandbox\db\shop.sqlitedb -tdb -n products 5db : SELECT COUNT(*) FROM productsRelated documentation
dbDatabase-driver selection and common database operationsmysqlMySQL and MariaDB connections, inspection, edits, exports and SQL backupspostgresqlPostgreSQL connections, inspection, edits, exports and native SQLredisRedis keys, values, native commands and logical backupssqliteSQLite files, schema, rows, native SQL and SQL backupsmongodbMongoDB collections, documents, native commands and logical backups