Automation
Save work as tasks, schedule it, drive the application from scripts, and connect AI agents and the AI Helper.
Everything you do in Oxys DB Studio is a command with an id. The same commands are behind the menus, the saved tasks, the command line and the local MCP server, so anything you set up by hand can be repeated without you.
| I want to… | Read |
|---|---|
| Keep an export, import, migration or masking job and run it again later | Save and run tasks |
| Run a shell script as a task and keep its output in a file | Run IntelliShell scripts as tasks |
| Run a task every night, every hour or on chosen days | Schedule tasks |
| Run commands from a terminal, a shell script or another program | Command line |
| Let an AI client on this computer read my databases | Local MCP server for AI agents |
| Ask questions about my data in plain language | AI Helper |
Safety first
Automation never removes a confirmation. Destructive work (drop, clear, overwrite, delete, sync) asks before it runs, whether you start it from a menu, a task, the command line or a script. A scheduled task that replaces, removes or drops data asks once, when you schedule it, and again only if a later change makes it destroy more. AI agents and the AI Helper only get read-only tools.
To run tasks on a shared server rather than on your own computer, see the remote task runner in Team.
- Save and run tasksKeep the configuration of an export, import, migration, comparison, masking, reschema or script job as a task, and run it again in one click.
- Run IntelliShell scripts as tasksSave MongoDB shell scripts as an IntelliShell Script task, run them in order on one or more connections, and write their output to files.
- Schedule tasksRun a saved task once, every day, every few minutes or hours, on chosen weekdays or month days, and review its run history.
- Command lineRun any Oxys DB Studio command from a terminal or a script with oxysdb-cli: list commands, run one, stream a batch, answer confirmations, serve MCP.
- Local MCP server for AI agentsLet an AI client on this computer browse, query and analyse your databases through read-only tools, without giving it connection strings or passwords.
- AI HelperAsk questions about your MongoDB data in plain language with your own AI provider key: set it up, what is sent, and how to stop it.