Prisma Assistant

Prisma Assistant is a developer tool that lets you interact with your Prisma database schema using natural language. You ask questions about your data—like 'list all users and include their portfolio'—and it generates the correct Prisma client code for you. It runs as a local server on your machine, connecting to your existing Prisma project to understand your models and relationships. This means your database schema and API keys stay private on your computer.

You start it with a simple `npx` command from your project's root. Once running, it gives you a local web URL where you can type questions in a chat interface. Under the hood, it uses an AI model (via OpenAI's API or a local model through Ollama) to interpret your request and produce the corresponding TypeScript code. The tool is flexible, allowing you to specify which AI model to use and even point it to a local Ollama instance for complete offline operation.

This tool is most useful for developers who work with Prisma regularly and want to speed up query writing or explore their data structure without constantly checking documentation. It's great for quickly prototyping data access logic or for developers learning Prisma who want to see how specific queries are constructed. Since it runs locally, it's also a solid choice for teams with strict data security requirements who still want AI-assisted coding help.