Skip to content

maton-ai/api-gateway-skill

api-gateway

Verified

Call third-party APIs through the Maton gateway, which injects the credential for an app the user has already connected. Use this skill when the user names a connected app and a concrete action in it - read a mailbox, query a CRM, file an issue, update a spreadsheet, run a query through a connected search or scraping provider. Every call goes to an app the user connected. It is not a general-purpose browser or network client, and it cannot reach a service with no Maton connection. It also manages event triggers, webhook destinations that forward event payloads to an external URL until deleted, and local `--exec` handlers that run a script per event - separate, high-risk capabilities beyond a normal API call. Default to read and list calls; every write, connection, trigger, destination, or handler needs explicit user confirmation.

FileKindSize
SKILL.mdskill md55.7 KB
references/active-campaign/README.mdmarkdown12.8 KB
references/acuity-scheduling/README.mdmarkdown11.3 KB
references/airtable/README.mdmarkdown5.8 KB
references/apify/README.mdmarkdown14.6 KB
references/apollo/README.mdmarkdown7.0 KB
references/asana/README.mdmarkdown12.6 KB
references/attio/README.mdmarkdown12.7 KB
references/basecamp/README.mdmarkdown14.9 KB
references/baserow/README.mdmarkdown15.8 KB
references/beehiiv/README.mdmarkdown12.2 KB
references/box/README.mdmarkdown21.8 KB
references/brave-search/README.mdmarkdown13.7 KB
references/brevo/README.mdmarkdown17.5 KB
references/buffer/README.mdmarkdown13.6 KB
references/cal-com/README.mdmarkdown14.9 KB
references/calendly/README.mdmarkdown16.0 KB
references/calendly/triggers.mdmarkdown9.6 KB
references/callrail/README.mdmarkdown11.0 KB
references/chargebee/README.mdmarkdown7.2 KB
references/clickfunnels/README.mdmarkdown17.2 KB
references/clicksend/README.mdmarkdown13.2 KB
references/clickup/README.mdmarkdown15.4 KB
references/clio/README.mdmarkdown11.0 KB
references/clockify/README.mdmarkdown12.2 KB
references/coda/README.mdmarkdown10.7 KB
references/cognito-forms/README.mdmarkdown5.4 KB
references/companycam/README.mdmarkdown14.2 KB
references/confluence/README.mdmarkdown19.0 KB
references/constant-contact/README.mdmarkdown26.7 KB
references/dropbox-business/README.mdmarkdown24.2 KB
references/dropbox/README.mdmarkdown16.8 KB
references/elevenlabs/README.mdmarkdown13.2 KB
references/eventbrite/README.mdmarkdown10.4 KB
references/exa/README.mdmarkdown14.1 KB
references/facebook-page/README.mdmarkdown15.5 KB
references/fal-ai/README.mdmarkdown8.0 KB
references/fastmail/README.mdmarkdown34.0 KB
references/fathom/README.mdmarkdown10.0 KB
references/figma/README.mdmarkdown18.1 KB
references/firebase/README.mdmarkdown11.4 KB
references/firecrawl/README.mdmarkdown17.3 KB
references/fireflies/README.mdmarkdown6.6 KB
references/front/README.mdmarkdown10.6 KB
references/getresponse/README.mdmarkdown15.0 KB
references/github/README.mdmarkdown19.6 KB
references/github/triggers.mdmarkdown63.8 KB
references/google-ads/README.mdmarkdown7.5 KB
references/google-analytics-admin/README.mdmarkdown9.6 KB
references/google-analytics-data/README.mdmarkdown5.7 KB
references/google-apps-script/README.mdmarkdown14.2 KB
references/google-bigquery/README.mdmarkdown13.2 KB
references/google-business-profile/README.mdmarkdown19.8 KB
references/google-calendar/README.mdmarkdown6.8 KB
references/google-classroom/README.mdmarkdown15.7 KB
references/google-contacts/README.mdmarkdown8.2 KB
references/google-docs/README.mdmarkdown4.3 KB
references/google-drive/README.mdmarkdown10.8 KB
references/google-forms/README.mdmarkdown5.2 KB
references/google-mail/README.mdmarkdown7.9 KB
references/google-mail/triggers.mdmarkdown2.1 KB
references/google-meet/README.mdmarkdown5.3 KB
references/google-merchant/README.mdmarkdown19.2 KB
references/google-play/README.mdmarkdown8.3 KB
references/google-search-console/README.mdmarkdown6.2 KB
references/google-sheets/README.mdmarkdown9.0 KB
references/google-slides/README.mdmarkdown8.1 KB
references/google-tag-manager/README.mdmarkdown17.9 KB
references/google-tasks/README.mdmarkdown11.1 KB
references/google-workspace-admin/README.mdmarkdown11.1 KB
references/grafana/README.mdmarkdown10.1 KB
references/granola-mcp/README.mdmarkdown7.2 KB
references/granola-mcp/schemas/get_meeting_transcript.jsonconfig819 B
references/granola-mcp/schemas/get_meetings.jsonconfig1.6 KB
references/granola-mcp/schemas/list_meetings.jsonconfig1.5 KB
references/granola-mcp/schemas/query_granola_meetings.jsonconfig2.1 KB
references/gumroad/README.mdmarkdown13.1 KB
references/highlevel-pit/README.mdmarkdown26.5 KB
references/hubspot/README.mdmarkdown20.3 KB
references/hubspot/triggers.mdmarkdown6.0 KB
references/icloud-mail/README.mdmarkdown21.3 KB
references/instantly/README.mdmarkdown12.6 KB
references/jira/README.mdmarkdown9.3 KB
references/jobber/README.mdmarkdown8.6 KB
references/jotform/README.mdmarkdown7.2 KB
references/kaggle/README.mdmarkdown7.3 KB
references/keap/README.mdmarkdown13.7 KB
references/kibana/README.mdmarkdown10.2 KB
references/kit/README.mdmarkdown10.4 KB
references/klaviyo/README.mdmarkdown36.7 KB
references/lemlist/README.mdmarkdown6.5 KB
references/linear/README.mdmarkdown7.9 KB
references/linear/triggers.mdmarkdown6.5 KB
references/linkedin-community-management/README.mdmarkdown19.6 KB
references/linkedin/README.mdmarkdown22.6 KB
references/mailchimp/README.mdmarkdown18.6 KB
references/mailerlite/README.mdmarkdown15.6 KB
references/mailgun/README.mdmarkdown16.8 KB
references/make/README.mdmarkdown14.3 KB
references/manus/README.mdmarkdown8.1 KB
references/manychat/README.mdmarkdown11.5 KB
references/memelord/README.mdmarkdown10.0 KB
references/microsoft-excel/README.mdmarkdown7.9 KB
references/microsoft-teams/README.mdmarkdown17.0 KB
references/microsoft-to-do/README.mdmarkdown9.2 KB
references/monday/README.mdmarkdown8.0 KB
references/motion/README.mdmarkdown9.9 KB
references/netlify/README.mdmarkdown15.6 KB
references/notion-mcp/README.mdmarkdown14.9 KB
references/notion-mcp/schemas/notion-create-comment.jsonconfig17.6 KB
references/notion-mcp/schemas/notion-create-database.jsonconfig4.6 KB
references/notion-mcp/schemas/notion-create-pages.jsonconfig10.6 KB
references/notion-mcp/schemas/notion-duplicate-page.jsonconfig927 B
references/notion-mcp/schemas/notion-fetch.jsonconfig2.1 KB
references/notion-mcp/schemas/notion-get-comments.jsonconfig1.6 KB
references/notion-mcp/schemas/notion-get-teams.jsonconfig863 B
references/notion-mcp/schemas/notion-get-users.jsonconfig2.3 KB
references/notion-mcp/schemas/notion-move-pages.jsonconfig3.3 KB
references/notion-mcp/schemas/notion-search.jsonconfig4.3 KB
references/notion-mcp/schemas/notion-update-data-source.jsonconfig6.4 KB
references/notion-mcp/schemas/notion-update-page.jsonconfig9.3 KB
references/notion/README.mdmarkdown12.0 KB
references/notion/triggers.mdmarkdown5.2 KB
references/one-drive/README.mdmarkdown16.8 KB
references/one-note/README.mdmarkdown11.3 KB
references/outlook/README.mdmarkdown10.4 KB
references/pdf-co/README.mdmarkdown9.9 KB
references/pipedrive/README.mdmarkdown9.1 KB
references/podio/README.mdmarkdown11.9 KB
references/posthog/README.mdmarkdown12.5 KB
references/quickbooks/README.mdmarkdown13.2 KB
references/quo/README.mdmarkdown11.2 KB
references/reducto/README.mdmarkdown9.4 KB
references/resend/README.mdmarkdown15.8 KB
references/salesforce/README.mdmarkdown14.6 KB
references/sendgrid/README.mdmarkdown16.8 KB
references/sentry/README.mdmarkdown9.8 KB
references/sharepoint/README.mdmarkdown15.6 KB
references/signnow/README.mdmarkdown9.7 KB
references/slack/README.mdmarkdown17.9 KB
references/slack/triggers.mdmarkdown5.6 KB
references/snapchat/README.mdmarkdown14.9 KB
references/squarespace/README.mdmarkdown18.0 KB
references/squareup/README.mdmarkdown21.1 KB
references/stripe/README.mdmarkdown23.6 KB
references/stripe/triggers.mdmarkdown24.6 KB
references/sunsama-mcp/README.mdmarkdown11.1 KB
references/sunsama-mcp/schemas/accept_meeting_invite.jsonconfig827 B
references/sunsama-mcp/schemas/add_subtasks_to_task.jsonconfig663 B
references/sunsama-mcp/schemas/add_task_to_channel.jsonconfig1.7 KB
references/sunsama-mcp/schemas/align_task_with_objective.jsonconfig414 B
references/sunsama-mcp/schemas/append_task_notes.jsonconfig1.3 KB
references/sunsama-mcp/schemas/change_backlog_folder.jsonconfig807 B
references/sunsama-mcp/schemas/create_braindump_task.jsonconfig616 B
references/sunsama-mcp/schemas/create_calendar_event.jsonconfig1.6 KB
references/sunsama-mcp/schemas/create_channel.jsonconfig1.3 KB
references/sunsama-mcp/schemas/create_follow_up_task_from_email.jsonconfig1.9 KB
references/sunsama-mcp/schemas/create_task.jsonconfig580 B
references/sunsama-mcp/schemas/create_weekly_objective.jsonconfig440 B
references/sunsama-mcp/schemas/decline_meeting_invite.jsonconfig695 B
references/sunsama-mcp/schemas/delete_all_incomplete_recurring_task_instances.jsonconfig1.2 KB
references/sunsama-mcp/schemas/delete_calendar_event.jsonconfig1.6 KB
references/sunsama-mcp/schemas/delete_email_thread.jsonconfig674 B
references/sunsama-mcp/schemas/delete_task.jsonconfig915 B
references/sunsama-mcp/schemas/edit_subtask_title.jsonconfig1.7 KB
references/sunsama-mcp/schemas/edit_task_recurrence_rule.jsonconfig448 B
references/sunsama-mcp/schemas/edit_task_time_estimate.jsonconfig418 B
references/sunsama-mcp/schemas/edit_task_title.jsonconfig375 B
references/sunsama-mcp/schemas/get_archived_tasks.jsonconfig162 B
references/sunsama-mcp/schemas/get_backlog_tasks.jsonconfig171 B
references/sunsama-mcp/schemas/get_task_time_estimate.jsonconfig309 B
references/sunsama-mcp/schemas/import_task_from_calendar_event.jsonconfig944 B
references/sunsama-mcp/schemas/list_email_threads.jsonconfig310 B
references/sunsama-mcp/schemas/log_user_feedback.jsonconfig772 B
references/sunsama-mcp/schemas/mark_email_thread_as_read.jsonconfig552 B
references/sunsama-mcp/schemas/mark_subtask_as_completed.jsonconfig409 B
references/sunsama-mcp/schemas/mark_subtask_as_incomplete.jsonconfig411 B
references/sunsama-mcp/schemas/mark_task_as_completed.jsonconfig441 B
references/sunsama-mcp/schemas/mark_task_as_incomplete.jsonconfig282 B
references/sunsama-mcp/schemas/move_calendar_event.jsonconfig2.0 KB
references/sunsama-mcp/schemas/move_task_from_backlog.jsonconfig432 B
references/sunsama-mcp/schemas/move_task_to_backlog.jsonconfig288 B
references/sunsama-mcp/schemas/move_task_to_day.jsonconfig428 B
references/sunsama-mcp/schemas/reorder_tasks.jsonconfig484 B
references/sunsama-mcp/schemas/reposition_task_in_backlog.jsonconfig622 B
references/sunsama-mcp/schemas/restore_task.jsonconfig279 B
references/sunsama-mcp/schemas/schedule_next_call.jsonconfig1.8 KB
references/sunsama-mcp/schemas/search_tasks.jsonconfig292 B
references/sunsama-mcp/schemas/set_calendar_event_allow_task_projections.jsonconfig902 B
references/sunsama-mcp/schemas/set_shutdown_time.jsonconfig508 B
references/sunsama-mcp/schemas/start_task_timer.jsonconfig276 B
references/sunsama-mcp/schemas/stop_task_timer.jsonconfig274 B
references/sunsama-mcp/schemas/timebox_a_task_to_calendar.jsonconfig1.2 KB
references/sunsama-mcp/schemas/toggle_auto_import_events.jsonconfig311 B
references/sunsama-mcp/schemas/unarchive_task.jsonconfig453 B
references/sunsama-mcp/schemas/update_all_incomplete_recurring_task_instances.jsonconfig1.8 KB
references/sunsama-mcp/schemas/update_calendar_preferences.jsonconfig1.1 KB
references/sunsama-mcp/schemas/update_import_event_filters.jsonconfig387 B
references/supabase/README.mdmarkdown10.7 KB
references/systeme/README.mdmarkdown8.7 KB

