Blog & Articles

Notes on databases, security, AI, and automation.

A growing collection of practical articles from Mukesh Asthana, focused on engineering habits, production reliability, and responsible experimentation.

Database Architecture

A Practical PostgreSQL Performance-Tuning Checklist

A repeatable way to investigate slow PostgreSQL workloads: evidence first, then query plans, indexes, partitioning, and validation.

Read article →
Cybersecurity

Cybersecurity Basics That Every Technical Team Should Reinforce

Practical security habits for access, secrets, patching, logging, dependencies, and incident readiness.

Read article →
AI & Responsible Design

Building Medical-Assistance Chatbot Prototypes Responsibly

Safety, privacy, boundaries, escalation, and evaluation considerations for healthcare-adjacent AI prototypes.

Read article →
Automation

Designing Automation Workflows That Actually Help

How to select repetitive tasks, make automation observable, handle failures, and keep human review where it belongs.

Read article →

Topics I write about

Database architecturePostgreSQL performanceOracle modernizationCybersecurityAI prototypesPython & n8n automation

These are starter articles for the portfolio. Add publication dates, examples, screenshots, and code snippets as your editorial content grows.