I Built an AI-Powered Database Query Optimizer (And Made It Open Source)

Vamsi krishna — Fri, 05 Jun 2026 14:22:28 +0000

I wanted to share a project I've been working on recently: an AI-Powered Database Query Optimizer.

The Problem: Identifying slow database queries can be tedious, and manually running EXPLAIN ANALYZE to figure out what went wrong takes time.

How it works:

It acts as a middleware monitoring PostgreSQL queries via SQLAlchemy.

If a query takes longer than a threshold (default 500ms), it flags it and automatically triggers an EXPLAIN ANALYZE.

The query structure, schema context, and execution plan are passed to the GROQ API to generate tailored indexing and optimization strategies.

Everything is fed into a live React/Vite dashboard where you can review, dismiss, or manually queue optimizations.

⚠️ Note: This is currently an MVP to prove out the core pipeline and concept—it is not yet built or intended for heavy production scaling!

Tech Stack:

Backend: FastAPI, SQLAlchemy, PostgreSQL, Pytest

Frontend: React, Vite, TypeScript

AI Layer: GROQ API

I've open-sourced the repository and also deployed a live demo if you want to check it out or trigger some simulated slow queries!

GitHub Repository : https://github.com/Dreamervamsi/AI-powered-database-query-optimiser

Live Dashboard : https://ai-powered-database-query-optimiser-cqdl.onrender.com/

I'd like to hear your thoughts on the architecture, the approach to query interception, or any features you think would make this even more useful!

I built typecraft-cli: An AI tool that automatically catches missing TypeScript types

Vamsi krishna — Wed, 03 Jun 2026 04:18:49 +0000

We’ve all stared at a schema or a complex function (especially when it's written in TypeScript) and thought... "What the heck type am I actually supposed to put here?".

To save time and keep your momentum, you slap an any type on it and promise yourself you'll "fix it later." (Spoiler alert: we rarely do).

Manually tracking down missing implicit any definitions or unannotated parameters can ruin your development flow. While paid AI extensions exist, they can be costly and frequently spam your terminal console with unreadable, messy raw string blocks.

To solve this, I built typecraft-cli ⚡ — an entirely open-source, minimal static analysis tool that scans your codebase and leverages free Hugging Face LLMs to generate accurate TypeScript annotations automatically.

Instead of cluttering your local environment, it streams suggestions straight into a neatly formatted type-checker.md file right in your workspace directory so you can reference it side-by-side with your code editor.

🚀 Key Features

Automated Type Detection: Scans local directories to catch loose parameters and missing strict types.
Open Source & Free AI: Leverages specialized, open-source code models via Hugging Face. No OpenAI API keys required.
Zero Terminal Clutter: Keeps your workspace completely quiet while processing everything into clean Markdown reports.

🛠️ Quick Start

You can run it instantly using npx:

npx typecraft-cli

(Or install it globally via npm install -g typecraft-cli)

Prerequisties

Before running the tool, you'll need a Hugging Face Inference API token (it's free!) so the CLI can communicate with the open-source LLMs:

1. - Grab your token from your Hugging Face Settings.
2. - Create a .env file in the root of your project.
3. - Add your token like this: Code snippet HF_TOKEN=your_actual_token

DEV Community: Vamsi krishna

I Built an AI-Powered Database Query Optimizer (And Made It Open Source)

I built typecraft-cli: An AI tool that automatically catches missing TypeScript types

🚀 Key Features

🛠️ Quick Start

Prerequisties