1.7K skills ・ Works with: PostgreSQL · sorted by popularity
Design and review Java database code using MyBatis and MyBatis-Spring. Covers mapping query results to objects, safe SQL parameters, transactions, pagination, batch writes, and investigating slow or unnecessarily repeated queries.
Build Bengali search and AI features with guidance on consistent character encoding, word splitting, digit conversion, and safe text display. Includes patterns for cleaning training data, storing text, and handling Bengali alongside English.
Plan database structure changes and existing data updates for production systems. Provides migration patterns for adding columns and indexes, switching applications in stages, and documenting recovery steps while accounting for downtime and database locks.
Deploy and manage services across an Uncloud cluster using the uc command line. Covers public ports, Caddy routing for incoming traffic, service scaling, log inspection, and management of machines and storage volumes.
Verify Spring Boot changes through builds, static analysis that checks code without running it, tests, coverage checks, and security scans. Review the diff and produce a pass/fail report showing readiness and issues to fix.
Review authentication, payments, and APIs for security risks using implementation examples and a predeployment checklist. Covers input validation, access permissions, secret storage, request limits, and checks for sensitive information in logs and errors.
Turn a draft request into a ready-to-paste prompt by clarifying intent, missing context, and completion criteria. Recommend suitable ECC commands, skills, and agents, then provide full and compact versions with explanations for the changes.
Design and review Prisma database code for TypeScript backends. Use examples for schemas, queries, transactions, pagination, migrations, and connection management to identify common pitfalls in bulk operations and serverless deployments.
Guide PostgreSQL database design and troubleshooting with examples for faster queries, indexes that speed up searches, suitable data types, and row-level access rules. Also covers connection settings and SQL for investigating performance problems.
Build and review Python tests with pytest. Use reusable setup, simulated external services, and multiple input cases to check behavior, then measure coverage—the proportion of code exercised by tests—and follow a test-first development cycle.
Review MySQL and MariaDB database designs and production problems, including slow queries, locking, connection pools, and replica delays. Get concrete SQL or code changes and a validation plan that accounts for differences between engines and versions.
Plan and review machine learning systems for production use, covering data requirements, repeatable training, quality checks, deployment, monitoring, and rollback. Produce concrete plans and review findings for moving model experiments into operational systems.
Build Kotlin database access with JetBrains Exposed, a library that maps database records to code. Apply examples for queries, transactions, reusable connections, schema migrations, and repository interfaces that separate database operations from business logic.
Set up reproducible development environments with Flox on macOS and Linux. Define tools, package versions, setup steps, and local services in one configuration, then share it with teammates or add project-specific tools for AI agents.
Plan database schema and data changes for production systems. Use staged column replacements, concurrent index creation, and batched data updates to limit disruption, with migration workflows for PostgreSQL, Prisma, Drizzle, Kysely, Django, and golang-migrate.
Create and review Docker development environments, including service networking, persistent storage, and security settings. Also guides isolated testing of command-line installers on Linux, while identifying checks that require native macOS or Windows environments.
Write and review C# and .NET tests using xUnit examples. Covers unit tests, mocks that replace dependencies, API and database integration tests, reusable test data, and project organization to check behavior and outcomes.
Check a Django application before a pull request or deployment. Review its environment, code quality, database changes, tests, vulnerabilities, and configuration, then produce a phased pass/fail report identifying issues that need fixes.
Record software design decisions as numbered Markdown files, with context, rejected alternatives, benefits, drawbacks, and risks. Maintain an index and consult existing ADRs—architecture decision records—to explain why a framework, database, or design approach was chosen.
Design a persistent multi-agent workflow in Claude Code, with specialist roles, reusable commands, file-based memory, and scheduled tasks. Keep project context and decisions across sessions using JSON and Markdown files without an external database.
Turn a large engineering objective into a written plan with steps sized for individual pull requests, or proposed code changes. Each step includes context, dependencies, checks, and completion criteria so another agent can continue the work.
Helps design ClickHouse tables, write analytical queries, and improve slow queries. Covers loading data in batches, preparing reusable summaries, and monitoring performance for large datasets, real-time dashboards, and time-series analysis.
Set up services such as databases and SMS for a project through Stripe Projects. Sync generated credentials into `.env`, connect supported provider accounts, and manage credential rotation, plan changes, and service removal.
Manage Docker containers, images, storage volumes, and networks with standard commands. Start multi-service applications with Docker Compose, investigate failures through logs, check disk usage, and review Dockerfiles for improvements.