Use caseMySQL database firewall

Stop risky SQL before it reaches MySQL

SWOT DAM includes a database firewall, its SQL Gateway. It sits between your applications and MySQL 8.4 and decides every statement against policy before it runs, with nothing installed on the database. A blocked statement returns the database’s own policy error; the session stays open.

Book a demoSee it work

MySQL limits to know before a pilot

  1. 01

    Pipelined commands run one at a time

    Results are correct, with no speed-up from pipelining. Nothing needs to change.

  2. 02

    Result-size limits close the session

    A blocked result-size limit returns an error, then disconnects. Use ALERT for result-size limits.

  3. 03

    Statements prepared inside functions

    Statements prepared inside functions or procedures and run by name are refused in protect mode. Prepare them through the driver.

See it work

One query, two views

Pick a query from a sample session and see what is stopped before it reaches the database, and what SWOT DAM sees inside.

Sample session by db_support on Billing PostgreSQL.

SWOT PAM · at the door

Connected as

pam_tmp_db_support_8c1 temporary, removed on disconnect

Verdict

SWOT DAM · inside

Audit record

Sensitive columns

    Identity risk

    How it works

    How the MySQL gateway works

    1. Point clients at the gateway

      Applications and tools connect to the SQL Gateway instead of the database. Verified on MySQL 8.4: PyMySQL, Connector/Python, Connector/J 9.1 with HikariCP, and the mysql CLI. For drivers or versions not listed, pilot first.

    2. Decide every statement

      Every statement is decided against policy before it runs. Rules match on user, source IP, sensitive tables, statement type and risk score.

      SWOT DAM
    3. Block the statement, keep the session

      A blocked statement returns the database’s own policy error and the session stays open, so applications keep working. Traffic the gateway cannot read is refused, never passed on.

    4. Monitor through server_audit

      SWOT DAM collectors read server_audit, the database’s own audit trail, and score each identity against its own 30-day baseline.

      SWOT DAM

    Questions

    Related

    Does SWOT DAM work as a MySQL database firewall with Connector/J?

    Yes. Connector/J 9.1 with HikariCP is verified through the SQL Gateway on MySQL 8.4, as are PyMySQL, Connector/Python and the mysql CLI. For drivers or versions not listed, pilot first.

    Is MariaDB covered?

    For monitoring, yes: SWOT DAM reads the MariaDB audit trail. The SQL Gateway is verified on MySQL 8.4.

    What does an application see when a statement is blocked?

    The database’s own policy error. The session stays open, so the application keeps working; only the risky statement is stopped. A blocked result-size limit is the exception: it closes the session, so use ALERT for those.

    See it on your own systems

    A walk-through of SWOT DAM with the team that builds them.

    Book a demoContact us