Amey-Thakur
- 1k skills
- 0 followers
- 1 day ago last updated
- ▌ CI CD · amey-thakurBuild CI/CD pipelines that are fast, trustworthy, and safe to deploy from. Use when creating or fixing continuous integration, delivery workflows, or release automation.
- ▌ SQL Joins · amey-thakurChoose and write the right join so rows are neither lost nor multiplied, and know why a result set grew. Use when combining tables and the row count or the null columns look wrong.
- ▌ API Design · amey-thakurDesign HTTP and library APIs that are predictable, hard to misuse, and stable under growth. Use when creating or reviewing endpoints, public functions, or wire formats.
- ▌ Iam Design · amey-thakurStructure cloud IAM with role-based access, short-lived credentials, and permission boundaries that hold at scale. Use when designing cloud access control or cleaning up accumulated permissions.
- ▌ Email Tone · amey-thakurGet the tone of an email right: warm, professional, and matched to the reader and situation, without the coldness email invites. Use when an email's wording could land wrong, or when the relationship matters as much as the message.
- ▌ User Flows · amey-thakurMap and design the paths a user takes to complete a goal, minimizing steps and dead ends. Use when designing a multi-step task, checkout, signup, or any flow, or diagnosing where users drop off.
- ▌ UX Writing · amey-thakurWrite the words inside an interface (labels, buttons, errors, empty states, microcopy) so they are clear, concise, and helpful. Use when writing or reviewing any text a user reads while using a product.
- ▌ SQL Date Time · amey-thakurStore, compare, and bucket timestamps with explicit time zones so reports do not drift by a day and ranges do not miss rows. Use when filtering by date, grouping by period, or storing an event time.
- ▌ Grpc Services · amey-thakurDesign gRPC services with clean proto contracts, versioning, streaming patterns, and deadline propagation. Use when building high-performance service-to-service APIs or evaluating gRPC against REST.
- ▌ Clear Emails · amey-thakurWrite emails that get read and acted on: one clear purpose, the ask up front, and only what the reader needs. Use when writing any email that must be understood and answered without back-and-forth.
- ▌ Null Semantics · amey-thakurReason about SQL nulls in comparisons, aggregates, joins, and uniqueness so absent values stop producing wrong or missing rows. Use when a query silently drops rows or a NOT IN returns nothing.
- ▌ Tdd Rhythm · amey-thakurRun red-green-refactor honestly with the smallest failing test first, refusing test-after backfill dressed up as TDD. Use when building code with a clear behavioral spec and you want the tests to drive the design.
- ▌ Test Speed · amey-thakurKeep the suite fast enough to run on every change by measuring the slow tests, shaping the pyramid, cutting IO from the fast tier, and sharding. Use when the suite is slow enough that developers skip it or batch changes to avoid the wait.
- ▌ API Sdk Design · amey-thakurDesign SDKs that feel idiomatic per language, handle auth and resilience, and version cleanly. Use when building an official client library for your API.
- ▌ Debugging · amey-thakurFind the root cause of a bug with a hypothesis-driven loop instead of guess-and-patch. Use when something fails, crashes, or behaves wrongly and the cause is not yet known.
- ▌ MCP Tool Design · amey-thakurDesign MCP tools an agent can select correctly, with names, descriptions, and schemas that make the right call obvious and the wrong one impossible. Use when exposing capability to an agent through an MCP server.
- ▌ Deep Linking · amey-thakurSet up universal and app links that open the right in-app screen from a URL, with deferred links surviving install and a routing layer that validates every parameter. Use when adding shareable links, wiring campaign or email links into the app, or debugging links that open the browser instead.
- ▌ Bug Bounty · amey-thakurHunt vulnerabilities in bug bounty programs effectively and within the rules: scope, methodology, safe proof, and reports that get accepted. Use when participating in a bug bounty or coordinated disclosure program.
- ▌ SQL Aggregation · amey-thakurGroup and aggregate correctly, understanding what GROUP BY collapses, how HAVING differs from WHERE, and how nulls and empty groups behave. Use when producing counts, sums, and per-group summaries.
- ▌ Upsert Patterns · amey-thakurInsert or update in one statement without races or lost updates, using the engine's conflict handling rather than check-then-write. Use when writing records that may or may not already exist.
- ▌ API Testing · amey-thakurTest an HTTP API at its boundary so status codes, response schemas, error bodies, and auth paths all hold under real requests. Use when adding or reviewing tests for a service that other clients call over HTTP.
- ▌ E2e Testing · amey-thakurWrite end-to-end tests that earn their cost by covering complete user journeys against stable selectors. Use when protecting a critical path like signup or checkout across the full stack.
- ▌ Smoke Tests · amey-thakurDefine the short, stable suite of critical-path checks that runs after every deploy and blocks promotion the instant it fails. Use when a deploy has no fast gate and breakage is found by users instead of the pipeline.
- ▌ Test Naming · amey-thakurName tests as full behavior sentences so the suite reads as a specification of what the system guarantees. Use when naming a new test or renaming vague tests like test1 or testWorks.
- ▌ Test Review · amey-thakurReview tests with the same rigor as production code, checking that assertions truly constrain behavior, that error and edge cases exist, and that no safety was quietly deleted. Use when reviewing a pull request that adds, changes, or removes tests.
- ▌ Onboarding UX · amey-thakurDesign a first-run experience that gets users to their first success fast, teaching by doing rather than by tour. Use when designing signup, first-run, or activation flows for a product.
- ▌ API Deprecation · amey-thakurRetire API surface with sunset headers, usage tracking, migration guides, and enforced timelines. Use when removing an endpoint, field, or version that consumers depend on.
- ▌ Core Dumps · amey-thakurExtract the cause of a crash from a core dump using symbols, backtraces, and post-mortem inspection. Use when a native process died with a signal and left a core file, or when you have a crash dump but no live process to attach to.
- ▌ Git Bisect · amey-thakurFind the exact commit that introduced a regression by driving git bisect with an automated pass/fail script. Use when a behavior worked in an older build and you need the first bad commit out of hundreds, not a guess.
- ▌ Heisenbugs · amey-thakurCatch timing-dependent bugs that vanish under observation by amplifying the race and moving logging off the critical path. Use when a fault appears intermittently and disappears the moment you add a print or attach a debugger.
- ▌ Log Levels · amey-thakurAssign log levels deliberately so error wakes a human, warn flags a trend, and info and debug explain later without burying the signal. Use when logs are either silent during real failures or so noisy that nobody trusts them.
- ▌ Python Typing · amey-thakurAdd type hints where they catch real errors and document contracts, choosing Protocol, generics, or TypedDict deliberately and setting a checker strictness you can actually hold. Use when introducing or tightening types on a Python codebase.
- ▌ OAUTH Flows · amey-thakurImplement OAuth 2.0 and OpenID Connect flows that bind the request end to end with PKCE, state, and exact redirect allowlists. Use when adding "sign in with" a provider, integrating a third-party API on a user's behalf, or reviewing an OAuth client.
- ▌ Xss Defense · amey-thakurPrevent cross-site scripting by encoding output for its exact sink, keeping template autoescaping on, and backing it with a strict Content Security Policy. Use when rendering user-controlled data into HTML, attributes, JavaScript, or URLs.
- ▌ Window Functions · amey-thakurUse window functions to rank, compare to neighbours, and compute running totals without collapsing rows or self-joining. Use when you need per-row context such as a rank, a previous value, or a running sum.
- ▌ Fuzz Testing · amey-thakurFuzz a parser or protocol handler with a coverage-guided fuzzer, seed the corpus with real inputs, and triage crashes to unique root causes. Use when code consumes untrusted or complex bytes and hand-written cases cannot reach the states that break it.
- ▌ Load Testing · amey-thakurSimulate realistic multi-user load with ramp profiles, think time, and pacing, then find where the system saturates. Use when validating capacity or headroom for a service before a launch or expected traffic spike.
- ▌ Mocking Time · amey-thakurControl the clock in tests through an injectable time source so "now" is frozen and timezone behavior is explicit. Use when code reads the wall clock and a flaky or time-dependent test needs deterministic results.
- ▌ Test Doubles · amey-thakurChoose stubs, fakes, and mocks deliberately and default to verifying state over interaction so tests survive refactors. Use when a test needs to stand in for a slow, external, or nondeterministic dependency.
- ▌ Test Tagging · amey-thakurTag tests by speed and scope so CI can run the right slice at the right time. Use when the suite is one undifferentiated blob and you need fast feedback on pull requests without dropping slow coverage.
- ▌ Health Checks · amey-thakurDesign liveness, readiness, and startup probes that heal real failures without amplifying outages. Use when wiring health endpoints or debugging restart loops and drained fleets.
- ▌ Multi Tenancy · amey-thakurIsolate tenants in data, code, and capacity, choosing the right isolation model per tier. Use when designing SaaS data models or containing noisy-neighbor and cross-tenant risks.
- ▌ Cloud Migration · amey-thakurMigrate workloads to the cloud with honest 6R triage, dependency mapping, and rehearsed cutovers with rollback. Use when planning a datacenter exit or moving systems between clouds.
- ▌ Dark Mode · amey-thakurImplement dark mode that honors system preference, allows manual override, and never flashes the wrong theme. Use when adding dark mode or fixing its flash, contrast, or image problems.
- ▌ Email Etiquette · amey-thakurFollow email conventions that keep you professional and considerate: CC/BCC, reply-all, response times, and threading. Use when unsure of the norms, or to avoid the mistakes that annoy colleagues and burn goodwill.
- ▌ Email Structure · amey-thakurStructure an email so a skimming reader gets the point, the context, and the ask in the right order. Use when an email has more than a line or two and the layout decides whether it is understood.
- ▌ Gc Tuning · amey-thakurCut garbage-collection pauses and overhead by lowering allocation rate, sizing the heap, and reading pause logs before touching a flag. Use when a managed-runtime service shows latency spikes, high CPU in GC, or out-of-memory errors under load.
- ▌ Pytest Mastery · amey-thakurStructure pytest suites with fixtures, parametrize, and markers so tests stay fast, isolated, and readable. Use when writing Python tests or untangling a slow, fixture-heavy suite.
- ▌ Python Asyncio · amey-thakurDecide whether asyncio pays off, keep the event loop unblocked, and structure concurrency with TaskGroup and disciplined cancellation. Use when writing async Python or diagnosing a hung, slow, or silently-failing event loop.
- ▌ Web Research · amey-thakurSearch the web effectively: query construction, iterating on results, and going to primary sources. Use when researching a topic online, especially for an agent gathering current or factual information.
- ▌ API Security · amey-thakurSecure an API by enforcing per-object authorization, per-caller quota, and schema-validated input on every endpoint. Use when building or reviewing an HTTP or GraphQL API that serves authenticated users, machine clients, or partner integrations.
- ▌ Authn Design · amey-thakurDesign sign-in so credentials are hashed with a slow algorithm, guessing is rate limited, and sessions rotate on login to defeat fixation. Use when building or reviewing registration, login, or password-reset flows.
- ▌ Authz Design · amey-thakurEnforce authorization so access is denied by default and every request re-checks that the caller owns the specific resource, closing IDOR gaps. Use when building endpoints that read or modify data belonging to a particular user or tenant.
- ▌ Crypto Usage · amey-thakurUse cryptography by calling vetted libraries with authenticated defaults and storing keys in a KMS, never by designing a scheme. Use when adding encryption, choosing a cipher or mode, or reviewing code that handles keys or ciphertext.
- ▌ Csrf Defense · amey-thakurBlock cross-site request forgery with SameSite cookies, per-session anti-CSRF tokens, and strict HTTP method discipline so a forged cross-origin request cannot act as the user. Use when building state-changing endpoints authenticated by cookies.
- ▌ JWT Handling · amey-thakurUse JSON Web Tokens safely by pinning the algorithm, keeping lifetimes short, and pairing them with a revocation path. Use when issuing or validating JWTs, designing a session scheme around them, or reviewing token-based auth.
- ▌ Pii Handling · amey-thakurMinimize, classify, mask, and expire personal data so any leak or legal request reaches as little of it as possible. Use when designing storage, logging, or analytics that touch names, contacts, identifiers, or other personal data.
- ▌ Ssrf Defense · amey-thakurPrevent server-side request forgery by constraining where a user-influenced URL can make the server connect. Use when the server fetches a URL that came from a user: webhooks, link previews, image proxies, PDF renderers, or import-from-URL features.
- ▌ Pivot And Unpivot · amey-thakurReshape rows into columns and back, and know when the reshape belongs in SQL rather than in the reporting layer. Use when a report needs periods or categories as columns, or a wide table needs normalising.
- ▌ Query Readability · amey-thakurWrite SQL other people can review, modify, and trust, with clear structure, meaningful aliases, and stated assumptions. Use when a query will be read again by anyone, including you.
- ▌ Recursive Queries · amey-thakurWalk hierarchies and graphs with recursive CTEs, with a termination condition and cycle protection so the query ends. Use when querying trees such as org charts, categories, threads, or dependency graphs.
- ▌ Bdd Scenarios · amey-thakurWrite given-when-then scenarios in domain language so stakeholders can read and confirm the behavior each test protects. Use when drafting acceptance criteria or Gherkin features for a user-facing rule.
- ▌ Chaos Testing · amey-thakurInject failures like killed instances and network latency on purpose to verify a system degrades gracefully instead of collapsing. Use when validating the resilience of a distributed system that claims to tolerate faults.
- ▌ Golden Master · amey-thakurCapture the current output of untested legacy code as a recorded baseline so a refactor can prove it changed nothing. Use when about to restructure code whose behavior you must preserve but cannot yet specify.
- ▌ Clear Writing · amey-thakurWrite so the reader understands on the first pass: plain words, concrete nouns, one idea per sentence. Use when drafting or editing any prose that must be understood without effort.
- ▌ API Client Design · amey-thakurBuild API clients with retries, timeouts, pagination, and error surfacing baked in, and test them properly. Use when writing a client for an external or internal API.
- ▌ Openapi Contracts · amey-thakurDrive API development from an OpenAPI spec as the contract, with linting, codegen, and drift detection. Use when building or documenting REST APIs and wanting the spec to be the single source of truth.
- ▌ API Versioning · amey-thakurVersion APIs so existing clients keep working while the contract evolves, with a real sunset process. Use when choosing a versioning scheme or planning a breaking API change.
- ▌ Message Queues · amey-thakurChoose between queues and streams, and configure ordering, consumer groups, and dead letters correctly. Use when introducing async messaging or debugging lost, duplicated, or reordered messages.
- ▌ Cloud Networking · amey-thakurLay out VPCs, subnets, private connectivity, and DNS so services reach each other privately and the internet only on purpose. Use when designing cloud network topology or debugging cross-service connectivity.
- ▌ CSS Layout · amey-thakurChoose between flexbox and grid by content shape and build layouts that survive real content. Use when structuring a page or component layout, or fixing overflow and alignment bugs.
- ▌ Log Analysis · amey-thakurMine logs for the cause of a failure by pivoting on correlation ids, clamping the time window, and querying structured fields instead of scrolling. Use when production broke and the logs are the only record of what the system actually did.
- ▌ Memory Leaks · amey-thakurFind the object that never gets freed by comparing heap snapshots and following retention paths. Use when a process grows in memory over time, gets OOM-killed, or slows under a garbage collector that keeps working harder.
- ▌ Gitops Workflow · amey-thakurManage deployments declaratively from git as the source of truth, with reconciliation, secrets handling, and drift alerts. Use when adopting GitOps or fixing config drift and untracked cluster changes.
- ▌ Runbook Writing · amey-thakurWrite runbooks with executable steps, decision points, and per-step verification that a stressed responder can follow. Use when documenting operational procedures or reducing 3am guesswork.
- ▌ Difficult Emails · amey-thakurWrite the hard emails (bad news, saying no, complaints, corrections) so they are clear, kind, and preserve the relationship. Use when an email must deliver something unwelcome without making it worse.
- ▌ Email Follow Ups · amey-thakurFollow up on unanswered emails effectively: the right timing, adding value, and knowing when to stop. Use when an email went unanswered and you need a reply without nagging or damaging the relationship.
- ▌ Inbox Management · amey-thakurManage an email inbox so it is a task list you control, not a source of stress: triage, process, and protect focus. Use when email volume is overwhelming or the inbox has become an anxiety pile.
- ▌ Form Handling · amey-thakurBuild forms with validation timing, error display, and submission states that respect users and screen readers. Use when creating or reviewing any form, or fixing premature-error or lost-input complaints.
- ▌ Optimistic UI · amey-thakurApply optimistic updates with correct rollback, conflict handling, and pending cues so mutations feel instant without lying. Use when a mutation feels slow, or when adding or debugging optimistic updates and their rollbacks.
- ▌ Csharp Linq · amey-thakurUse LINQ with deferred execution understood, database translation respected, and loops chosen when they win. Use when writing C# queries over collections or ORMs, or debugging surprising LINQ behavior.
- ▌ MCP Authentication · amey-thakurAuthenticate and authorise access to a remote MCP server so tools act as the right user with the least necessary privilege. Use when hosting an MCP server that more than one person or agent reaches.
- ▌ MCP Error Handling · amey-thakurReturn errors an agent can act on, distinguishing retryable failures from permanent ones and never leaking internals. Use when building MCP tools that will fail in production.
- ▌ MCP Server Testing · amey-thakurTest an MCP server for protocol conformance, tool selection accuracy, and behaviour under real model calls rather than only unit tests. Use before shipping a server others will connect agents to.
- ▌ Mobile Input UX · amey-thakurMake mobile forms and controls fast to use with correct keyboards, reachable touch targets, and restrained haptics. Use when building input-heavy mobile screens or fixing form abandonment on small screens.
- ▌ Web Vitals · amey-thakurImprove LCP, CLS, and INP by measuring field data, tracing each metric to its specific cause, and applying the fixes known to move that number. Use when Core Web Vitals are failing or a page feels slow to load, settle, or respond.
- ▌ Pythonic Idioms · amey-thakurApply Python idioms where they cut bookkeeping and clarify intent, and refuse them where the clever form hides control flow. Use when writing loops, resource handling, or unpacking and deciding how idiomatic to make it.
- ▌ Deep Research · amey-thakurRun a thorough multi-source research investigation end to end: plan, search broadly, verify, and synthesize a cited answer. Use when a question needs deep, autonomous research across many sources, not a quick lookup.
- ▌ Fact Checking · amey-thakurVerify claims before stating them: trace to the source, corroborate independently, and separate fact from inference. Use when accuracy matters, especially before an agent asserts facts, numbers, or quotes.
- ▌ Audit Logging · amey-thakurRecord security-relevant events in a tamper-evident, append-only log that answers who did what and when. Use when building or reviewing logging for authentication, authorization, privilege changes, or access to sensitive data.
- ▌ Rate Limiting · amey-thakurLimit requests by the cost they impose and the identity behind them, using token buckets, deliberate keys, and tiered responses to abuse. Use when protecting an API, a login flow, or any expensive endpoint from brute force, scraping, and accidental overload.
- ▌ SQL Set Operations · amey-thakurCombine result sets with UNION, INTERSECT, and EXCEPT, and know when a join or an exists clause is the better tool. Use when merging or comparing two query results rather than two tables.
- ▌ Browser Matrix · amey-thakurChoose which browsers, versions, and devices to test from real usage data instead of habit or a vendor's full grid. Use when cross-browser testing time or budget is finite and the matrix needs to reflect who actually visits.
- ▌ Test Isolation · amey-thakurMake tests order-independent by resetting state, banning shared globals, and giving each worker its own resources. Use when tests pass in one order but fail when reordered, sharded, or run in parallel.
- ▌ Visual Hierarchy · amey-thakurGuide the eye to what matters through size, contrast, spacing, and grouping so a screen reads at a glance. Use when a design feels cluttered, flat, or hard to scan, or when laying out any interface or page.
- ▌ Voice And Tone · amey-thakurDevelop a consistent writing voice and adjust tone to the context without sounding generic or robotic. Use when writing needs personality, a brand voice, or a register matched to the situation.
- ▌ Background Jobs · amey-thakurRun asynchronous work through queues with safe retries, poison-message handling, and idempotent jobs. Use when moving work out of the request path or fixing duplicated, stuck, or lost jobs.
- ▌ Webhooks Design · amey-thakurDeliver webhooks with signatures, retries, and ordering rules consumers can actually build against. Use when adding webhooks to a product or hardening delivery and verification on either side.
- ▌ CSS Cascade · amey-thakurManage specificity with layers, :where, and low-specificity selectors so overrides stay predictable. Use when styles fight each other, !important spreads, or you are setting selector conventions for a codebase.
- ▌ CSS Theming · amey-thakurBuild a custom-property token system with primitive and semantic tiers that supports runtime theme switching. Use when setting up design tokens, adding themes, or refactoring hardcoded colors.