Free AI Prompt Library - ChatGPT, Claude, Gemini

Mistral Prompt for Generating SQL Queries

Mistral, the language model developed by French startup Mistral AI, excels at generating SQL queries thanks to its fine understanding of data structures and relational database syntax. Whether you work with MySQL, PostgreSQL, SQL Server, or SQLite, a well-crafted prompt yields optimized, properly indexed queries tailored to your schema. The main challenge lies in accurately conveying context: table structures, relationships between entities, data types, and business constraints. Without this information, even the best model will produce generic and potentially inefficient queries. By providing Mistral with a clear schema and precise objectives, you transform an often tedious process into near-instant generation of functional queries. This guide offers tested and refined prompts to get the most out of Mistral in your daily SQL tasks, from simple SELECT statements to complex analytical queries with subqueries, multiple joins, and window functions.

Prompt ChatGPT to Create E2E Tests

End-to-end (E2E) tests are essential to ensure an application works as a whole, but writing them is often time-consuming and repetitive. ChatGPT can significantly speed up this process by generating complete test scenarios covering critical user paths, edge cases, and necessary assertions. Whether you use Cypress, Playwright, Selenium, or any other framework, AI can produce structured and maintainable tests from a simple functional description. The challenge is to provide a sufficiently precise prompt to obtain realistic tests that follow best practices (stable selectors, async handling, test isolation) and integrate directly into your CI/CD pipeline. In this guide, you'll find an optimized main prompt along with variants adapted to your expertise level, to turn your functional specifications into robust E2E test suites in seconds.

Midjourney Prompt to Create a Prototype

Creating prototypes is a crucial step in any design process, whether for product design, digital interfaces, or physical objects. Traditionally, this phase requires skills in 3D modeling, industrial design, or model making—technical skills that can significantly slow down creative teams. Midjourney upends this approach by enabling the generation of photorealistic prototype visuals in just a few seconds. With well-crafted prompts, you can explore dozens of creative directions, test different materials, shapes, and finishes, and present compelling concepts to clients or investors without using CAD software. Whether you're a product designer looking to quickly validate an idea, an entrepreneur preparing a pitch deck, or a UX team wanting to visualize an interface concept on a physical device, Midjourney offers an unprecedented visual experimentation playground. The main challenge lies in prompt formulation: you need to guide the AI toward a render that resembles a real industrial prototype, with the right materials, appropriate studio lighting, and the level of detail expected by professionals.

Prompt DALL-E to Create a Prototype

Creating visual prototypes is a crucial step in any product design process. Traditionally reserved for designers with specialized tools like Figma or Sketch, this phase can now be accelerated with DALL-E. By generating realistic visual mockups from text descriptions, DALL-E allows entrepreneurs, product managers, and developers to quickly materialize their ideas without advanced graphic skills. Whether you want to visualize a mobile app interface, a physical product, or an architectural concept, DALL-E transforms your descriptions into compelling visual representations. This approach considerably reduces the time between ideation and the first visual iteration, going from several days to a few minutes. The AI-generated prototype then serves as a basis for discussion with stakeholders, investors, or potential users, facilitating the collection of concrete feedback before investing in costly development. Mastering the art of prompting for prototype generation with DALL-E thus becomes a strategic skill for anyone wishing to innovate quickly and effectively.

Claude Prompt for Creating E2E Tests

End-to-end (E2E) tests are essential to ensure your application works correctly from the end user's perspective. However, writing them is often time-consuming and repetitive: simulating complete user journeys, handling selectors, async waits, and UI state assertions. Claude excels at this task by generating structured, maintainable E2E tests covering both happy paths and edge cases. By providing context about your application — tech stack, test framework, page structure — Claude produces ready-to-run test suites for Playwright, Cypress, or other tools. It understands best practices like data-testid usage, the Page Object Model pattern, and loading state management. Whether starting from scratch or supplementing existing coverage, Claude transforms a functional description into robust tests in seconds, letting you focus on business logic rather than technical plumbing.

Prompt ChatGPT to Create a REST API

Creating a REST API is a fundamental step in modern application development. Whether you're building a mobile app, a dashboard or a microservices system, a well-designed API is the backbone of your architecture. ChatGPT proves to be a valuable ally to accelerate this development phase: it can generate the complete structure of your API, define endpoints according to REST conventions, produce server code with error handling, and even create the associated OpenAPI documentation. By using a well-structured prompt, you get in seconds a functional API skeleton that follows best practices — route naming, appropriate HTTP codes, incoming data validation, and separation of concerns. Instead of starting from scratch, you iterate on a solid foundation that ChatGPT adapts to your tech stack (Node.js, Python, Go, PHP…) and your business domain. This guide offers optimized prompts to get the most out of ChatGPT in designing and implementing your REST APIs, from rapid prototyping to production-ready API.

