# Service

Schema reference for service configurations and the version sets they expose.

### Services Table

**Table Name:** `services`\
**Description:** Service configurations and metadata

{% tabs %}
{% tab title="Schema" %}

| Column                                  | Type      | Description             |
| --------------------------------------- | --------- | ----------------------- |
| `_id`                                   | string    | Service identifier      |
| `agent_id`                              | string    | Associated agent ID     |
| `created_at`                            | timestamp | Creation timestamp      |
| `description`                           | string    | Service description     |
| `is_active`                             | boolean   | Active status           |
| `name`                                  | string    | Service name            |
| `org_id`                                | string    | Organization identifier |
| `region_name`                           | string    | Deployment region       |
| `service_hierarchical_state_machine_id` | string    | State machine ID        |
| `tags`                                  | json      | Service tags            |
| `updated_at`                            | timestamp | Last update timestamp   |
| `version_sets`                          | json      | Available version sets  |
| {% endtab %}                            |           |                         |

{% tab title="Query Example" %}

```sql
SELECT
  _id AS service_id,
  name,
  description,
  is_active,
  version_sets
FROM services
WHERE is_active = true;
```

{% endtab %}
{% endtabs %}