references/google-bigquery/README.md

View on GitHub
# Google BigQuery

## API Reference

> **Safety:** All write operations (POST, PUT, PATCH, DELETE) require explicit user confirmation before execution. Verify the target resource and intended effect with the user first. See the main [SKILL.md](../../SKILL.md#security--permissions) for full security policy.

**App name:** `google-bigquery`
**Upstream base URL:** `bigquery.googleapis.com`

Replace the upstream base URL with the app name. Everything after the base URL including query strings is kept as-is. Any account-specific part of the base URL and the API credentials are stored in the Maton connection, and the gateway injects both so requests never carry them. For example:

- Upstream: `https://bigquery.googleapis.com/bigquery/v2/projects`
- Gateway: `https://api.maton.ai/google-bigquery/bigquery/v2/projects`

### Projects API

#### List Projects

List all projects accessible to the authenticated user.

```bash
maton api '/google-bigquery/bigquery/v2/projects'
```

**Response:**
```json
{
  "kind": "bigquery#projectList",
  "projects": [
    {
      "id": "my-project-123",
      "numericId": "822245862053",
      "projectReference": {
        "projectId": "my-project-123"
      },
      "friendlyName": "My Project"
    }
  ],
  "totalItems": 1
}
```

### Datasets API

#### List Datasets

BigQuery uses token-based pagination. List responses include a `pageToken` when more results exist:

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/datasets?maxResults=10&pageToken={token}'
```

**Note:** `{projectId}` and `{token}` are placeholders. Replace each of them with real values before sending the request.

**Query parameters:**
- `maxResults` - Maximum number of results to return
- `pageToken` - Token for pagination
- `all` - Include hidden datasets if true

**Response:**
```json
{
  "datasets": [...],
  "nextPageToken": "eyJvZmZzZXQiOjEwfQ=="
}
```

Use the `nextPageToken` value as `pageToken` in subsequent requests.

#### Get Dataset

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}'
```

**Note:** `{projectId}` and `{datasetId}` are placeholders. Replace each of them with real values before sending the request.

#### Create Dataset

```bash
maton api -X POST '/google-bigquery/bigquery/v2/projects/{projectId}/datasets' -H 'Content-Type: application/json' --input - <<'JSON'
{
  "datasetReference": {
    "datasetId": "my_dataset",
    "projectId": "{projectId}"
  },
  "description": "My dataset description",
  "location": "US"
}
JSON
```

**Note:** `{projectId}` is a placeholder. Replace it with a real value before sending the request.

**Response:**
```json
{
  "kind": "bigquery#dataset",
  "id": "my-project:my_dataset",
  "datasetReference": {
    "datasetId": "my_dataset",
    "projectId": "my-project"
  },
  "location": "US",
  "creationTime": "1771059780773"
}
```

#### Update Dataset (PATCH)

```bash
maton api -X PATCH '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}' -H 'Content-Type: application/json' --input - <<'JSON'
{
  "description": "Updated description"
}
JSON
```

**Note:** `{projectId}` and `{datasetId}` are placeholders. Replace each of them with real values before sending the request.

#### Delete Dataset

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}' -X DELETE
```

**Note:** `{projectId}` and `{datasetId}` are placeholders. Replace each of them with real values before sending the request.

**Query parameters:**
- `deleteContents` - If true, delete all tables in the dataset (default: false)

### Tables API

#### List Tables

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables'
```

