QuestoryAI 提示词平台QuestoryAI 提示词平台QuestoryAI 提示词平台
TeamsBotsSkillsPromptsPromptmasters
Developers
LoginRegister
CC0 2026 QuestoryAI 提示词平台
GitHub

Building a Scalable Search Service with FastAPI and PostgreSQL

Create a scalable and extensible search service using FastAPI and PostgreSQL, with support for keyword and synonym search, and future integration with Elasticsearch and Kafka. 来源:https://prompts.chat/prompts/cml8v1x090006k2049vph95lw

L
@import-5bc426e8d81e2f4136a562fa
about 1 hour agoNovember 11, 2026 at 02:00 AM
Web Development•APIWeb Development
1

Content

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.

Related Skills

OpenAPI Spec Drift Checker

Skill

Compares an OpenAPI YAML/JSON spec to a list of implemented routes and flags drift: missing operations, extra routes, method mismatches, and path-parameter shape differences. Use when reviewing API PRs, before a release, or asking "does our code still match the OpenAPI?". Includes a stdlib Python checker with --self-test. 来源:https://prompts.chat/prompts/cmvan841x0005l206qhg2xrll

F@import-252f10c83610ebca1a059c0b
0

Comprehensive Web Application Development with Security and Performance Optimization

Skill

Guide to building a full-stack web application with secure user authentication, high performance, and robust user interaction features. 来源:https://prompts.chat/prompts/cmjnc496x0001ky04kh6wq80b

Comments (0)

M@import-8122d3856df82242a2626214
0

MCP Builder

Skill

Guide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK). 来源:https://prompts.chat/prompts/cmkfjc5790002jr04u2gz336n

F@import-252f10c83610ebca1a059c0b
0

trello-integration-skill

Skill

This skill allows you to interact with Trello account to list boards, view lists, and create cards automatically. 来源:https://prompts.chat/prompts/cmme4q2y90004l7049abloaz7

M@import-ad72b30e28e50ef61263aa8a
0