Hi - I answer from the OpenSmartRoute documentation: routing, the API, plans and quotas, self-hosting. Ask away, or open a support ticket if you need a person.
Grounded in the docs - follow a source before acting on it.
sql-source - Skill - OpenSmartRoute
Skillv1.0.0
sql-source
See CLAUDE.md "Critical Rules" for full SQL conventions.
Instruction file imported from stac-utils/pgstac (.github/instructions/sql-source.instructions.md). Copyright stays with the author.
SQL Source Files
See CLAUDE.md "Critical Rules" for full SQL conventions.
NEVER edit pgstac.sql — it is auto-generated
CREATE OR REPLACE FUNCTION, IF NOT EXISTS, SECURITY DEFINER
Grant permissions in 998_idempotent_post.sql, not inline
get_tstz_constraint() regex must handle fractional seconds (. in timestamps)
Do NOT schema-qualify PostGIS calls — PostGIS may be in public or postgis schema
SQL functions used by GENERATED columns must be self-contained (no cross-function deps) — pg_dump orders functions alphabetically and breaks dependency chains
Test: scripts/runinpypgstac --build test --pgtap --basicsql
Use it
Copy one of these into your project. Installing also returns the manifest and these snippets.
yaml
targets:
- https://api.opensmartroute.ai/api/v1/registry/stac-utils-pgstac-sql-source-instructions/manifest # or paste the manifest below
Manifest
An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.
