Platform Engineer ( Scalable Backend + K8s + IaC + CI/CD + runtime + Postgres perf)

projects

devto

hashnode

github

Arnab Chatterjee  • Peerlist

OptiSchema Slim is an AI-powered PostgreSQL optimization tool for DBAs, backend engineers, and platform teams who want faster performance wins with less guesswork.It runs a simple analysis pipeline: it surfaces slow/expensive queries from your database signals, inspects EXPLAIN plans to understand what’s driving cost (scans, joins, row estimates, missing indexes), and then uses AI to propose clear, actionable fixes like index candidates, query rewrites, and config-level tips, with reasoning and risk notes.Instead of creating real indexes just to “see what happens,” OptiSchema uses HypoPG to create hypothetical indexes and performs before/after plan + estimated cost comparisons, so you can validate whether the planner would actually change its strategy and benefit.Great for recurring performance checks in SaaS apps, internal tools, and API backends running Postgres at scale. Privacy-first and flexible: local-first with optional AI modes, designed to fit real production workflows.

OptiSchema Slim

A CSS Module Transformer is a NPM package designed to transform classnames in JSX attributes to use CSS modules. This plugin replaces className="example" with className={styles.example} for static classnames and className={dynamicClassName} with className={styles[dynamicClassName]} for dynamic classnames.<h2 class="rich-heading"><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.npmjs.com/package/css-module-transformer-beta#features">Features</a></h2><ul><li>Automatic Transformation: The plugin detects and transforms classnames containing hyphens to use CSS modules.</li><li>Static Classnames: Replaces static classnames defined in JSX attributes with the corresponding CSS module syntax.</li><li>Dynamic Classname Support: Seamlessly handle both static and dynamic classnames in JSX</li><li>Preserve other JSX attributes while transforming classnames</li></ul><h2 class="rich-heading"><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.npmjs.com/package/css-module-transformer-beta#installation">Installation</a></h2>Install my-project with npm<pre><code>npm install -g css-module-transformer-beta</code></pre><h2 class="rich-heading"><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.npmjs.com/package/css-module-transformer-beta#usage">Usage</a></h2>Transform a React or Next.js component file:<pre><code> npx transform-classes ./path/to/YourComponent.js
</code></pre><h2 class="rich-heading"><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.npmjs.com/package/css-module-transformer-beta#examples">Examples</a></h2><h4 class="rich-heading"><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.npmjs.com/package/css-module-transformer-beta#input">Input:</a></h4><pre><code>import './YourComponent.css';

function YourComponent() {
 return (
 &lt;div className="container"&gt;
 &lt;h1 className="title"&gt;Hello, CSS Modules!&lt;/h1&gt;
 &lt;/div&gt;
 );
}

export default YourComponent;</code></pre><h4 class="rich-heading"><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.npmjs.com/package/css-module-transformer-beta#output">output</a></h4><pre><code>import styles from './YourComponent.module.css';

function YourComponent() {
 return (
 &lt;div className={styles.container}&gt;
 &lt;h1 className={styles.title}&gt;Hello, CSS Modules!&lt;/h1&gt;
 &lt;/div&gt;
 );
}

export default YourComponent;</code></pre>

css-module-transformer-beta

Link to open source: <a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://github.com/arnab2001/Coinverse">https://github.com/arnab2001/Coinverse</a>Link to Live Project: <a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://coinverse-delta.vercel.app/">https://coinverse-delta.vercel.app/</a>Cryptocurrency tracker and cryptocurrency related News , all at one place📌Key Features :-All crypto prices at a glance in the home pageCrypto NewsCurrent prices of coinsHistorical price data with chartsSearch and get latest news on any specefic coinOrigin , facts and other stuffs💻Tech Stacks used :-ReactReduxAnt DesigneChart jsCoinranking API, Bing News API