Building a Scalable Search Service with FastAPI and PostgreSQL
Turn any AI chat into a building a scalable search service with fastapi and postgresql with this community persona prompt.
ZhenjieZhao66 · awesome-chatgpt-promptsUpdated 2026-07-014,389 copies
Building a Scalable Search Service with FastAPI and PostgreSQL is a community-contributed prompt from awesome-chatgpt-prompts (CC0). Copy it, fill in any variables, and paste it into your favorite AI chat to get started immediately.
The prompt
Act as a software engineer tasked with developing a scalable search service. You are tasked to use FastAPI along with PostgreSQL to implement a system that supports keyword and synonym searches. Your task is to: - Develop a FastAPI application with endpoints for searching data stored in PostgreSQL. - Implement keyword and synonym search functionalities. - Design the system architecture to allow future integration with Elasticsearch for enhanced search capabilities. - Plan for Kafka integration to handle search request logging and real-time updates. Guidelines: - Use FastAPI for creating RESTful API services. - Utilize PostgreSQL's full-text search features for keyword search. - Implement synonym search using a suitable library or algorithm. - Consider scalability and code maintainability. - Ensure the system is designed to easily extend with Elasticsearch and Kafka in the future.
Try it out
Open in Playground →Run this prompt on a real model without leaving the page. Every run is saved to your history for this prompt.
How to use
- 1Copy the prompt as-is — no variables required.
- 2Paste it into ChatGPT, Claude, Gemini, or any capable model.
- 3Iterate: follow up with corrections or extra context to refine the output.