**Note:** `{projectId}` and `{datasetId}` are placeholders. Replace each of them with real values before sending the request.

**Query parameters:**
- `maxResults` - Maximum number of results to return
- `pageToken` - Token for pagination

#### Get Table

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}'
```

**Note:** `{projectId}`, `{datasetId}` and `{tableId}` are placeholders. Replace each of them with real values before sending the request.

#### Create Table

```bash
maton api -X POST '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables' -H 'Content-Type: application/json' --input - <<'JSON'
{
  "tableReference": {
    "projectId": "{projectId}",
    "datasetId": "{datasetId}",
    "tableId": "my_table"
  },
  "schema": {
    "fields": [
      {"name": "id", "type": "INTEGER", "mode": "REQUIRED"},
      {"name": "name", "type": "STRING", "mode": "NULLABLE"},
      {"name": "created_at", "type": "TIMESTAMP", "mode": "NULLABLE"}
    ]
  }
}
JSON
```

**Note:** `{projectId}` and `{datasetId}` are placeholders. Replace each of them with real values before sending the request.

**Response:**
```json
{
  "kind": "bigquery#table",
  "id": "my-project:my_dataset.my_table",
  "tableReference": {
    "projectId": "my-project",
    "datasetId": "my_dataset",
    "tableId": "my_table"
  },
  "schema": {
    "fields": [
      {"name": "id", "type": "INTEGER", "mode": "REQUIRED"},
      {"name": "name", "type": "STRING", "mode": "NULLABLE"},
      {"name": "created_at", "type": "TIMESTAMP", "mode": "NULLABLE"}
    ]
  },
  "numRows": "0",
  "type": "TABLE"
}
```

#### Update Table (PATCH)

```bash
maton api -X PATCH '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}' -H 'Content-Type: application/json' --input - <<'JSON'
{
  "description": "Updated table description"
}
JSON
```

**Note:** `{projectId}`, `{datasetId}` and `{tableId}` are placeholders. Replace each of them with real values before sending the request.

#### Delete Table

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}' -X DELETE
```

