List configured MongoDB connection profiles (passwords are never shown; broken ones show their error).

Connect and return server version, edition, topology (standalone / replica set / sharded), the authenticated user and whether transactions are supported.

Register (or replace) a connection profile at runtime and test it.

host: "srv01", "srv01:27017" or "h1:27017,h2:27017"; or uri: "mongodb://..." / "mongodb+srv://...". auth: none | scram (user+password) | ldap | windows (Kerberos with the Windows logon) | x509 | uri. Passwords are never passed here: use password_env (name of an environment variable set in mcp.json).

Close and forget a connection profile.

List databases with size on disk (only the ones the login may see).

Collections and views of a database with type and estimated document count. name_filter: regex on the name, e.g. "^order".

Document count, data / storage / index sizes (MB), average document size, index sizes, capped flag.

Indexes of a collection with keys and options (unique, sparse, TTL, partial filter).

Infer the document structure from a random sample: every field path with its BSON types and how often it appears (present_pct). Nested objects use dots, array elements use "[]".

Query documents. filter / projection / sort are JSON (Extended JSON for ObjectId, dates...). sort: {"createdAt": -1} or [["a", 1], ["b", -1]]. limit defaults to the profile's max_docs (100). collation: {"locale": "tr", "strength": 2} for Turkish case-insensitive matching: "istanbul" finds "İstanbul" (İ=i, I=ı; regex $options "i" does not fold İ/ı).

Run an aggregation pipeline (JSON array of stages). $out / $merge are allowed unless the profile is read-only. limit caps the returned documents (default the profile's max_docs). collation: {"locale": "tr", "strength": 2} for Turkish case-insensitive matching (İ=i, I=ı).

Count documents matching a filter. estimated=true uses collection metadata (fast, ignores the filter). collation: {"locale": "tr", "strength": 2} for Turkish case-insensitive matching (İ=i, I=ı).

Distinct values of a field (optionally within a filter). Returns at most 5000 values. collation: {"locale": "tr", "strength": 2} for Turkish case-insensitive matching (İ=i, I=ı).

Insert one document (JSON object) or many (JSON array). Returns the inserted _ids. ordered=false keeps inserting after a failing document.

Update with operators ({"$set": {...}, "$inc": {...}}) or an aggregation pipeline (JSON array). many=false updates the first match. An empty filter requires confirm_all=true.

Replace the first document matching the filter with a whole new document (no update operators).

Delete the first matching document (many=false) or all matching documents (many=true). An empty filter requires confirm_all=true.

Execute several writes atomically (all or nothing). Requires a replica set or sharded cluster.

operations: [{"op": "insert", "collection": "orders", "document": {...}}, {"op": "update", "collection": "stock", "filter": {...}, "update": {"$inc": {"qty": -1}}}, {"op": "insert_many" | "update_many" | "replace" | "delete" | "delete_many", ...}] If any operation fails, nothing is written and the error names the failing step.

Create an index. keys: {"customerId": 1, "createdAt": -1} or {"title": "text"} / {"loc": "2dsphere"}. expire_after_seconds makes a TTL index; partial_filter is a filter expression.

Drop an index by name (see list_indexes). The _id index cannot be dropped.

Create a collection or view. options are passed to the 'create' command, e.g. {"validator": {"$jsonSchema": {...}}}, {"capped": true, "size": 1048576}, {"timeseries": {"timeField": "ts"}}, {"viewOn": "orders", "pipeline": [...]}.

Drop a collection with all its documents and indexes. confirm_name must repeat the collection name.

Rename a collection within the same database.

Drop a whole database. confirm_name must repeat the database name. admin/config/local are refused.

Run any database command (like db.runCommand), e.g. {"serverStatus": 1}, {"usersInfo": 1}, {"createUser": "app", "pwd": "...", "roles": [...]}, {"collMod": "orders", "validator": {...}}, {"explain": {"find": "orders", "filter": {...}}, "verbosity": "executionStats"}. database defaults to the profile's database (use "admin" for server-level commands).

Server health summary: version, uptime, connections, operation counters, memory, replication role.

Running operations (opid, op, namespace, seconds running, client, command summary).

Kill a running operation by opid (from current_ops).