Gemini Prompt to Generate JavaScript Code

Gemini, the artificial intelligence model developed by Google, stands out as a formidable tool for generating JavaScript code. Thanks to its deep understanding of programming languages and their ecosystems, Gemini can produce functional, optimized, and well-structured code in just a few seconds. Whether you need to create a utility function, an interactive component, a REST API, or a complex algorithm, a well-crafted prompt makes all the difference between an approximate result and production-ready code. The main challenge lies in the precision of your request: the more you specify the technical context (framework used, JavaScript version, naming conventions, expected error handling), the more Gemini generates relevant and directly usable code. This guide offers an optimized main prompt as well as variants tailored to your expertise level, to get the most out of Gemini in your daily JavaScript development projects.

Perplexity Prompt for Generating JavaScript Code

Perplexity stands out from other AI assistants by its unique ability to combine real-time web search and code generation. When you ask it to produce JavaScript code, it doesn't just rely on static knowledge: it consults official documentation, recent GitHub repositories, and current technical discussions to provide you with up-to-date and functional code. This approach is especially valuable in JavaScript, an ecosystem where best practices, browser APIs, and conventions evolve rapidly. Where a classic LLM might suggest outdated syntax or a deprecated method, Perplexity checks its sources and cites the references used. Whether you need a React component, a Node.js utility function, or a vanilla DOM manipulation, crafting a structured prompt with the right technical context ensures a result that is immediately usable. This guide shows you how to get the most out of Perplexity for your JavaScript code generation needs, from simple scripts to complete modular architectures.

DALL-E Prompt for Creating a Chatbot

DALL-E, OpenAI's artificial intelligence image generator, is a valuable tool for designing the visual elements of a chatbot. Whether you're developing a virtual assistant for your website, mobile app, or messaging platform, your chatbot's visual identity plays a crucial role in user engagement. With DALL-E, you can create custom avatars, conversational interfaces, expressive icons, and illustrations that bring your virtual assistant to life. A chatbot with a polished visual identity inspires trust, strengthens brand consistency, and significantly enhances the user experience. Thanks to well-crafted prompts, DALL-E allows you to generate professional visuals without graphic design skills, quickly iterating across different styles—from minimalist corporate to friendly cartoon characters. This guide provides optimized prompts to create all the visual assets needed for your chatbot, from the main avatar to interface elements and emotional state illustrations that will make your virtual assistant memorable and engaging.

Perplexity Prompt to Create a Prototype

Perplexity stands out from other AI assistants due to its ability to combine real-time web search with intelligent synthesis. To create a prototype, this dual capability is valuable: Perplexity can simultaneously identify current best practices, suitable frameworks, reusable components, and proven architectures before guiding you through the actual construction. Unlike a traditional search engine that would bury you under links, Perplexity structures information and produces actionable recommendations. Whether you are prototyping a web application, an API, a physical product, or a user interface, the key lies in a prompt that clearly defines the functional scope, technical constraints, and desired fidelity level. A good prompt transforms Perplexity into a prototype architect capable of providing you with a complete action plan, from technology choice to functional code. The recommended approach is to describe your product vision, specify your preferred technical stack, and request a structured deliverable step by step.

Claude Prompt for Creating a REST API

Creating a REST API is a fundamental task of modern backend development. Whether you are building a microservice, a SaaS application, or a full platform, a well-structured API is the backbone of your architecture. Claude excels at generating complete REST APIs following best practices: clear project structure, data validation, error handling, authentication, OpenAPI documentation, and tests. Rather than starting from scratch or copying outdated boilerplates, you can precisely describe your business needs to Claude and get a production-ready API in minutes. The major advantage lies in Claude's ability to adapt the code to your framework of choice (Express, FastAPI, NestJS, Django REST, Spring Boot) while applying RESTful conventions: appropriate HTTP verbs, correct status codes, pagination, filtering, and versioning. This guide provides optimized prompts to get the most out of Claude in designing and implementing your REST APIs, from quick prototypes to complete microservice architectures.

Midjourney Prompt to Generate Python Code

Midjourney is primarily an AI image generation tool, not a code generator per se. However, it can be used creatively to produce visuals representing Python code: stylized screenshots, snippet illustrations for presentations, tutorial thumbnails, or educational visuals showing code excerpts. By crafting precise prompts, you can get photorealistic renders of screens displaying Python code in an IDE, artistic representations of data structures, or infographics illustrating programming concepts. This approach is especially useful for tech content creators, trainers, and designers who need impactful code-related visuals without relying on real screenshots. The main challenge lies in the prompt formulation: Midjourney does not understand Python syntax, it generates a visual approximation. You therefore need to guide the AI with precise descriptions of the development environment, the desired visual style, and the context in which the code appears. Here are the best prompts to obtain convincing results.