**Note:** `{projectId}`, `{datasetId}` and `{tableId}` are placeholders. Replace each of them with real values before sending the request.

### Table Data API

#### List Table Data

Retrieve rows from a table.

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data'
```

**Note:** `{projectId}`, `{datasetId}` and `{tableId}` are placeholders. Replace each of them with real values before sending the request.

**Query parameters:**
- `maxResults` - Maximum number of results to return
- `pageToken` - Token for pagination
- `startIndex` - Zero-based index of the starting row

**Response:**
```json
{
  "kind": "bigquery#tableDataList",
  "totalRows": "100",
  "rows": [
    {
      "f": [
        {"v": "1"},
        {"v": "Alice"},
        {"v": "1.7710597807E9"}
      ]
    }
  ],
  "pageToken": "..."
}
```

#### Insert Table Data (Streaming)

Insert rows into a table using streaming insert. Note: Requires BigQuery paid tier.

```bash
maton api -X POST '/google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll' -H 'Content-Type: application/json' --input - <<'JSON'
{
  "rows": [
    {"json": {"id": 1, "name": "Alice"}},
    {"json": {"id": 2, "name": "Bob"}}
  ]
}
JSON
```

**Note:** `{projectId}`, `{datasetId}` and `{tableId}` are placeholders. Replace each of them with real values before sending the request.

### Queries API

#### Run Query (Synchronous)

Execute a SQL query and return results directly.

```bash
maton api -X POST '/google-bigquery/bigquery/v2/projects/{projectId}/queries' -H 'Content-Type: application/json' --input - <<'JSON'
{
  "query": "SELECT * FROM `my_dataset.my_table` LIMIT 10",
  "useLegacySql": false,
  "maxResults": 100
}
JSON
```

**Note:** `{projectId}` is a placeholder. Replace it with a real value before sending the request.

**Request body:**
- `useLegacySql` - Use legacy SQL syntax (default: false for GoogleSQL)
- `maxResults` - Maximum results per page
- `timeoutMs` - Query timeout in milliseconds

**Response:**
```json
{
  "kind": "bigquery#queryResponse",
  "schema": {
    "fields": [
      {"name": "id", "type": "INTEGER"},
      {"name": "name", "type": "STRING"}
    ]
  },
  "jobReference": {
    "projectId": "my-project",
    "jobId": "job_abc123",
    "location": "US"
  },
  "totalRows": "2",
  "rows": [
    {"f": [{"v": "1"}, {"v": "Alice"}]},
    {"f": [{"v": "2"}, {"v": "Bob"}]}
  ],
  "jobComplete": true,
  "totalBytesProcessed": "1024"
}
```

### Jobs API

#### Create Job (Asynchronous)

Submit a job for asynchronous execution.

```bash
maton api -X POST '/google-bigquery/bigquery/v2/projects/{projectId}/jobs' -H 'Content-Type: application/json' --input - <<'JSON'
{
  "configuration": {
    "query": {
      "query": "SELECT * FROM `my_dataset.my_table`",
      "useLegacySql": false,
      "destinationTable": {
        "projectId": "{projectId}",
        "datasetId": "{datasetId}",
        "tableId": "results_table"
      },
      "writeDisposition": "WRITE_TRUNCATE"
    }
  }
}
JSON
```

**Note:** `{projectId}` and `{datasetId}` are placeholders. Replace each of them with real values before sending the request.

#### List Jobs

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/jobs'
```

