Overview
Connect Plumi to MongoDB databases, including:
- Self-hosted MongoDB
- MongoDB Atlas
- Amazon DocumentDB
Connection Details
| Field | Description | Example |
|---|
| Connection String | MongoDB URI | mongodb+srv://... |
| Database | Database name | myapp |
mongodb://username:password@host:port/database
MongoDB Atlas (SRV)
MongoDB Atlas Setup
- Go to your MongoDB Atlas cluster
- Click Connect
- Select Connect your application
- Copy the connection string
- Replace
<password> with your password
Network Access
Add Plumi’s IP to your Atlas IP Access List:
- Go to Network Access
- Click Add IP Address
- Add Plumi’s IP or allow access from anywhere (for testing only)
Querying MongoDB
Plumi translates SQL-like queries to MongoDB aggregation pipelines:
-- Find documents
SELECT * FROM users WHERE age > 21 LIMIT 10;
-- Aggregation
SELECT city, COUNT(*) as count
FROM users
GROUP BY city
ORDER BY count DESC;
Supported Operations
| SQL | MongoDB Equivalent |
|---|
SELECT | $project |
WHERE | $match |
GROUP BY | $group |
ORDER BY | $sort |
LIMIT | $limit |
JOIN | $lookup |
Best Practices
Create indexes: Ensure your MongoDB collections have indexes on frequently queried fields.
Use projections: Select only the fields you need to reduce data transfer.
Troubleshooting
”Authentication failed”
- Verify username and password in the connection string
- Ensure the user exists in the correct database
- Check the authentication database (usually
admin)
“Connection timed out”
- Verify network connectivity to MongoDB
- Check Atlas IP access list includes Plumi’s IP
- Ensure the MongoDB instance is running
