> ## Documentation Index
> Fetch the complete documentation index at: https://docs.myrmex.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Firebird

> Connect a Firebird database to Myrmex — create an audit user and add the integration.

import { Note, Steps, Step, CardGroup, Card, Tip } from '@mintlify/components';

Connect your **Firebird** database so Myrmex can audit its hardening and compliance, check its operational health, explore its schema, and — with approval — run SQL for you. Myrmex reaches the database over the Firebird wire protocol through a [Collector](/documentation/agent-endpoint-security/collector-mode) on your network. Operations run live and on demand through the [Integration Specialist](/documentation/multi-agent-system/integration-specialist-agent) agent — Myrmex reads only what you ask for and keeps none of your data on the Myrmex side.

## What Myrmex Can Do

<CardGroup cols={2}>
  <Card title="Compliance audit" icon="shield-halved">
    Run a [Security Posture](/documentation/security-posture/overview) audit and map findings to ISO 27001, NIST CSF, and BACEN [frameworks](/documentation/security-posture/frameworks) (Firebird has no CIS benchmark).
  </Card>

  <Card title="Health checks" icon="heart-pulse">
    Review active attachments, transaction gaps, and page and cache activity.
  </Card>

  <Card title="Explore tables" icon="table">
    List tables so you can see what the database holds.
  </Card>

  <Card title="Describe structure" icon="sitemap">
    Inspect columns, types, indexes, and constraints for any table.
  </Card>

  <Card title="Sensitive-data scan" icon="user-secret">
    Scan tables and columns for personal or sensitive data that needs protection.
  </Card>

  <Card title="Run SQL" icon="terminal">
    Execute read queries any time; write statements (DDL/DML) require your confirmation.
  </Card>
</CardGroup>

## Before You Start

* A **Collector** on a network that can reach the Firebird server on its TCP port (default `3050`). See [Collector mode](/documentation/agent-endpoint-security/collector-mode).
* The Collector host must have the native **Firebird client library** (`libfbclient.so.2`) installed — it is required for remote attach, and mandatory for servers with `WireCrypt = Required`.
* An **audit account** for Myrmex (create it in Step 1).
* The **Database** field is the server-side database path or alias (e.g. `/var/lib/firebird/data/app.fdb`, or an alias from `databases.conf`).

## Step 1 — Create the Credential in Firebird

Connect as `SYSDBA`, or create a dedicated user granted the `RDB$ADMIN` role — needed to read `SEC$USERS` and the full `MON$` monitoring tables the audit relies on.

```sql theme={null}
-- Connected to the security database as SYSDBA
CREATE USER MYRMEX_AUDIT PASSWORD 'a-strong-password';
GRANT RDB$ADMIN TO USER MYRMEX_AUDIT;
```

<Tip>
  Use the audit account for read-only work. Provide a write-capable user only if you want the agents to run write statements (DDL/DML) through **Run SQL**.
</Tip>

## Step 2 — Add the Integration in Myrmex

From the **Directory**, choose **Add Integration → Firebird**, then fill in:

| Field                     | Description                                                                                                     |
| ------------------------- | --------------------------------------------------------------------------------------------------------------- |
| **Name**                  | A unique name for this database.                                                                                |
| **Description**           | Optional note to identify the instance.                                                                         |
| **Host**                  | Firebird server host or IP.                                                                                     |
| **Port**                  | TCP port (default `3050`).                                                                                      |
| **Database Path / Alias** | Server-side database file path or alias (e.g. `/var/lib/firebird/data/app.fdb`).                                |
| **Username**              | `SYSDBA` or an `RDB$ADMIN`-role user (read), or a write-capable user (operations). Defaults to `SYSDBA`.        |
| **Password**              | Password (stored encrypted).                                                                                    |
| **SSL Mode**              | Firebird wire encryption (WireCrypt) is handled by the native client; use `disable` for typical on-prem setups. |
| **Collectors**            | The [Collector(s)](/documentation/agent-endpoint-security/collector-mode) that can reach this database.         |

## Connect

Click **Connect** to validate the login. The database then appears under **Environment → Integrations** alongside your other [integrations](/documentation/integrations/overview), and you can start asking the AI about it in the Workspace.

## Notes

* **Read-only by default.** Auditing, health, schema exploration, and sensitive-data scans only need the audit account. Provide a write-capable user only if you want confirmation-gated **Run SQL** writes.
* **Nothing is stored.** Every operation runs in real time through the Collector; results return to your Workspace and no database data is retained on the Myrmex side.
* **Wire encryption.** For servers with `WireCrypt = Required`, make sure the native `libfbclient` is present on the Collector so the connection can complete.