Leaderboard/Databases/geosql
Last commit on August 31, 2026·Created on April 2, 2026

dekart-xyz/geosql

Translates geospatial requirements into cost-safe SQL across multiple data warehouses
Combined rank
#451
across all skills
In Databases
#4
category rank
Stars
656
+1.2% in last 7d
Forks
61
+3.4% in last 7d
Watchers
3
0.0% in last 7d
Traction scoreGitHub stars can be faked, so popularity alone can be misleading. Traction Score looks for broader signs of recent attention, adoption, and active maintenance.
TL;DR

GeoSQL assists GIS analysts in writing and executing geospatial queries for BigQuery, DuckDB, Snowflake, Wherobots, and Postgres. It streamlines the process of managing spatial data across different dialects while ensuring queries remain cost-efficient.

The skill integrates with the Dekart CLI to render query results directly onto interactive maps, bridging the gap between database execution and visual spatial analysis.

WHO IT'S FOR
GIS Analysts
writing cost-safe geospatial SQL queries
Data Engineers
managing geospatial data across multiple warehouses
Spatial Data Scientists
exploring geospatial schemas and rendering maps
Analytics Engineers
optimizing geospatial query costs in cloud warehouses
Repository contents

1 skill file

Compatible AgentsThe repository documents support for these agents. The skills may also work with other agents that can load SKILL.md files, but they may need some setup or small changes.

Use this skill

Follow the documented setup, then try a first task.

I’m using

Python interactive installer

Installs: GeoSQL skill · Claude Code, Codex, GitHub Copilot, OpenCode, Mistral Vibe

Before you start
  • Python with pip available
  1. In a terminal, install GeoSQL and start its interactive installer. It detects the agent, installs the skill, checks the optional Dekart CLI, and asks before installing or initializing that CLI when needed.

    pip install geosql && geosql
README.md · Checked Sep 18, 2026skills/geosql/SKILL.md · Checked Sep 18, 2026

Give it something to do.

Author’s example

Map EV charger density along major roads

Uses geosql

  • Access to relevant EV-charger and Romanian road data through a supported warehouse
  • An available and initialized Dekart CLI for interactive map rendering
/geosql create map EV charger density along major Romanian roads, highlighting how many charging stations are within 5 km of each motorway, trunk, or primary road segment.
README.md · Checked Sep 18, 2026skills/geosql/SKILL.md · Checked Sep 18, 2026
Author’s example

Map buildings with low school accessibility

Uses geosql

  • Access to relevant Ottawa building and school data through a supported warehouse
  • An available and initialized Dekart CLI for interactive map rendering
/geosql Show buildings with low school accessibility in Ottawa, render as a map
README.md · Checked Sep 18, 2026skills/geosql/SKILL.md · Checked Sep 18, 2026
Author’s example

Find sporting-goods store locations

Uses geosql

  • Access to relevant Seattle POI and competitor-location data through a supported warehouse
  • An available and initialized Dekart CLI for interactive map rendering
/geosql Find the top 10 locations for Sporting Goods Store in Seattle based on POI co-location and distance to the nearest competitor. Create a map.
README.md · Checked Sep 18, 2026skills/geosql/SKILL.md · Checked Sep 18, 2026