Collaboration Interest: AI Guidance for PostGIS in pg-aiguide

[Mat Arye]

Hi All,

We've started a new open-source project at Tiger Data aimed at helping AI
agents generate higher-quality Postgres code:
https://github.com/timescale/pg-aiguide
For broader context, here’s the announcement blog describing the approach
and motivations:
https://www.tigerdata.com/blog/we-taught-ai-to-write-real-postgres-code-open-sourced-it

As part of this work, we're adding guidance modules for major Postgres
extensions, and PostGIS is at the top of our list. I’m reaching out to ask
whether anyone from the PostGIS community would be interested in
collaborating.

The core idea is to provide “skills” that capture best practices, common
pitfalls, and domain-specific patterns so that AI agents can make better
decisions. Here is an example skill:
https://github.com/timescale/pg-aiguide/blob/main/skills/design-postgres-tables/SKILL.md

If there’s interest, we’d be happy to set up a call to walk through the
approach and answer questions.

Beyond skills, the project also includes semantic search over
documentation. We currently index Postgres and TimescaleDB docs, and we
plan to include the PostGIS manual as well. We can handle the processing,
but wanted to check whether there’s anything unusual about the HTML manual
that we should be aware of. We’d also appreciate any guidance on which
versions of the manual are most important to index.

Thanks for your time, and we’d welcome any feedback or involvement from the
community.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20251125/12563205/attachment.htm>