---
name: "rasql"
section: "1"
platform: "linux"
package: "argus-client"
version: "1:5.0.2+git20250321.41f65e2-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/rasql"
---

# rasql(1)

read argus(8) data from mysql database.

## NAME

**rasql** - read **[argus(8)](/argus/8.md)** data from mysql database.

## SYNOPSIS

**rasql** \[**-M** *sql='where clause'*\] -r mysql://user@host/db/table \[**raoptions**\] \[**--** *filter-expression*\]

## DESCRIPTION

**Rasql** reads **argus** data from an argus-client generated mysql database.

The principal function of rasql is to extract the 'record' binary blob that is inserted by *rasqlinsert.1* when adding argus data to a mysql table.

## RASQL SPECIFIC OPTIONS

Rasql, like all ra based clients, supports a number of **ra options**  including filtering of input argus records through a terminating filter expression.  **[rasql(1)](/rasql/1.md)** specific options are:

- **-M** *sql='where clause'*

  This appends the 'where clause' to the SELECT mysql database command. providing a means to use SQL select and join strategies when performing queries.

## INVOCATION

This invocation reads **[argus(8)](/argus/8.md)** data from the *table* table that is contained in the *db* database, using the *user* database account, and instructs MySQL to select records where the database attribute 'saddr' equals to the string '2.3.4.5'.

```
   rasql -r mysql://user@localhost/db/table -M sql="saddr='2.3.4.5'"
```

## COPYRIGHT

Copyright (c) 2000-2024 QoSient. All rights reserved.

## SEE ALSO

**[ra(1)](/ra/1.md),** **[rasqlinsert(1)](/rasqlinsert/1.md),** **[rarc(5)](/rarc/5.md),** **[argus(8)](/argus/8.md),**

## AUTHORS

```
Carter Bullard (carter@qosient.com).
```