# Rfam MySQL Tutorial

> Six live MySQL tables with filters and pagination

- Vendor: `rfammysqltutorial` · version 1.0 · category Database · tags mysql, rfam, tutorial
- Datasource: MySQL tables
- Marketplace page: https://apiclay.com/api/rfammysqltutorial
- This document: https://apiclay.com/docs/rfammysqltutorial.md
- OpenAPI 3.1: https://apiclay.com/api/rfammysqltutorial/openapi.json
- MCP: connect https://api.apiclay.com/v1/mcp (see https://apiclay.com/llms.txt), then `apiclay_describe_api` with vendor `rfammysqltutorial`
- Updated: 2026-11-18

## About

## Rfam MySQL Tutorial

A private educational API over the six main tables of Rfam’s public read-only MySQL database.

### Endpoints

| GET endpoint | Allowed equality filters |
| --- | --- |
| /family | rfam_acc, rfam_id, type |
| /rfamseq | rfamseq_acc, ncbi_id, mol_type |
| /full_region | rfam_acc, rfamseq_acc, is_significant |
| /clan | clan_acc, id |
| /clan_membership | clan_acc, rfam_acc |
| /taxonomy | ncbi_id, species |

Each endpoint returns the selected response columns as JSON, up to 10 rows per request. Multiple non-empty filters are combined with AND. These are exact equality filters; this mode does not expose arbitrary SQL, joins, OR or LIKE.

### Pagination and examples

Use page=1, then page=2 for the next ten results. Reset to page 1 after changing filters.

- /family?page=2
- /family?rfam_acc=RF00001&amp;rfam_id=5S_rRNA&amp;page=1
- /rfamseq?rfamseq_acc=AAAA02000879.1&amp;ncbi_id=39946&amp;page=1
- /full_region?rfam_acc=RF00061&amp;rfamseq_acc=AF009606.1&amp;is_significant=1&amp;page=1
- /clan?clan_acc=CL00001&amp;id=tRNA&amp;page=1
- /clan_membership?clan_acc=CL00001&amp;page=1
- /taxonomy?ncbi_id=9606&amp;page=1

Table totals were fetched on November 11, 2026. They are dataset totals, not filtered match counts, and may change. Large datasets should be queried through selective filters. Pagination has a maximum offset of 10 million rows; it is not an unlimited bulk-export mechanism.

### Public source

Host: mysql-rfam-public.ebi.ac.uk; port: 4497; database: Rfam; user: rfamro; password: empty. These connection values are public. APIClay account tokens remain private.

Source and attribution: [Rfam public MySQL documentation](https://docs.rfam.org/database.html#main-tables). Rfam data belongs to the Rfam project.

## Pricing

- Pay as you go: 0.0001 credits/request
- Billing order: trial requests -> subscribed plan requests -> pay as you go. 1 credit's USD value is shown on the marketplace page.

## Tables

Each table is `GET https://api.apiclay.com/v1/api/rfammysqltutorial/<table>`. Filter with the query fields as query parameters, paginate with `?page=N` (1-based). A page returns up to the table's row limit (the trial limit while on trial).

### family
- Gateway: `GET https://api.apiclay.com/v1/api/rfammysqltutorial/family`
- Query fields: `rfam_acc`, `rfam_id`, `type`
- Rows per page: 10 (trial: 5); total rows: 4,227

### rfamseq
- Gateway: `GET https://api.apiclay.com/v1/api/rfammysqltutorial/rfamseq`
- Query fields: `rfamseq_acc`, `ncbi_id`, `mol_type`
- Rows per page: 10 (trial: 5); total rows: 82,489,503

### full_region
- Gateway: `GET https://api.apiclay.com/v1/api/rfammysqltutorial/full_region`
- Query fields: `rfam_acc`, `rfamseq_acc`, `is_significant`
- Rows per page: 10 (trial: 5); total rows: 10,645,620

### clan
- Gateway: `GET https://api.apiclay.com/v1/api/rfammysqltutorial/clan`
- Query fields: `clan_acc`, `id`
- Rows per page: 10 (trial: 5); total rows: 152

### clan_membership
- Gateway: `GET https://api.apiclay.com/v1/api/rfammysqltutorial/clan_membership`
- Query fields: `clan_acc`, `rfam_acc`
- Rows per page: 10 (trial: 5); total rows: 480

### taxonomy
- Gateway: `GET https://api.apiclay.com/v1/api/rfammysqltutorial/taxonomy`
- Query fields: `ncbi_id`, `species`
- Rows per page: 10 (trial: 5); total rows: 765,505

## Call example

```bash
curl "https://api.apiclay.com/v1/api/rfammysqltutorial/family?rfam_acc=<rfam_acc>&rfam_id=<rfam_id>&page=1" \
  -H "token: <YOUR_APICLAY_TOKEN>"
```

Index of every published API: https://apiclay.com/llms.txt
