메뉴
Validate project environment health. Use before running pipelines, after setup, or when tools fail unexpectedly. Checks pixi, DuckDB, GDAL, gpio, extensions, state.sql, and cross-tool compatibility.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
GeoParquet optimization via gpio CLI (geoparquet-io). Use when creating, inspecting, validating, sorting, partitioning, or enriching GeoParquet files — even if the user just says "optimize this parquet" or "add spatial index". Covers Hilbert sorting, compression, bbox covering, STAC metadata, and cloud upload.
DuckDB v1.5 spatial/GIS analytics with ST_*, H3, A5, and S2/geography extensions. Use for SQL queries, file exploration, spatial analysis, discrete global grids, GeoParquet, ArcGIS REST, DuckLake, session state, docs search, or extension management, even without saying "DuckDB".
Build data processing pipelines using DuckDB, GDAL, and gpio as pixi tasks. Use when creating ETL workflows, multi-step data transformations, format conversions, or batch processing — even if the user just says "process this data" or "build a pipeline".
Geospatial data processing with the unified GDAL CLI (3.12+). Use when converting, inspecting, reprojecting, or processing raster/vector data — even if the user just says "convert this shapefile" or "what CRS is this file". Replaces legacy ogr2ogr/gdalinfo/ogrinfo.
| name | env-check |
| description | Validate project environment health. Use before running pipelines, after setup, or when tools fail unexpectedly. Checks pixi, DuckDB, GDAL, gpio, extensions, state.sql, and cross-tool compatibility. |
| allowed-tools | Bash, Read, Glob |
Run the validation script:
pixi run python -c "
import subprocess, sys
def run(cmd):
try:
r = subprocess.run(cmd, shell=True, capture_output=True, text=True, timeout=30)
return r.returncode == 0, r.stdout.strip().split('\n')[0] if r.stdout.strip() else ''
except Exception:
return False, ''
print('=' * 48)
print(' ai-data-registry — Environment Check')
print('=' * 48)
print()
checks = [
('pixi installed', 'pixi --version'),
('pixi.lock exists', 'test -f pixi.lock'),
('pixi.lock fresh', 'pixi run python -c \"import pathlib; exit(0 if pathlib.Path(\\\"pixi.lock\\\").stat().st_mtime >= pathlib.Path(\\\"pixi.toml\\\").stat().st_mtime else 1)\"'),
('DuckDB available', 'pixi run duckdb --version'),
('GDAL available', 'pixi run gdal --version'),
('gpio available', 'pixi run gpio --version'),
('GDAL Parquet driver', 'pixi run gdal vector info --formats 2>/dev/null | grep -qi parquet'),
('DuckDB spatial', 'pixi run duckdb -c \"INSTALL spatial; LOAD spatial; SELECT 1;\"'),
('DuckDB httpfs', 'pixi run duckdb -c \"INSTALL httpfs; LOAD httpfs; SELECT 1;\"'),
('DuckDB fts', 'pixi run duckdb -c \"INSTALL fts; LOAD fts; SELECT 1;\"'),
]
passed = failed = 0
for name, cmd in checks:
ok, out = run(cmd)
ver = f' ({out})' if ok and out else ''
print(f' {\"OK\" if ok else \"FAIL\":4s} {name}{ver}')
passed += ok
failed += (not ok)
# state.sql check
import pathlib
sf = pathlib.Path('.claude/skills/duckdb/references/state.sql')
if sf.exists():
ok, _ = run(f'pixi run duckdb -init {sf} -c \"SELECT 1;\"')
print(f' {\"OK\" if ok else \"FAIL\":4s} state.sql valid')
else:
print(f' {\"SKIP\":4s} state.sql (not created yet)')
print()
print(f' Results: {passed} passed, {failed} failed')
print('=' * 48)
"
If gpio fails: install with pixi add --pypi geoparquet-io
If extensions fail: run duckdb skill (install.md reference)
If state.sql invalid: re-initialize via duckdb skill (state.md reference)