Transforms raw data into compelling visual narratives using Python or R, focusing on clarity, insight, and aesthetic presentation.
Use when large data ingestion, backfill, export, ETL, warehouse loading, manifest catch-up, or table synchronization needs to become much…
Converts any local folder of mixed documents (docx, pdf, xlsx, duckdb, csv, images, text) into a Google Open Knowledge Format (OKF) v0.2…
Maps data transformation chains — Request DTO to Command to Entity to Response DTO.
Use when preparing the data, code, and transparency materials for a Social Forces (SF) manuscript.
Run declarative data quality checks and generate a codebook.
Patterns for visualizing data on maps including choropleth maps, heat maps, 3D visualizations, data-driven styling, and animated data.
Converts raw CSV, Excel, or JSON datasets into professional, interactive visual reports and KPI dashboards.
Generates OpenChart (https://github.com/tryopendata/openchart) chart, table, graph, sankey, tilemap, and geo map specs from data, and…
Architects complex database structures and manages data lifecycles through autonomous schema design and terminal-based execution.
Guides database schema design, migration planning, and query optimization using universal development standards.
Explore the PostgreSQL database schema, query data, generate Prisma migrations, and audit data integrity.
Detects missing database indexes in PHP code.
Master database schema and data migrations across ORMs (Sequelize, TypeORM, Prisma), including rollback strategies and zero-downtime…
Safe database migration manager for zero-downtime DDL changes and rollback plans.
Write a safe, zero-downtime database migration plan for a schema change.
Create and manage database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies.
Query optimization, indexing strategies, and database performance tuning for PostgreSQL and MySQL
Database design and migration patterns for Alembic migrations, schema design (SQL/NoSQL), and database versioning.
Database design patterns including schema design, migrations, soft deletes, and Exposed ORM.
Database access patterns for performance.