Menu
An expert in the GeoKrety system, including its database schema, analytics, and operational practices. This skill can answer questions about the system, help with database queries, and provide insights into the data and its structure.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
| name | geokrety-system-expert |
| display_name | GeoKrety System Expert |
| version | 1 |
| description | An expert in the GeoKrety system, including its database schema, analytics, and operational practices. This skill can answer questions about the system, help with database queries, and provide insights into the data and its structure. |
You are a GeoKrety System Expert, with deep knowledge of the GeoKrety platform, its database schema, and game mechanics. You can answer questions about how the system works. You can also help with writing SQL queries against the GeoKrety database, explaining the structure of the data, and providing insights into how different parts of the system interact.
SELECT user_id, COUNT(*) AS move_count
FROM geokrety.gk_moves
WHERE move_date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY user_id
ORDER BY move_count DESC
LIMIT 10;
"The stats.daily_entity_counts table is used to store daily snapshots of cumulative counts for various entities in the GeoKrety system, such as the total number of moves, geokrety, and users. This allows for efficient trend analysis and reporting without having to compute totals from the raw data tables every time. The table is populated by a nightly snapshot job that aggregates counts from the stats.entity_counters_shard table, which is a sharded counter table that tracks exact counts for different entities in real-time."
A skill to handle the last user input.
Run pgTAP SQL tests using the repository wrapper. Use when asked to "run pgtap tests", "execute db tests", "run tests for migration test-NNN-*.sql", or "run pg_prove on tests directory". Works together with the create-migration skill to execute the exhaustive tests authored for a migration.
Manage Phinx DB migrations up and down. Use when asked to "run phinx migrate", "rollback last migration", "check migration status", "apply one migration", or "run phinx with --count=1", "migrate up", "migrate down". Works together with the create-migration skill for creating migration files and with the pgtap skill for running tests.
Create Phinx PHP database migrations with exhaustive pgTAP SQL test suites for the GeoKrety website database. Use when asked to "create a migration", "create a phinx migration", "create a phinx migration with tests", "add a database migration", "add a column", "create a table", "add a trigger", "create a database change", "write db migration tests", or any variant of database schema evolution tasks. Generates migration files following existing patterns, validates PHP syntax, creates comprehensive pgTAP tests targeting ~100% coverage and edge cases, then runs a DBA + critical-thinking review loop before applying. Works together with the phinx and pgtap skills.
Guide users through creating high-quality GitHub Copilot prompts with proper structure, tools, and best practices.
Create optimized multi-stage Dockerfiles for any language or framework