python-fastapi-programmer:fastapi-postgis

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/ureca-corp-python-fastapi-programmer-fastapi-postgis

About

Use cases: backend

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools

No tools found

Secrets

None asked for

Install scripts

None found

What's inside

Skill name

python-fastapi-programmer:fastapi-postgis

Description

PostGIS location storage patterns for FastAPI with SQLModel. Use when implementing location features requiring latitude/longitude storage, spatial indexing, or distance calculations. Stores both latlng (client response) and PostGIS POINT geometry (spatial queries).

License

MIT

Instructions

35 lines in SKILL.md · view on GitHub

# FastAPI PostGIS Patterns

## Storage Strategy

Store BOTH formats:
1. **latlng**: latitude, longitude columns (client response)
2. **PostGIS POINT**: geometry column (spatial indexing, distance queries)

## Pattern

See [postgis-storage.md](references/postgis-storage.md) for complete implementation.

## Quick Example

```python
from geoalchemy2 import Geometry
from geoalchemy2.elements import WKTElement

class Location(SQLModel, table=True):
    latitude: float
    longitude: float
    location: Geometry = Field(sa_column=Column(Geometry("POINT", srid=4326)))

# Store
point = WKTElement(f"POINT({lng} {lat})", srid=4326)
loc = Location(latitude=lat, longitude=lng, location=point)
db.add(loc)

# Distance query
query = select(Location).where(
    func.ST_DWithin(Location.location, point, radius_meters)
)
```

Signals

Stars

0

Forks

0

Open issues

0

Last commit (this folder)

Feb 20, 2026 (8 months ago)

From GitHub (fetched Oct 24, 2026).

Details

License

MIT

Repository

github.com/ureca-corp/claude

First seen

Oct 24, 2026

Last checked

Oct 24, 2026

Source

GitHubgithub-graphql