vedadb-cli
v5.0.0
Published
VedaDB CLI v5 — Colorful SQL Shell with Auth, Auto-Suggest & AI Agent
Maintainers
Readme
VedaDB CLI
Interactive MySQL-style command line client for VedaDB
Install
npm install -g vedadb-cliUsage
Quick Start
# Connect to local server
vedadb-cli
# Connect with options
vedadb-cli -h localhost -P 6380
vedadb-cli -u admin -p secret
vedadb-cli -D mydatabase
# Show version
vedadb-cli --versionInteractive Commands
vedadb> SELECT * FROM users;
+----+------+------------------+----+
| id | name | email | age|
+----+------+------------------+----+
| 1 | John | [email protected] | 25 |
| 2 | Jane | [email protected] | 30 |
+----+------+------------------+----+
2 row(s) in set
vedadb> INSERT INTO users (name, email) VALUES ('Bob', '[email protected]');
Query OK, 1 row(s) affected
vedadb> SHOW TABLES;
+------------+
| table_name |
+------------+
| users |
| orders |
| products |
+------------+
3 row(s) in set
vedadb> exit
Bye!CLI Commands
| Command | Description |
|---------|-------------|
| help | Show help |
| status | Show connection status |
| clear | Clear screen |
| exit / quit / q | Exit CLI |
SQL Support
SELECT,INSERT,UPDATE,DELETECREATE TABLE,DROP TABLEBEGIN,COMMIT,ROLLBACKSHOW DATABASES,SHOW TABLES,DESC tableUSE database
Connection Options
| Option | Short | Description | Default |
|--------|-------|-------------|---------|
| --host | -h | Server hostname | localhost |
| --port | -P | Server port | 6380 |
| --user | -u | Username | (none) |
| --password | -p | Password | (none) |
| --database | -D | Default database | (none) |
Features
- Colorized output
- Table formatting
- Tab completion
- Multi-line queries
- Query timing
- Connection status
- MySQL-style prompt
License
MIT
