String-string translation

Whenever you need to replace one string with another when handling anything in maddy, you can use any of the following modules to obtain the replacement string. They are commonly called "table modules" or just "tables".

Some table modules implement write options allowing other maddy modules to change the source of data, effectively turning the table into a complete interface to a key-value store for maddy. Such tables are referred to as "mutable tables".

File mapping (table.file)

This module builds string-string mapping from a text file.

File is reloaded every 15 seconds if there are any changes (detected using modification time). No changes are applied if file contains syntax errors.


file <file path>


file {
    file <file path>

Usage example:

# Resolve SMTP address aliases using text file mapping.
modify {
    replace_rcpt file /etc/maddy/aliases


Better demonstrated by examples:

# Lines starting with # are ignored.

# And so are lines only with whitespace.

# Whenever 'aaa' is looked up, return 'bbb'
aaa: bbb

    # Trailing and leading whitespace is ignored.
    ccc: ddd

# If there is no colon, the string is translated into ""
# That is, the following line is equivalent to
#   aaa:

SQL query mapping (table.sql_query)

The sql_query module implements table interface using SQL queries.


table.sql_query {
    driver <driver name>
    dsn <data source name>
    lookup <lookup query>

    # Optional:
    init <init query list>
    list <list query>
    add <add query>
    del <del query>
    set <set query>

Usage example:

# Resolve SMTP address aliases using PostgreSQL DB.
modify {
    replace_rcpt sql_query {
        driver postgres
        dsn "dbname=maddy user=maddy"
        lookup "SELECT alias FROM aliases WHERE address = $1"

Configuration directives

Syntax: driver driver name

Driver to use to access the database.

Supported drivers: postgres, sqlite3 (if compiled with C support)

Syntax: dsn data source name

Data Source Name to pass to the driver. For SQLite3 this is just a path to DB file. For Postgres, see

Syntax: lookup query

SQL query to use to obtain the lookup result.

It will get one named argument containing the lookup key. Use :key placeholder to access it in SQL. The result row set should contain one row, one column with the string that will be used as a lookup result. If there are more rows, they will be ignored. If there are more columns, lookup will fail. If there are no rows, lookup returns "no results". If there are any error - lookup will fail.

Syntax: init queries...
Default: empty

List of queries to execute on initialization. Can be used to configure RDBMS.

Example, to improve SQLite3 performance:

table.sql_query {
    driver sqlite3
    dsn whatever.db
    init "PRAGMA journal_mode=WAL" \
        "PRAGMA synchronous=NORMAL"
    lookup "SELECT alias FROM aliases WHERE address = $1"

Syntax: add query
Syntax: list query
Syntax: set query
Syntax: del query
Default: none

If queries are set to implement corresponding table operations - table becomes "mutable" and can be used in contexts that require writable key-value store.

'add' query gets :key, :value named arguments - key and value strings to store. They should be added to the store. The query should not add multiple values for the same key and should fail if the key already exists.

'list' query gets no arguments and should return a column with all keys in the store.

'set' query gets :key, :value named arguments - key and value and should replace the existing entry in the database.

'del' query gets :key argument - key and should remove it from the database.

Static table (table.static)

The 'static' module implements table lookups using key-value pairs in its configuration.

table.static {
    entry KEY1 VALUE1
    entry KEY2 VALUE2

Configuration directives

Syntax: entry key _value_

Add an entry to the table.

If the same key is used multiple times, the last one takes effect.

Regexp rewrite table (table.regexp)

The 'regexp' module implements table lookups by applying a regular expression to the key value. If it matches - 'replacement' value is returned with $N placeholders being replaced with corresponding capture groups from the match. Otherwise, no value is returned.

The regular expression syntax is the subset of PCRE. See for details.

table.regexp <regexp> [replacement] {
    full_match yes
    case_insensitive yes
    expand_placeholders yes

Note that [replacement] is optional. If it is not included - table.regexp will return the original string, therefore acting as a regexp match check. This can be useful in combination in destination_in (maddy-smtp(5)) for advanced matching:

destination_in regexp ".*-bounce+.*" {

Configuration directives

Syntax: full_match boolean
Default: yes

Whether to implicitly add start/end anchors to the regular expression. That is, if 'full_match' is yes, then the provided regular expression should match the whole string. With no - partial match is enough.

Syntax: case_insensitive boolean
Default: yes

Whether to make matching case-insensitive.

Syntax: expand_placeholders boolean
Default: yes

Replace '$name' and '${name}' in the replacement string with contents of corresponding capture groups from the match.

To insert a literal $ in the output, use $$ in the template.

Identity table (table.identity)

The module 'identity' is a table module that just returns the key looked up.

table.identity { }

No-op table (dummy)

The module 'dummy' represents an empty table.

dummy { }