Menu
MongoDB database exploration for understanding game data, debugging, and investigation. Auto-applies when discussing database structure or debugging data issues.
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.
Animate 3D objects and characters in Blender with Python. Use when the user wants to keyframe properties, create armatures and rigs, set up IK/FK chains, animate shape keys for facial animation, edit F-Curves, use the NLA editor to blend actions, add drivers for expression-based animation, or script any animation workflow in Blender.
Create 3D models procedurally with Blender Python. Use when the user wants to generate meshes from code, build geometry with bmesh, apply modifiers, create parametric shapes, procedural landscapes, grids, curves, or any programmatic 3D modeling in Blender.
Automate Blender compositing and post-processing with Python. Use when the user wants to set up compositor nodes, add post-processing effects, color correct renders, combine render passes, apply blur or glare, key green screens, create node-based VFX pipelines, or script the Blender compositor.
Automate Blender rendering from the command line. Use when the user wants to set up renders, batch render scenes, configure Cycles or EEVEE, set up cameras and lights, render animations, create materials and shaders, or build a render pipeline with Blender Python scripting.
Write and run Blender Python scripts for 3D automation. Use when the user wants to automate Blender tasks, run headless scripts, manipulate scenes, batch process .blend files, import/export 3D models, manage objects, or script Blender from the command line using the bpy API.
OpenCivilizations project architecture, patterns, and conventions. Auto-applies for implementation tasks to ensure consistency.
Based on SOC occupation classification
| name | db-explore |
| description | MongoDB database exploration for understanding game data, debugging, and investigation. Auto-applies when discussing database structure or debugging data issues. |
| allowed-tools | Bash, Read |
MongoDB exploration for OpenCivilizations game.
| Collection | Purpose |
|---|---|
| users | Player accounts and authentication |
| bases | Player base layouts and buildings |
| clans | Alliance/clan data |
| battles | Battle replays and results |
| leaderboards | Rankings cache |
mongosh "mongodb://localhost:27017/dominations"
db.getCollectionNames()
// Get sample user
db.users.findOne()
// Get sample base with buildings
db.bases.findOne({}, { buildings: { $slice: 5 } })
// Get recent battles
db.battles.find().sort({ createdAt: -1 }).limit(5)
// Total users
db.users.countDocuments()
// Active players (last 7 days)
db.users.countDocuments({ lastLogin: { $gte: new Date(Date.now() - 7*24*60*60*1000) } })
// Find user by name
db.users.findOne({ username: "player1" })
// Find bases with specific building
db.bases.find({ "buildings.type": "townCenter" })
// Find clan members
db.clans.findOne({ name: "Warriors" }, { members: 1 })
// Count buildings by type across all bases
db.bases.aggregate([
{ $unwind: "$buildings" },
{ $group: { _id: "$buildings.type", count: { $sum: 1 } } },
{ $sort: { count: -1 } }
])
// Average resources per player
db.users.aggregate([
{ $group: {
_id: null,
avgGold: { $avg: "$resources.gold" },
avgFood: { $avg: "$resources.food" }
}}
])
// Get player with full base
db.users.aggregate([
{ $match: { username: "player1" } },
{ $lookup: {
from: "bases",
localField: "_id",
foreignField: "userId",
as: "base"
}}
])
// Get battle with attacker and defender info
db.battles.aggregate([
{ $match: { _id: ObjectId("...") } },
{ $lookup: { from: "users", localField: "attackerId", foreignField: "_id", as: "attacker" } },
{ $lookup: { from: "users", localField: "defenderId", foreignField: "_id", as: "defender" } }
])
// Top 10 by trophies
db.users.find({}, { username: 1, trophies: 1 })
.sort({ trophies: -1 })
.limit(10)
.limit()