**Note:** `{projectId}` is a placeholder. Replace it with a real value before sending the request.

**Query parameters:**
- `maxResults` - Maximum number of results to return
- `pageToken` - Token for pagination
- `stateFilter` - Filter by job state: `done`, `pending`, `running`
- `projection` - `full` or `minimal`

**Response:**
```json
{
  "kind": "bigquery#jobList",
  "jobs": [
    {
      "id": "my-project:US.job_abc123",
      "jobReference": {
        "projectId": "my-project",
        "jobId": "job_abc123",
        "location": "US"
      },
      "state": "DONE",
      "statistics": {
        "creationTime": "1771059781456",
        "startTime": "1771059782203",
        "endTime": "1771059782324"
      }
    }
  ]
}
```

#### Get Job

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/jobs/{jobId}'
```

**Note:** `{projectId}` and `{jobId}` are placeholders. Replace each of them with real values before sending the request.

**Query parameters:**
- `location` - Job location (e.g., "US", "EU")

#### Get Query Results

Retrieve results from a completed query job.

```bash
maton api '/google-bigquery/bigquery/v2/projects/{projectId}/queries/{jobId}'
```

**Note:** `{projectId}` and `{jobId}` are placeholders. Replace each of them with real values before sending the request.

**Query parameters:**
- `location` - Job location
- `maxResults` - Maximum results per page
- `pageToken` - Token for pagination
- `startIndex` - Zero-based starting row

#### Cancel Job

```bash
maton api -X POST '/google-bigquery/bigquery/v2/projects/{projectId}/jobs/{jobId}/cancel'
```

**Note:** `{projectId}` and `{jobId}` are placeholders. Replace each of them with real values before sending the request.

**Query parameters:**
- `location` - Job location

### Query Examples

#### Simple Query

```json
{
  "query": "SELECT 1 as test",
  "useLegacySql": false
}
```

#### Query with Parameters

```json
{
  "query": "SELECT * FROM `dataset.table` WHERE id = @id",
  "useLegacySql": false,
  "queryParameters": [
    {
      "name": "id",
      "parameterType": {"type": "INT64"},
      "parameterValue": {"value": "123"}
    }
  ]
}
```

#### Query to Destination Table

> **Caution:** `WRITE_TRUNCATE` overwrites the destination table entirely. Use `WRITE_APPEND` to add rows without destroying existing data. Confirm the disposition with the user before executing.

```json
{
  "query": "SELECT * FROM `source_dataset.source_table`",
  "useLegacySql": false,
  "destinationTable": {
    "projectId": "my-project",
    "datasetId": "dest_dataset",
    "tableId": "dest_table"
  },
  "writeDisposition": "WRITE_TRUNCATE"
}
```

### Common Schema Types

| Type | Description |
|------|-------------|
| `STRING` | Variable-length character data |
| `INTEGER` | 64-bit signed integer |
| `FLOAT` | 64-bit IEEE floating point |
| `BOOLEAN` | True or false |
| `TIMESTAMP` | Absolute point in time |
| `DATE` | Calendar date |
| `TIME` | Time of day |
| `DATETIME` | Date and time |
| `BYTES` | Variable-length binary data |
| `NUMERIC` | Exact numeric value with 38 digits of precision |
| `BIGNUMERIC` | Exact numeric value with 76+ digits of precision |
| `GEOGRAPHY` | Geographic data |
| `JSON` | JSON data |
| `RECORD` | Nested fields (also called STRUCT) |

**Field Modes:**
- `NULLABLE` - Field can be null (default)
- `REQUIRED` - Field cannot be null
- `REPEATED` - Field is an array

### Notes

- Project IDs are strings like `my-project-123`
- Dataset and table IDs: letters, numbers, underscores only
- Query results use `f` (fields) and `v` (value) structure
- Use `useLegacySql: false` for standard SQL
- Streaming inserts require BigQuery paid tier
- Jobs include location in their reference (US, EU, etc.)
- Use `maxResults` and `pageToken` for pagination

### Resources

- [BigQuery API Overview](https://cloud.google.com/bigquery/docs/reference/rest)
- [Datasets](https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets)
- [Tables](https://cloud.google.com/bigquery/docs/reference/rest/v2/tables)
- [Jobs](https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs)
- [Standard SQL Reference](https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax)
- [Maton CLI Manual](https://cli.maton.ai/manual)
canvas-designanthropics/skillsCreate beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
docxanthropics/skillsUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
pdfanthropics/skillsUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
pptxanthropics/skillsUse this skill any time a .pptx or .potx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx or .potx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates (.potx), layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx or .potx filename, regardless of what they plan to do with the content afterward. If a .pptx or .potx file needs to be opened, created, or touched, use this skill.Stars: 198kUpdated Claude CodeCodexVerifiedInstall