Everything MentDB can do

Features

Every feature of the server, by category. Search a technology, a standard or a need, then open it to reach the functions and their live examples.

20 categories927 tags2190 functions
FunctionsRecipesFeatures

Server and web platform

One Java server that runs your scripts, serves your web applications and exposes your APIs.

Web server

An embedded web server, configured from one file.

Embedded JettyWeb applicationsVirtual hostsStart, stop, restartCORSWebSocket
Details
Embedded Jetty
HTTPS private, HTTP public and HTTPS public listeners
Web applications
create HTTP and HTTPS applications from templates, with JSP support
Virtual hosts
map a host name to an application, per protocol
Start, stop, restart
control the HTTP and HTTPS listeners without stopping the server
CORS
full filter options on the API
WebSocket
MQL sessions through a WebSocket endpoint

REST API provider

Every script can become a documented web service.

REST APIInteractive API docsAPI tokens
Details
REST API
GET, POST, PUT and DELETE scripts exposed on /api
Interactive API docs
a /docs page with TRY buttons
API tokens
JWT sessions by x-token with a configurable time-out

Native MQL access

Scripts and clients talk to the server through an encrypted port.

Encrypted MQL portSession limits
Details
Encrypted MQL port
encrypted socket port, remote access allowed or denied
Session limits
maximum sessions, connect and idle time-outs, pool size

Storage and settings

The internal database and the configuration of the server.

H2 or MySQLHot reloadAutomatic backupsMetrics history
Details
H2 or MySQL
embedded H2 database or MySQL server
Hot reload
settings marked reloadable apply without a restart
Automatic backups
database, configuration and certificates, with retention
Metrics history
CPU, memory and web requests, with retention

Portal

The home page of the server.

Application portalFault-tolerant tilesDocumentation at startup
Details
Application portal
tiles for the installed applications, configurable titles
Fault-tolerant tiles
an application in error is skipped and logged
Documentation at startup
functions, use cases and this page rebuilt when the server starts

Metric20

Measure the machine and the Java virtual machine.

All 20 functions

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

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

Stack26

Asynchronous queue of scripts, with flow tracking and replay.

All 26 functions

Script36

Write, call and organize the MQL scripts.

All 36 functions

Web, APIs and applications

Call the outside world, and build web applications.

Databases and connections

Read and write your data, wherever it is.

SQL35

Query and load relational databases, with bulk loading.

All 35 functions

CM30

Named connections, kept apart from the scripts.

All 30 functions

MongoDB22

Work with MongoDB collections.

All 22 functions

Files and transfers

Move and process files on every protocol.

File44

Read, write and manage files and folders.

All 44 functions

Messages, mail and networks

Exchange messages, and watch the network.

Data and document formats

Convert and produce every usual format.

PDF45

Create, read, merge and fill PDF documents.

All 45 functions

Business and sector exchanges

The standards of accounting, banks, trade and healthcare.

Artificial intelligence

Language models, bots and text analysis.

Bot34

Build chat bots trained on your questions.

All 34 functions

Machine learning

Train, explain and use models, without leaving MQL.

ML Models27

Train, compare, explain and save models.

All 27 functions

ML Data preparation22

Prepare data for the models.

All 22 functions

ML Pattern mining20

Find rules and patterns in transactions.

All 20 functions

Machine Learning25

Clusters and decision nodes kept in memory.

All 25 functions

Predictive analysis46

Regressions kept in memory.

All 46 functions

Analytics and data quality

Understand the business, and trust the data.

Statistics and research

Statistical methods, many of them compared with R.

Statistics49

Descriptive statistics, tests and distributions.

All 49 functions

Quality and laboratory26

Industrial quality and laboratory validation.

All 26 functions

Operations, finance and geography

Decide with numbers: stock, staff, routes, risks.

Geospatial32

Distances, areas and map formats.

All 32 functions

Mathematics and science

A complete calculation library, also available in the calculator of the editor.

Math77

Everyday mathematics, in exact decimal when it counts.

All 77 functions

The MQL language

A language made for data flows, with thousands of ready functions.

Date82

Dates, durations and business days.

All 82 functions

String173

Everything on text.

All 173 functions
string asciistring binstring bit_lengthstring charstring char_lengthstring char_to_intconcatstring csv_valuestring sentence_distancestring sentences_distancestring orderstring get_variablestring levenshtein_distancestring md5string shastring sha_256string countstring bcrypt_hashstring bcrypt_verifystring encode_sign_generate_keypairstring encode_signstring decode_sign_verifystring encode_rsa_generate_keypairstring encode_rsastring decode_rsastring encode_des_generate_keystring encode_desstring decode_desstring encode_blowfishstring decode_blowfishstring encode_pbestring decode_pbestring encode_b64string decode_b64string del_char_before_each_linestring mql_to_htmlstring ends_withstring first_letter_upperstring first_letterstring generate_random_strstring hexstring hex_to_intstring hex_to_strstring indentstring instrstring int_to_charstring int_to_hexstring int_to_octstring is_letterstring is_alpha_num_udsstring is_alpha_numstring is_number_charstring itrimstring lcasestring leftstring lengthstring likestring locatestring lowerstring lpadstring lrtrimstring lrtrim0string ltrimstring matchesstring midstring not_likestring not_regexpstring octstring oct_to_intstring positionstring regexpstring repeatstring repeat_insert_strstring replacestring reversestring rightstring rpadstring rtrimstring spacestring splitstring split_mqlstring split_sentencestring starts_withstring starts_with_orstring str_to_hexstring strcmpstring strposstring sublrcharstring substrstring substringstring to_stringstring encodestring empty_if_nullstring null_if_emptystring trimstring txtstring txt2string ucasestring unhexstring upperstring zerostring uuidstring unaccentstring slugifystring url_encodestring url_decodestring html_escapestring html_unescapestring json_escapestring sha_512string capitalize_wordsstring camel_casestring snake_casestring kebab_casestring is_blankstring regexp_countstring hmac_sha256string truncatestring containsstring contains_ignore_casestring equals_ignore_casestring regexp_replacestring regexp_extracttype is_matches_regexstring jaro_winklerstring soundexstring phonetic_frstring normalizestring ngramsstring maskstring templatestring encode_b32string decode_b32string crc32string sha3string ulidstring uuid7string formatstring number_formatstring wordwrapstring strip_tagsstring natural_comparestring natural_sortstring similar_textstring word_countstring strtrstring query_parsestring query_buildstring qp_encodestring qp_decodestring collate_comparestring collate_sortstring betweenstring nl2brstring grapheme_lengthstring grapheme_substrstring sscanfstring pad_centerstring chunk_splitstring count_charsstring metaphonestring encrypt_aesstring decrypt_aesstring generate_key_aesstring hmacstring hmac_verifystring hashstring random_bytesstring encode_b64urlstring decode_b64urlstring regexp_allstring regexp_splitstring regexp_quote

Type39

Check a value.

All 39 functions

Constant37

Mathematical and physical constants as functions.

All 37 functions

Cluster and high availability

Several servers working together.

Cluster22

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