prompts.chatprompts.chatprompts.chat
BotsPromptsSkillsWorkflowsCategoriesTagsPromptmastersTaste
Developers
LoginRegister
CC0 2026 prompts.chat
GitHub

Creating a Comprehensive Elasticsearch Search Project with FastAPI

Develop a versatile Elasticsearch search project using FastAPI that supports keyword, semantic, and vector search, data splitting and importing, and synchronization with PostgreSQL with future Kafka support.

L
@Leo
about 4 hours agoOctober 30, 2026 at 03:53 PM
Web Development•Web DevelopmentAPIDatabase

Content

Variables
Act as a proficient software developer. You are tasked with building a comprehensive Elasticsearch search project using FastAPI. Your project should: - Support various search methods: keyword, semantic, and vector search. - Implement data splitting and importing functionalities for efficient data management. - Include mechanisms to synchronize data from PostgreSQL to Elasticsearch. - Design the system to be extensible, allowing for future integration with Kafka. Responsibilities: - Use FastAPI to create a robust and efficient API for search functionalities. - Ensure Elasticsearch is optimized for various search queries (keyword, semantic, vector). - Develop a data pipeline that handles data splitting and imports seamlessly. - Implement synchronization features that keep Elasticsearch in sync with PostgreSQL databases. - Plan and document potential integration points for Kafka to transport data. Rules: - Adhere to best practices in API development and Elasticsearch usage. - Maintain code quality and documentation for future scalability. - Consider performance impacts and optimize accordingly. Use variables such as: - to specify the type of search. - for database selection. - to indicate future integration plans.

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.

F@f
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.

Comments (0)

M
@damimehdi20
0

SQL Schema Design Reviewer

Skill

Reviews PostgreSQL and MySQL tables (schema.sql, a dump or a pull request's CREATE TABLE) for design flaws that are cheap to fix before data exists - missing primary keys, money in float columns, foreign keys with mismatched types or no index, 32-bit ids, timestamps without time zone, nullable flags, free-text statuses, reserved names and case-sensitive unique emails. Returns corrected DDL. Includes a stdlib Python linter with --self-test.

F@f
0

JWT Token Inspector

Skill

Decodes a JWT without trusting it and lints the header and claims: alg none, remote jku/x5u keys, missing or expired exp, nbf/iat clock skew, millisecond timestamps, long lifetimes, iss/aud mismatches, sensitive data in the payload, and HMAC signature checks with a secret from an env var. Use when a login or API call fails with 401, or when reviewing token settings. Includes a stdlib Python inspector with --self-test.

F@f
0