naftiko: 1.0.0-alpha2 info: label: Google BigQuery API description: The BigQuery API provides programmatic access to Google BigQuery for creating, managing, and querying datasets, tables, jobs, models, and routines. It enables developers to run SQL queries over petabytes of data, load and export data, manage access control, and orchestrate analytics workloads using serverless infrastructure. tags: - Google - Bigquery - API created: '2026-05-06' modified: '2026-05-06' capability: consumes: - type: http namespace: google-bigquery baseUri: https://bigquery.googleapis.com/bigquery/v2 description: Google BigQuery API HTTP API. authentication: type: bearer token: '{{GOOGLE_BIGQUERY_TOKEN}}' resources: - name: projects path: /projects operations: - name: listprojects method: GET description: Google BigQuery List projects outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets path: /projects/{projectId}/datasets operations: - name: listdatasets method: GET description: Google BigQuery List datasets inputParameters: - name: all in: query type: boolean description: Whether to list all datasets, including hidden ones - name: filter in: query type: string description: Filter expression for filtering datasets by label outputRawFormat: json outputParameters: - name: result type: object value: $. - name: insertdataset method: POST description: Google BigQuery Create a dataset outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid path: /projects/{projectId}/datasets/{datasetId} operations: - name: getdataset method: GET description: Google BigQuery Get dataset outputRawFormat: json outputParameters: - name: result type: object value: $. - name: patchdataset method: PATCH description: Google BigQuery Partially update dataset outputRawFormat: json outputParameters: - name: result type: object value: $. - name: updatedataset method: PUT description: Google BigQuery Update dataset outputRawFormat: json outputParameters: - name: result type: object value: $. - name: deletedataset method: DELETE description: Google BigQuery Delete dataset inputParameters: - name: deleteContents in: query type: boolean description: If true, delete all the tables in the dataset outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-tables path: /projects/{projectId}/datasets/{datasetId}/tables operations: - name: listtables method: GET description: Google BigQuery List tables outputRawFormat: json outputParameters: - name: result type: object value: $. - name: inserttable method: POST description: Google BigQuery Create a table outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-tables-tab path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId} operations: - name: gettable method: GET description: Google BigQuery Get table outputRawFormat: json outputParameters: - name: result type: object value: $. - name: patchtable method: PATCH description: Google BigQuery Partially update table outputRawFormat: json outputParameters: - name: result type: object value: $. - name: deletetable method: DELETE description: Google BigQuery Delete table outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-tables-tab path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data operations: - name: listtabledata method: GET description: Google BigQuery List table rows inputParameters: - name: startIndex in: query type: integer description: Zero-based index of the starting row to read outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-tables-tab path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll operations: - name: insertalltabledata method: POST description: Google BigQuery Insert rows outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-jobs path: /projects/{projectId}/jobs operations: - name: listjobs method: GET description: Google BigQuery List jobs inputParameters: - name: projection in: query type: string description: Restricts information returned to a set of selected fields - name: stateFilter in: query type: array description: Filter for job state outputRawFormat: json outputParameters: - name: result type: object value: $. - name: insertjob method: POST description: Google BigQuery Submit a job outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-jobs-jobid path: /projects/{projectId}/jobs/{jobId} operations: - name: getjob method: GET description: Google BigQuery Get job outputRawFormat: json outputParameters: - name: result type: object value: $. - name: deletejob method: DELETE description: Google BigQuery Delete job outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-jobs-jobid-cancel path: /projects/{projectId}/jobs/{jobId}/cancel operations: - name: canceljob method: POST description: Google BigQuery Cancel job outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-queries path: /projects/{projectId}/queries operations: - name: queryjobs method: POST description: Google BigQuery Execute query outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-queries-jobid path: /projects/{projectId}/queries/{jobId} operations: - name: getqueryresults method: GET description: Google BigQuery Get query results inputParameters: - name: startIndex in: query type: integer description: Zero-based index of the starting row outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-models path: /projects/{projectId}/datasets/{datasetId}/models operations: - name: listmodels method: GET description: Google BigQuery List models outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-models-mod path: /projects/{projectId}/datasets/{datasetId}/models/{modelId} operations: - name: getmodel method: GET description: Google BigQuery Get model inputParameters: - name: modelId in: path type: string required: true description: The ID of the model outputRawFormat: json outputParameters: - name: result type: object value: $. - name: patchmodel method: PATCH description: Google BigQuery Update model inputParameters: - name: modelId in: path type: string required: true description: The ID of the model outputRawFormat: json outputParameters: - name: result type: object value: $. - name: deletemodel method: DELETE description: Google BigQuery Delete model inputParameters: - name: modelId in: path type: string required: true description: The ID of the model outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-routines path: /projects/{projectId}/datasets/{datasetId}/routines operations: - name: listroutines method: GET description: Google BigQuery List routines outputRawFormat: json outputParameters: - name: result type: object value: $. - name: insertroutine method: POST description: Google BigQuery Create a routine outputRawFormat: json outputParameters: - name: result type: object value: $. - name: projects-projectid-datasets-datasetid-routines-r path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId} operations: - name: getroutine method: GET description: Google BigQuery Get routine inputParameters: - name: routineId in: path type: string required: true description: The ID of the routine outputRawFormat: json outputParameters: - name: result type: object value: $. - name: updateroutine method: PUT description: Google BigQuery Update routine inputParameters: - name: routineId in: path type: string required: true description: The ID of the routine outputRawFormat: json outputParameters: - name: result type: object value: $. - name: deleteroutine method: DELETE description: Google BigQuery Delete routine inputParameters: - name: routineId in: path type: string required: true description: The ID of the routine outputRawFormat: json outputParameters: - name: result type: object value: $. exposes: - type: rest port: 8080 namespace: google-bigquery-rest description: REST adapter for Google BigQuery API. resources: - path: /projects name: listprojects operations: - method: GET name: listprojects description: Google BigQuery List projects call: google-bigquery.listprojects outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets name: listdatasets operations: - method: GET name: listdatasets description: Google BigQuery List datasets call: google-bigquery.listdatasets outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets name: insertdataset operations: - method: POST name: insertdataset description: Google BigQuery Create a dataset call: google-bigquery.insertdataset outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId} name: getdataset operations: - method: GET name: getdataset description: Google BigQuery Get dataset call: google-bigquery.getdataset outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId} name: patchdataset operations: - method: PATCH name: patchdataset description: Google BigQuery Partially update dataset call: google-bigquery.patchdataset outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId} name: updatedataset operations: - method: PUT name: updatedataset description: Google BigQuery Update dataset call: google-bigquery.updatedataset outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId} name: deletedataset operations: - method: DELETE name: deletedataset description: Google BigQuery Delete dataset call: google-bigquery.deletedataset outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/tables name: listtables operations: - method: GET name: listtables description: Google BigQuery List tables call: google-bigquery.listtables outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/tables name: inserttable operations: - method: POST name: inserttable description: Google BigQuery Create a table call: google-bigquery.inserttable outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId} name: gettable operations: - method: GET name: gettable description: Google BigQuery Get table call: google-bigquery.gettable outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId} name: patchtable operations: - method: PATCH name: patchtable description: Google BigQuery Partially update table call: google-bigquery.patchtable outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId} name: deletetable operations: - method: DELETE name: deletetable description: Google BigQuery Delete table call: google-bigquery.deletetable outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data name: listtabledata operations: - method: GET name: listtabledata description: Google BigQuery List table rows call: google-bigquery.listtabledata outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll name: insertalltabledata operations: - method: POST name: insertalltabledata description: Google BigQuery Insert rows call: google-bigquery.insertalltabledata outputParameters: - type: object mapping: $. - path: /projects/{projectId}/jobs name: listjobs operations: - method: GET name: listjobs description: Google BigQuery List jobs call: google-bigquery.listjobs outputParameters: - type: object mapping: $. - path: /projects/{projectId}/jobs name: insertjob operations: - method: POST name: insertjob description: Google BigQuery Submit a job call: google-bigquery.insertjob outputParameters: - type: object mapping: $. - path: /projects/{projectId}/jobs/{jobId} name: getjob operations: - method: GET name: getjob description: Google BigQuery Get job call: google-bigquery.getjob outputParameters: - type: object mapping: $. - path: /projects/{projectId}/jobs/{jobId} name: deletejob operations: - method: DELETE name: deletejob description: Google BigQuery Delete job call: google-bigquery.deletejob outputParameters: - type: object mapping: $. - path: /projects/{projectId}/jobs/{jobId}/cancel name: canceljob operations: - method: POST name: canceljob description: Google BigQuery Cancel job call: google-bigquery.canceljob outputParameters: - type: object mapping: $. - path: /projects/{projectId}/queries name: queryjobs operations: - method: POST name: queryjobs description: Google BigQuery Execute query call: google-bigquery.queryjobs outputParameters: - type: object mapping: $. - path: /projects/{projectId}/queries/{jobId} name: getqueryresults operations: - method: GET name: getqueryresults description: Google BigQuery Get query results call: google-bigquery.getqueryresults outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/models name: listmodels operations: - method: GET name: listmodels description: Google BigQuery List models call: google-bigquery.listmodels outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/models/{modelId} name: getmodel operations: - method: GET name: getmodel description: Google BigQuery Get model call: google-bigquery.getmodel with: modelId: rest.modelId outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/models/{modelId} name: patchmodel operations: - method: PATCH name: patchmodel description: Google BigQuery Update model call: google-bigquery.patchmodel with: modelId: rest.modelId outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/models/{modelId} name: deletemodel operations: - method: DELETE name: deletemodel description: Google BigQuery Delete model call: google-bigquery.deletemodel with: modelId: rest.modelId outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/routines name: listroutines operations: - method: GET name: listroutines description: Google BigQuery List routines call: google-bigquery.listroutines outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/routines name: insertroutine operations: - method: POST name: insertroutine description: Google BigQuery Create a routine call: google-bigquery.insertroutine outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId} name: getroutine operations: - method: GET name: getroutine description: Google BigQuery Get routine call: google-bigquery.getroutine with: routineId: rest.routineId outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId} name: updateroutine operations: - method: PUT name: updateroutine description: Google BigQuery Update routine call: google-bigquery.updateroutine with: routineId: rest.routineId outputParameters: - type: object mapping: $. - path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId} name: deleteroutine operations: - method: DELETE name: deleteroutine description: Google BigQuery Delete routine call: google-bigquery.deleteroutine with: routineId: rest.routineId outputParameters: - type: object mapping: $. - type: mcp port: 9090 namespace: google-bigquery-mcp transport: http description: MCP adapter for Google BigQuery API for AI agent use. tools: - name: listprojects description: Google BigQuery List projects hints: readOnly: true destructive: false idempotent: true call: google-bigquery.listprojects outputParameters: - type: object mapping: $. - name: listdatasets description: Google BigQuery List datasets hints: readOnly: true destructive: false idempotent: true call: google-bigquery.listdatasets with: all: tools.all filter: tools.filter inputParameters: - name: all type: boolean description: Whether to list all datasets, including hidden ones - name: filter type: string description: Filter expression for filtering datasets by label outputParameters: - type: object mapping: $. - name: insertdataset description: Google BigQuery Create a dataset hints: readOnly: false destructive: false idempotent: false call: google-bigquery.insertdataset outputParameters: - type: object mapping: $. - name: getdataset description: Google BigQuery Get dataset hints: readOnly: true destructive: false idempotent: true call: google-bigquery.getdataset outputParameters: - type: object mapping: $. - name: patchdataset description: Google BigQuery Partially update dataset hints: readOnly: false destructive: false idempotent: false call: google-bigquery.patchdataset outputParameters: - type: object mapping: $. - name: updatedataset description: Google BigQuery Update dataset hints: readOnly: false destructive: false idempotent: true call: google-bigquery.updatedataset outputParameters: - type: object mapping: $. - name: deletedataset description: Google BigQuery Delete dataset hints: readOnly: false destructive: true idempotent: true call: google-bigquery.deletedataset with: deleteContents: tools.deleteContents inputParameters: - name: deleteContents type: boolean description: If true, delete all the tables in the dataset outputParameters: - type: object mapping: $. - name: listtables description: Google BigQuery List tables hints: readOnly: true destructive: false idempotent: true call: google-bigquery.listtables outputParameters: - type: object mapping: $. - name: inserttable description: Google BigQuery Create a table hints: readOnly: false destructive: false idempotent: false call: google-bigquery.inserttable outputParameters: - type: object mapping: $. - name: gettable description: Google BigQuery Get table hints: readOnly: true destructive: false idempotent: true call: google-bigquery.gettable outputParameters: - type: object mapping: $. - name: patchtable description: Google BigQuery Partially update table hints: readOnly: false destructive: false idempotent: false call: google-bigquery.patchtable outputParameters: - type: object mapping: $. - name: deletetable description: Google BigQuery Delete table hints: readOnly: false destructive: true idempotent: true call: google-bigquery.deletetable outputParameters: - type: object mapping: $. - name: listtabledata description: Google BigQuery List table rows hints: readOnly: true destructive: false idempotent: true call: google-bigquery.listtabledata with: startIndex: tools.startIndex inputParameters: - name: startIndex type: integer description: Zero-based index of the starting row to read outputParameters: - type: object mapping: $. - name: insertalltabledata description: Google BigQuery Insert rows hints: readOnly: false destructive: false idempotent: false call: google-bigquery.insertalltabledata outputParameters: - type: object mapping: $. - name: listjobs description: Google BigQuery List jobs hints: readOnly: true destructive: false idempotent: true call: google-bigquery.listjobs with: projection: tools.projection stateFilter: tools.stateFilter inputParameters: - name: projection type: string description: Restricts information returned to a set of selected fields - name: stateFilter type: array description: Filter for job state outputParameters: - type: object mapping: $. - name: insertjob description: Google BigQuery Submit a job hints: readOnly: false destructive: false idempotent: false call: google-bigquery.insertjob outputParameters: - type: object mapping: $. - name: getjob description: Google BigQuery Get job hints: readOnly: true destructive: false idempotent: true call: google-bigquery.getjob outputParameters: - type: object mapping: $. - name: deletejob description: Google BigQuery Delete job hints: readOnly: false destructive: true idempotent: true call: google-bigquery.deletejob outputParameters: - type: object mapping: $. - name: canceljob description: Google BigQuery Cancel job hints: readOnly: false destructive: false idempotent: false call: google-bigquery.canceljob outputParameters: - type: object mapping: $. - name: queryjobs description: Google BigQuery Execute query hints: readOnly: false destructive: false idempotent: false call: google-bigquery.queryjobs outputParameters: - type: object mapping: $. - name: getqueryresults description: Google BigQuery Get query results hints: readOnly: true destructive: false idempotent: true call: google-bigquery.getqueryresults with: startIndex: tools.startIndex inputParameters: - name: startIndex type: integer description: Zero-based index of the starting row outputParameters: - type: object mapping: $. - name: listmodels description: Google BigQuery List models hints: readOnly: true destructive: false idempotent: true call: google-bigquery.listmodels outputParameters: - type: object mapping: $. - name: getmodel description: Google BigQuery Get model hints: readOnly: true destructive: false idempotent: true call: google-bigquery.getmodel with: modelId: tools.modelId inputParameters: - name: modelId type: string description: The ID of the model required: true outputParameters: - type: object mapping: $. - name: patchmodel description: Google BigQuery Update model hints: readOnly: false destructive: false idempotent: false call: google-bigquery.patchmodel with: modelId: tools.modelId inputParameters: - name: modelId type: string description: The ID of the model required: true outputParameters: - type: object mapping: $. - name: deletemodel description: Google BigQuery Delete model hints: readOnly: false destructive: true idempotent: true call: google-bigquery.deletemodel with: modelId: tools.modelId inputParameters: - name: modelId type: string description: The ID of the model required: true outputParameters: - type: object mapping: $. - name: listroutines description: Google BigQuery List routines hints: readOnly: true destructive: false idempotent: true call: google-bigquery.listroutines outputParameters: - type: object mapping: $. - name: insertroutine description: Google BigQuery Create a routine hints: readOnly: false destructive: false idempotent: false call: google-bigquery.insertroutine outputParameters: - type: object mapping: $. - name: getroutine description: Google BigQuery Get routine hints: readOnly: true destructive: false idempotent: true call: google-bigquery.getroutine with: routineId: tools.routineId inputParameters: - name: routineId type: string description: The ID of the routine required: true outputParameters: - type: object mapping: $. - name: updateroutine description: Google BigQuery Update routine hints: readOnly: false destructive: false idempotent: true call: google-bigquery.updateroutine with: routineId: tools.routineId inputParameters: - name: routineId type: string description: The ID of the routine required: true outputParameters: - type: object mapping: $. - name: deleteroutine description: Google BigQuery Delete routine hints: readOnly: false destructive: true idempotent: true call: google-bigquery.deleteroutine with: routineId: tools.routineId inputParameters: - name: routineId type: string description: The ID of the routine required: true outputParameters: - type: object mapping: $. binds: - namespace: env keys: GOOGLE_BIGQUERY_TOKEN: GOOGLE_BIGQUERY_TOKEN