Rust MongoDB Power CLI

A powerful MongoDB CLI written in Rust, featuring intelligent auto-completion, SQL query support, and enhanced security features for productive database operations.

Note: This project is an independent, community-driven tool. It is NOT affiliated with MongoDB, and it is not intended to be a drop-in replacement for the official mongosh.

🔍 Key Differences vs Official mongosh

✨ Features

• ⚡ High Performance — Native Rust, async I/O
• 💾 Lightweight — Small static binary
• 🎨 Syntax Highlighting — Readable command & JSON output
• 📊 Rich Output Formats — JSON (pretty/compact), shell-style, and table views
• 🗄️ SQL Query Support — Query MongoDB using familiar SQL SELECT syntax
• 🧠 Intelligent Auto-Completion — Context-aware suggestions for MongoDB shell and SQL commands

📦 Installation

cargo install mongosh

Note: The binary name may change in the future to avoid conflicts with the official MongoDB shell.

🚀 Quick Start

Connect to MongoDB

# Connect to local MongoDB
mongosh

# Connect to a specific host
mongosh mongodb://localhost:27017

# Connect with authentication (credentials are automatically sanitized in logs)
mongosh mongodb://username:password@localhost:27017/dbname

🧪 Example Commands

// Show Databases
show dbs

// Switch Database
use mydb

// Show Collections
show collections

// Insert a Document
db.users.insertOne({ name: "John Doe", age: 25 });

// Query Documents
db.users.find({ age: { $gte: 18 } });

// Update Documents
db.users.updateOne({ name: "John Doe" }, { $set: { age: 26 } });

// Aggregation Pipeline
db.orders.aggregate([
  { $match: { status: "completed" } },
  { $group: { _id: "$userId", total: { $sum: "$amount" } } },
]);

🔍 SQL Query Support

This shell now supports SQL SELECT queries that are automatically translated to MongoDB queries!

Basic SELECT Queries

-- Simple query with filtering and sorting
SELECT name, age FROM users WHERE age > 18 ORDER BY name ASC

-- Pagination with LIMIT and OFFSET
SELECT * FROM users LIMIT 10 OFFSET 5

Aggregate Functions

-- Column aliases support both identifiers and quoted strings
SELECT group_id AS 'group_id', COUNT(*) FROM templates GROUP BY group_id

-- Group by with multiple aggregates
SELECT
  category,
  COUNT(*) AS total,
  SUM(price) AS revenue
FROM products
GROUP BY category

Supported SQL Features

• ✅ SELECT with column list or *
• ✅ FROM clause
• ✅ WHERE with comparison operators (=, !=, >, <, >=, <=)
• ✅ Logical operators (AND, OR)
• ✅ GROUP BY with aggregation functions (COUNT, SUM, AVG, MIN, MAX)
• ✅ ORDER BY with ASC/DESC
• ✅ LIMIT and OFFSET
• ✅ Column aliases with AS (supports both identifiers and string literals)

SQL to MongoDB Translation Examples

Notes

• SQL queries are automatically detected when starting with SELECT
• Complex JOIN operations are not yet supported
• Subqueries are not yet supported

📄 License

Licensed under the MIT License.

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

📬 Feedback

If you have any questions, suggestions, or issues, please open an issue on GitHub.