MongoDB connections, with an explorer and a console

MongoDB is now a connection type of its own, stored beside the SQL databases OL DataIQ already manages and listed with them. The connection takes a mongodb:// or mongodb+srv:// connection string, with an optional username, password and auth database, TLS, and a default database that preselects itself when the console and explorer open. A connection's family is fixed when it is created — SQL and MongoDB rows live in separate tables behind separate endpoints — so the list has its own SQL and NoSQL filters.

The explorer walks a connection: databases, then collections, then two panels for whichever collection is selected — its indexes, and a schema sampled from the documents actually in it. A collection that declares no schema still shows the fields and types it holds, and how often each one appears, which is what makes an undocumented collection readable at all.

The console runs against it. Pick a database, a collection and an operation, supply the JSON that operation needs, and read the result as a table or as the documents themselves. Find, aggregate, count and distinct read; insert one, update many and delete many write, and a write is confirmed before it runs. A truncated result says which limit cut it — the one you asked for, or the ceiling the server applies — so a short answer is never mistaken for the whole of it. An aggregation that would write its output into a collection is refused.

The same fifteen operations are available to AI tooling as MCP tools, acting as the client that invoked them and using the stored connection, so no credential is passed in a prompt.

Secrets are handled the way SQL connection passwords already are: encrypted at rest and never returned to a client. A password written inside the connection string is covered too — the string is encrypted where it is stored, and the password inside it is masked before the connection leaves the server. Returning the mask unchanged keeps the stored password, so editing a host or an option does not disturb it.