query_gsc_data
Analyze Google Search Console data by running SQL queries on synced search analytics to extract insights about queries, pages, and performance metrics.
Instructions
Run a read-only SQL query against a synced GSC property database. Supports any SELECT query. INSERT/UPDATE/DELETE/DROP/ALTER/CREATE are blocked. The table is "search_analytics" with columns: date, query, page, device, country, clicks, impressions, ctr, position. Requires synced data — run setup first if needed.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| siteUrl | Yes | GSC property URL. | |
| sql | Yes | SQL SELECT query to run against the search_analytics table. | |
| params | No | Optional parameterised query values. |