# GeoSQL

Claude, Codex, and GitHub Copilot skill for data scientists and analysts working with geospatial data on PostGIS, BigQuery, Snowflake, and Wherobots.

> Note: No SaaS account needed. Works 100% locally or self-hosted.


> 4x improvement on geospatial tasks with map in the loop.


## Quick Start

With Python (interactive mode):

```bash pip install geosql && geosql ```

Install directly into a supported agent:

```bash geosql install claude geosql install codex geosql install copilot ```

Or in Claude Code:

``` /plugin marketplace add dekart-xyz/geosql /plugin install geosql ```

After `geosql install copilot`, use GeoSQL from VS Code Copilot or Copilot CLI with prompts such as:

``` /geosql Show EV charger density along major roads and render a map ```

### Install Dekart for map rendering and PostGIS support

GeoSQL optionally uses [Dekart](https://github.com/dekart-xyz/dekart): an open-source Kepler.gl backend with connectors for PostGIS, BigQuery, and Snowflake. You can run Dekart locally with one docker command, [self-host](https://dekart.xyz/docs/self-hosting/docker/) it on your own infrastructure, or use Dekart Cloud.

Run Dekart locally (skip this step to use [Dekart Cloud](https://cloud.dekart.xyz?ref=geosql-github)): ```bash docker run -p 8080:8080 dekartxyz/dekart ```

Install the Dekart CLI: ``` pip install dekart && dekart init ``` Follow CLI and dekart prompts to connect your PostGIS, BigQuery, Snowflake or Wherobots database.

## Example prompts to try in your agent:

Real estate analysis: ``` /geosql Show buildings with low school accessibility in Ottawa, render as a map ``` Site selection: ``` /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. ``` EV charging infrastructure: ``` /geosql create map EV charger density along major Romania