LeoYeAI/agent-master-skills / skills/api-gateway-1-0-46
api-gateway
VerifiedConnect to 100+ APIs (Google Workspace, Microsoft 365, Notion, Slack, Airtable, HubSpot, etc.) with managed OAuth. Use this skill when users want to interact with external services. Security: The MATON_API_KEY authenticates with Maton.ai but grants NO access to third-party services by itself. Each service requires explicit OAuth authorization by the user through Maton's connect flow. Access is strictly scoped to connections the user has authorized. Provided by Maton (https://maton.ai).
references/google-bigquery.md
View on GitHub# Google BigQuery Routing Reference
**App name:** `google-bigquery`
**Base URL proxied:** `bigquery.googleapis.com`
## API Path Pattern
```
/google-bigquery/bigquery/v2/{resource}
```
## Common Endpoints
### List Projects
```bash
GET /google-bigquery/bigquery/v2/projects
```
### List Datasets
```bash
GET /google-bigquery/bigquery/v2/projects/{projectId}/datasets
```
### Get Dataset
```bash
GET /google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}
```
### Create Dataset
```bash
POST /google-bigquery/bigquery/v2/projects/{projectId}/datasets
Content-Type: application/json
{
"datasetReference": {
"datasetId": "my_dataset",
"projectId": "{projectId}"
},
"location": "US"
}
```
### Delete Dataset
```bash
DELETE /google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}
```
### List Tables
```bash
GET /google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables
```
### Get Table
```bash
GET /google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
```
### Create Table
```bash
POST /google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables
Content-Type: application/json
{
"tableReference": {
"projectId": "{projectId}",
"datasetId": "{datasetId}",
"tableId": "my_table"
},
"schema": {
"fields": [
{"name": "id", "type": "INTEGER"},
{"name": "name", "type": "STRING"}
]
}
}
```
### Delete Table
```bash
DELETE /google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
```
### List Table Data
```bash
GET /google-bigquery/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data
```
### Run Query (Synchronous)
```bash
POST /google-bigquery/bigquery/v2/projects/{projectId}/queries
Content-Type: application/json
{
"query": "SELECT * FROM `dataset.table` LIMIT 10",
"useLegacySql": false
}
```
### List Jobs
```bash
GET /google-bigquery/bigquery/v2/projects/{projectId}/jobs
```
### Get Job
```bash
GET /google-bigquery/bigquery/v2/projects/{projectId}/jobs/{jobId}?location=US
```
### Cancel Job
```bash
POST /google-bigquery/bigquery/v2/projects/{projectId}/jobs/{jobId}/cancel?location=US
```
## 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
```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
- `STRING` - Text data
- `INTEGER` - 64-bit signed integer
- `FLOAT` - 64-bit floating point
- `BOOLEAN` - True/false
- `TIMESTAMP` - Point in time
- `DATE` - Calendar date
- `RECORD` - Nested structure
## Notes
- Authentication is automatic - the router injects the OAuth token
- 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)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |