Nothing found. Try another word.
Security and access control
Accounts, rights, encryption and protection of the server.
Protection of the server
What protects the server, its accounts and its connections.
PBKDF2 passwordsLogin throttlingAES-GCM protocolCertificate settingsOutgoing TLS verificationRemote host verificationWeb firewallIP blockingPassword recovery
Details
- PBKDF2 passwords
- salted hashing of the passwords
- Login throttling
- lockout per login and per IP, with a doubling delay
- AES-GCM protocol
- key per session, nonce, replays and reordering rejected
- Certificate settings
- CA and server certificates, alternative host names
- Outgoing TLS verification
- certificate and host name checks, trusted certificates folder
- Remote host verification
- FTPS trust and SSH host key checks
- Web firewall
- requests logged per IP and per page
- IP blocking
- blocked list, and a script to block from your own rules
- Password recovery
- forgot and reset screens in the web applications
Restricted sessions
A user can be limited to running the scripts granted to them.
Restricted sessionsFile sandboxRestricted editor
Details
- Restricted sessions
- only execute, include, call and stack, with simple parameters
- File sandbox
- files limited to tmp/<user>/ for a restricted user
- Restricted editor
- connection and administration tabs hidden
Create and manage the accounts.
All 9 functions
Give access to the scripts through groups.
All 15 functions
Log in with a directory, and search it, read only.
All 7 functions
Sign and verify JSON Web Tokens.
All 3 functions
Encrypt and sign files and messages for a partner or a bank.
All 7 functions
Sign and verify PDF and XML documents.
All 6 functions
Protect personal data before using it.
All 3 functions
Automation and flows
Scheduled and asynchronous work, followed and replayable.
Automation engine
Run work in the background, in parallel and at the right time.
Parallel executionBoot hooksMail queueMaintenance switches
Details
- Parallel execution
- concurrent MQL on a thread pool
- Boot hooks
- scripts on start and on shutdown
- Mail queue
- limited outgoing threads
- Maintenance switches
- independent locks for MQL, WS, WEB, JOB, STACK, BOT and MAIL
Schedule scripts with cron expressions.
All 15 functions
Asynchronous queue of scripts, with flow tracking and replay.
All 26 functions
Start a script when a file arrives or changes.
All 4 functions
Write, call and organize the MQL scripts.
All 36 functions
Keep the history of the scripts.
All 7 functions
Web, APIs and applications
Call the outside world, and build web applications.
Call any REST API, with retries, authentication and pagination.
All 8 functions
Call SOAP web services, through a proxy if needed.
All 2 functions
Read and build web addresses.
All 4 functions
Read and search web pages.
All 10 functions
Build the web applications served by MentDB.
All 15 functions
Attach host names to the applications.
All 4 functions
Generate the scripts that read and write a table.
All 10 functions
Get a token for the Microsoft services.
All 1 function
Create a Stripe payment session.
All 1 function
Databases and connections
Read and write your data, wherever it is.
Query and load relational databases, with bulk loading.
All 35 functions
Named connections, kept apart from the scripts.
All 30 functions
Work with MongoDB collections.
All 22 functions
Cache and shared data, with a native client.
All 22 functions
JSON documents stored inside MentDB.
All 15 functions
Work on rows in memory, like SQL without a database.
All 14 functions
Files and transfers
Move and process files on every protocol.
Read, write and manage files and folders.
All 44 functions
Transfer files by FTP.
All 17 functions
Transfer files by FTP over TLS.
All 18 functions
Transfer files over SSH.
All 16 functions
Reach Windows shares.
All 6 functions
Run commands and copy files on a remote machine.
All 7 functions
Object storage, on AWS and on compatible services.
All 10 functions
Create and extract archives.
All 14 functions
Run MQL on another MentDB server.
All 9 functions
Messages, mail and networks
Exchange messages, and watch the network.
Produce and consume Kafka messages.
All 8 functions
Talk to machines and connected objects.
All 4 functions
Queues between applications.
All 10 functions
Send mails and read mailboxes.
All 20 functions
Read and write archived mails.
All 7 functions
Invitations and contacts that open everywhere.
All 5 functions
Supervise hosts, ports and certificates.
All 14 functions
Business and sector exchanges
The standards of accounting, banks, trade and healthcare.
Electronic invoices.
All 8 functions
Bank payment files.
All 3 functions
Read bank statements and reconcile them.
All 7 functions
The French accounting export.
All 3 functions
Exchanges with large customers and logistics.
All 10 functions
Messages of hospital systems.
All 6 functions
REST services of healthcare.
All 9 functions
Artificial intelligence
Language models, bots and text analysis.
Use a language model in your flows.
All 9 functions
Vectors, similarity and semantic search.
All 10 functions
Build chat bots trained on your questions.
All 34 functions
Understand large volumes of text.
All 19 functions
Machine learning
Train, explain and use models, without leaving MQL.
Train, compare, explain and save models.
All 27 functions
Prepare data for the models.
All 22 functions
Measure the quality of a model.
All 19 functions
Find groups and unusual values.
All 16 functions
Forecast and analyze series.
All 24 functions
Recommend items, and count on data streams.
All 14 functions
Optimize and analyze graphs.
All 5 functions
Find rules and patterns in transactions.
All 20 functions
Clusters and decision nodes kept in memory.
All 25 functions
Neural networks for classification.
All 7 functions
Regressions kept in memory.
All 46 functions
Analytics and data quality
Understand the business, and trust the data.
Define rules and analyze the quality of your data.
All 8 functions
Discover what a table contains.
All 2 functions
See when the data changes.
All 1 function
Find the same customer written differently.
All 2 functions
The usual questions of a business.
All 5 functions
Measure and forecast marketing.
All 6 functions
Rebuild and analyze your real processes from logs.
All 12 functions
Statistics and research
Statistical methods, many of them compared with R.
Descriptive statistics, tests and distributions.
All 49 functions
Models for experiments and observational data.
All 15 functions
Time until an event.
All 5 functions
Bayesian estimates and tests.
All 8 functions
Measure the real effect of an action.
All 9 functions
Bootstrap, permutations and meta-analysis.
All 4 functions
Compare methods and fit doses.
All 4 functions
Estimates from surveys.
All 7 functions
Plan and analyze experiments.
All 10 functions
Industrial quality and laboratory validation.
All 26 functions
Calibration models.
All 2 functions
Operations, finance and geography
Decide with numbers: stock, staff, routes, risks.
Loans, investments and market risks.
All 14 functions
Insurance calculations.
All 7 functions
Stock and demand.
All 9 functions
Size the teams and the counters.
All 10 functions
Tours and workshops.
All 6 functions
Networks and project schedules.
All 5 functions
Optimize under constraints.
All 3 functions
Reliability and yield.
All 6 functions
Distances, areas and map formats.
All 32 functions
Mathematics and science
A complete calculation library, also available in the calculator of the editor.
Everyday mathematics, in exact decimal when it counts.
All 77 functions
Number theory.
All 20 functions
Calculations with arbitrary precision.
All 13 functions
Linear algebra.
All 31 functions
Complex numbers.
All 25 functions
Numerical methods.
All 25 functions
Functions of physics and statistics.
All 21 functions
bessel_j(nu, x)bessel_y(nu, x)bessel_i(nu, x)bessel_k(nu, x)sph_bessel_j(n, x)sph_bessel_y(n, x)legendre(n, x)assoc_legendre(n, m, x)hermite(n, x)laguerre(n, x)chebyshev_t(n, x)chebyshev_u(n, x)gamma(x)lgamma(x)digamma(x)polygamma(n, x)beta(a, b)gamma_inc(a, x)beta_inc(a, b, x)erf(x)zeta(s) Symbolic calculation.
All 10 functions
Filter and analyze signals.
All 15 functions
Draw curves and charts.
All 11 functions
Physical constants.
All 3 functions
Convert and calculate with units.
All 4 functions
The MQL language
A language made for data flows, with thousands of ready functions.
How to write MQL.
All 1 function
The types of the variables and parameters.
All 10 functions
Conditions and loops.
All 15 functions
Comparison, logic and calculation.
All 29 functions
Dates, durations and business days.
All 82 functions
Everything on text.
All 173 functions
Work on lists without loops.
All 31 functions
Check a value.
All 39 functions
Mathematical and physical constants as functions.
All 37 functions
Applications in several languages.
All 9 functions
Separated lists in a text.
All 21 functions
Cluster and high availability
Several servers working together.
Connect the MentDB servers.
All 22 functions
Cluster operation
Run and deploy across the servers.
Cluster-aware jobsDeploy signalsHot tunnels
Details
- Cluster-aware jobs
- a script per job decides where it runs
- Deploy signals
- scheduled MQL signals sent to all the nodes
- Hot tunnels
- remote connection kept open between servers
Administration application
A web application to run the server, ready to use.
Follow the server
See what happens now.
DashboardSessions screenLogs screenHistory screenMails screenBackups screen
Details
- Dashboard
- overview of the server
- Sessions screen
- connected sessions
- Logs screen
- search the logs
- History screen
- activity history
- Mails screen
- outgoing mails
- Backups screen
- saved backups
Flows and jobs
Control the automation.
Jobs screenStack screenFlows screenFlow logs screen
Details
- Jobs screen
- scheduled jobs
- Stack screen
- processes of the queue
- Flows screen
- flows and their steps
- Flow logs screen
- logs of a flow
Configuration
Change the settings without editing files.
Config screenParameters screenSequences screenConnections screenMaintenance screen
Details
- Config screen
- server settings, with reload
- Parameters screen
- settings of the applications
- Sequences screen
- counters
- Connections screen
- connection manager
- Maintenance screen
- maintenance switches
Accounts and networks
People, servers and web access.
Accounts screenGroups screenCluster screenSignals screenWeb apps screenFirewall screenBlocked IP screen
Details
- Accounts screen
- users and their history
- Groups screen
- groups and rights
- Cluster screen
- the nodes
- Signals screen
- cluster signals
- Web apps screen
- web applications
- Firewall screen
- web requests by IP
- Blocked IP screen
- blocked addresses
Bots and AI
Manage bots and models.
Bots screenBot users screenBot trainings screenUnmatched questionsAI models screen
Details
- Bots screen
- the bots
- Bot users screen
- users of the bots
- Bot trainings screen
- training versions
- Unmatched questions
- questions the bot did not understand
- AI models screen
- machine learning models, sketches, CAS status
Build your own applications
A starting point for your web applications.
Multilingual interfaceApplication templateChart objectsSCRUD scripts
Details
- Multilingual interface
- languages, translations, tags and help
- Application template
- reusable default template
- Chart objects
- ready-made charts
- SCRUD scripts
- list and form screens from a table
Desktop editor
The workbench of the MQL developer, on Windows, macOS and Linux.
Develop
Write and run MQL.
Saved connectionsThree workspacesSyntax highlightingAutocompletionTabs and historyFind and replaceKeyboard shortcuts
Details
- Saved connections
- launcher with your servers
- Three workspaces
- development, connection and administration trees
- Syntax highlighting
- MQL coloring
- Autocompletion
- functions and parameters
- Tabs and history
- multiple tabs, output and command history
- Find and replace
- find, replace, replace all
- Keyboard shortcuts
- execute, undo, find, switch tabs
Generate
Let the editor write the repetitive scripts.
ETL generatorSCRUD generator
Details
- ETL generator
- source and target templates across CIFS, FTP, FTPS, local, MentDB, SCP and SFTP
- SCRUD generator
- from a table to a web CRUD
See the results
Read and export what the scripts return.
Data gridLine and scatter charts
Details
- Data grid
- results table, with export
- Line and scatter charts
- charts grouped by time
Calculator
A scientific calculator inside the editor.
CalculatorSymbolic calculationUnit calculationFunction plottingScience pages
Details
- Calculator
- calculation, constants, special functions and units pages
- Symbolic calculation
- integrate, solve, factor, expand, limit, series
- Unit calculation
- expressions like 100 km/h -> m/s
- Function plotting
- plot the current or the selected lines
- Science pages
- ML, statistics, numerical, big decimal, DSP, matrix, vector
Deploy and operate
Move scripts between servers and watch them.
Check or deployScript diffFile transferStack and log viewersCluster refreshMaintenance indicators
Details
- Check or deploy
- compare and deploy scripts across servers
- Script diff
- compare two versions
- File transfer
- upload and download
- Stack and log viewers
- filtered and paged windows
- Cluster refresh
- run a command on several servers
- Maintenance indicators
- lock icons per subsystem
Installation and platforms
Install it on your servers, and keep it up to date.
Platforms
Ready to run.
LinuxmacOSWindowsWindows serviceBundled JDK 21Debian guideGPLv3
Details
- Linux
- launchers for the server and the editor
- macOS
- launchers for the server and the editor
- Windows
- launchers for the server and the editor
- Windows service
- install and uninstall scripts
- Bundled JDK 21
- for Linux, macOS and Windows
- Debian guide
- installation with MySQL
- GPLv3
- open source licence
Upgrades
Update a server safely.
Upgrade checkerUpgrade notes
Details
- Upgrade checker
- finds the libraries missing on a server
- Upgrade notes
- what to copy and what changes