mianhtsys/landingMod3
Implement proven backend architecture patterns including Clean Architecture, Hexagonal Architecture, and Domain-Driven Design. Use this skill when designing clean architecture for a new microservice, when refactoring a monolith to use bounded contexts, when implementing hexagonal or onion architecture patterns, or when debugging dependency cycles between application layers.
mianhtsys/landingMod3
Master authentication and authorization patterns including JWT, OAuth2, session management, and RBAC to build secure, scalable access control systems. Use when implementing auth systems, securing APIs, or debugging security issues.
mianhtsys/landingMod3
>-
Generate grounded-and-verified, engine-agnostic database documentation that reaches 100% parity with the
real schema. Introspects the LIVE database as ground truth and cross-validates it against ORM models,
migrations, generated types, seeds, and application queries, then proves completeness by diffing the docs
back against the database. Produces ER diagrams (mermaid), per-table data dictionaries, and a
machine-readable schema.json. Works with PostgreSQL, MySQL, SQL Server, and SQLite across any ORM (Prisma,
TypeORM, Drizzle, Sequelize, Knex, Django, Rails) or raw SQL. Use when asked to document a database,
produce an ERD or data dictionary, write db/schema docs, audit schema drift, or refresh existing DB docs.
mianhtsys/landingMod3
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
mianhtsys/landingMod3
Build and maintain web frontends — component architecture, state management,
API integration, responsive layout, client-side performance, and frontend testing
patterns. Framework agnostic, focused on web frontend implementation. Do not use
for backend service implementation, data engineering, or platform infrastructure
work.
mianhtsys/landingMod3
Execute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
mianhtsys/landingMod3
>-
Use when designing or implementing software securely: define security requirements,
threat-model a feature, choose secure defaults, design authentication and authorization,
handle untrusted data and secrets, evaluate dependencies, design multi-tenant trust
boundaries, or review security-sensitive changes. Use for prevention during
requirements, design, implementation, and review; not for post-build security
assessments or scanning an existing codebase.
mianhtsys/landingMod3
SQL Server development and performance engineering: T-SQL best practices, indexing strategy (clustered, nonclustered, columnstore, filtered, covering/included), execution plans, query optimization, statistics and the cardinality estimator, parameter sniffing mitigation, partitioning, In-Memory OLTP, temporal tables, data compression, and schema design. WHEN: \"T-SQL\", \"write a query\", \"index\", \"covering index\", \"columnstore\", \"execution plan\", \"query plan\", \"query tuning\", \"optimize query\", \"SARGable\", \"cardinality estimator\", \"statistics\", \"parameter sniffing\", \"OPTION RECOMPILE\", \"partitioning\", \"In-Memory OLTP\", \"temporal table\", \"stored procedure\", \"schema design\", \"data type\", \"normalization\".