Skip to content

CodeQuery API is a Python/Flask tool designed to serve code-focused AI assistants with the real-time status of a codebase, by allowing seamless querying of a project's file structure and content.

License

Notifications You must be signed in to change notification settings

danfmaia/CodeQuery-API

Repository files navigation

CodeQuery API

CodeQueryGPT cover artwork

CodeQuery™ API is a lightweight and efficient Python/Flask tool designed to enable AI assistants—such as custom GPTs—to navigate and interact with local code. With this API, LLM agents can query project structures and retrieve file contents, helping developers explore and manage large codebases. By adhering to customizable ignore patterns, the API ensures that only relevant files are accessed, making it an invaluable tool for AI-driven code analysis and development.

🤖 Curious Fact: During its development, the CodeQuery API was an integral part of its own creation process, being used to analyze, write, and debug its own files while the project evolved. This unique feedback loop made it a participant in its own development stages! For more details on how the CodeQuery API has been applied, see the Cases section.

Features

  • Designed for AI Assistants: This API was specifically designed to integrate with AI assistants such as custom GPTs, providing them with efficient access to project file structures and contents.
  • Retrieve Project Structure: Get a detailed view of the project’s directories and files.
  • Retrieve File Contents: Access the contents of specific files in the project, with error handling for non-existent paths.
  • Custom Ignore Patterns: Utilize .agentignore and/or .gitignore for specifying which files or directories to exclude from the structure retrieval.

API Endpoints

1. Retrieve Project Structure

  • Endpoint: /files/structure

  • Method: GET

  • Description: Retrieves the directory structure of the project, respecting the ignore patterns in .agentignore. This is useful for tools that need to understand the file organization, such as code editors or static analysis tools.

  • Response Example:

    {
      ".": {
        "directories": ["backend", "frontend", "config"],
        "files": [".env", "README.md"]
      },
      "backend": {
        "directories": ["controllers", "models", "services"],
        "files": ["app.py", "database.py"]
      },
      "frontend": {
        "directories": ["components", "pages"],
        "files": ["index.html", "app.js"]
      },
      "config": {
        "directories": [],
        "files": ["settings.yaml", "logging.conf"]
      }
    }
  • Error Scenarios:

    • 500 Internal Server Error: If there’s a failure in reading the directory structure, such as permission issues or corrupted files, an internal error response will be returned.

    Example Error Response:

    {
      "error": "Failed to retrieve directory structure: [Detailed error message]"
    }

2. Retrieve File Contents

  • Endpoint: /files/content

  • Method: POST

  • Description: Retrieves the content of specified files. Useful for directly accessing specific source files or configuration files.

  • Request Body:

    {
      "file_paths": ["backend/app.py", "frontend/app.js"]
    }
  • Response Example:

    {
      "backend/app.py": {
        "content": "# Main application file\nfrom flask import Flask\napp = Flask(__name__)\n\n@app.route('/')\ndef index():\n    return 'Hello, World!'"
      },
      "frontend/app.js": {
        "content": "// Frontend application logic\nimport React from 'react';\nfunction App() {\n    return (<div>Hello, World!</div>);\n}"
      }
    }
  • Error Scenarios:

    • 400 Bad Request: If no file paths are provided in the request body.

    Example Error Response:

    {
      "error": "No file paths provided in the request."
    }
    • 404 Not Found: If all the requested file paths do not exist or are missing.

    Example Error Response:

    {
      "error": "All requested files are missing"
    }
    • 422 Unprocessable Entity: If a directory is specified instead of a file.

    Example Error Response:

    {
      "frontend/components": {
        "error": "Cannot read directory: frontend/components"
      }
    }
    • 500 Internal Server Error: If there’s a failure in reading a file due to permissions, encoding issues, or other OS-level errors.

    Example Error Response:

    {
      "backend/app.py": {
        "error": "Error reading file: [Detailed error message]"
      }
    }

.agentignore File

The .agentignore file works similarly to .gitignore, allowing you to specify files and directories that should be excluded from file structure queries (/files/structure endpoint).

Example:

# General
.git/
.gitignore
.vscode/
assets/
public/

# Python
src/__pycache__/
tests/__pycache__/
__pycache__/
venv/
.benchmarks/
.pytest_cache/
.env
requirements.txt

# JavaScript
node_modules/
package-lock.json
package.json

Environment Variables

The CodeQuery API relies on environment variables, defined in an .env file located in the root directory, to configure its behavior. Follow these steps to set up the environment variables correctly:

  1. Locate template.env: After cloning the repository, find the template.env file in the root directory. This file serves as a template for the necessary environment variables.

  2. Rename template.env to .env: Before customizing the variables, rename the file:

    mv template.env .env
  3. Customize the Variables: Adjust the variables in the .env file according to your project’s requirements:

    # Project Settings
    PROJECT_PATH="../my-project"                  # Set this to the root path of your project
    AGENTIGNORE_FILES=".agentignore,.gitignore"   # Specify custom ignore patterns for file structure queries
    
    # API Integration
    API_KEY="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"    # Your personal API key (if applicable)
    GATEWAY_BASE_URL="https://codequery.dev"      # Set to your Gateway's public URL (if applicable)
    NGROK_AUTHTOKEN="YOUR_NGROK_AUTHTOKEN"        # Your ngrok authtoken for v3.x
    
    # Other
    LOCAL_PORT=5001                               # Port number for running the Core component locally
    TIMEOUT=10                                    # Request timeout in seconds
    

Installation and Usage

Prerequisites

  • Docker
  • Docker Compose (optional)

Installation Steps

  1. Clone the repository:

    git clone https://github.com/danfmaia/CodeQuery-API.git
    cd CodeQuery-API
  2. Build the Docker image:

    docker build -t codequery_core .
  3. Set up the environment variables:

    Refer to the Environment Variables section for a complete guide on setting and customizing variables. Key variables to review include:

    • PROJECT_PATH
    • API_KEY
    • NGROK_AUTHTOKEN
  4. Run the container:

    • Use Docker to start the container:

      docker run -d -p 5001:5001 -p 4040:4040 --name codequery_core --env-file .env codequery_core
    • This command will run the CodeQuery Core component and expose it on port 5001. Ngrok’s local API will be accessible on port 4040 for tunnel management.

Testing the API

Once the container is running, you can test the API by sending requests to the exposed endpoints.

  • Retrieve Project Structure:

    curl -H "X-API-KEY: $API_KEY" http://127.0.0.1:5001/files/structure
  • Retrieve File Contents:

    curl -X POST -H "Content-Type: application/json" -H "X-API-KEY: $API_KEY" \
    -d '{"file_paths": ["core/run.py", "core/src/ngrok_manager.py"]}' \
    http://127.0.0.1:5001/files/content

For extensive testing, refer to the Testing Guide.

Other Exposure Options

1. Using a Paid Ngrok URL

  • Description: If you have a paid ngrok plan, set up a permanent public URL by running the Core component locally and using the ngrok URL for external access.

  • Command:

    python run_local.py
  • Use Case: Suitable for users who require a consistent external URL and prefer a simple setup.

2. Setting Up a Self-Hosted Server

  • Description: For users with a static IP or home server, you can host the Core directly using your ISP’s services, avoiding ngrok or Gateway usage.

  • Command:

    python run_local.py
  • Steps:

    1. Check Static IP Availability: Ensure your ISP offers a static IP.
    2. Port Forwarding: Configure your router to forward traffic on port 5001 to the local machine.
    3. Domain Setup: Consider using a custom domain for access.
    4. SSL/TLS Configuration: Use services like Let's Encrypt to secure the server.

CodeQueryGPT – Creating your own custom GPT for using this API

This API was designed to be used by custom AI assistants. If you are a ChatGPT Premium user, you can create a custom GPT using the ChatGPT Builder.

Steps:

  1. Go to the GPT Builder in your ChatGPT Premium account.
  2. Access the Create tab.
  3. Send the following prompt to the GPT Builder to create your custom GPT:

Name: CodeQueryGPT

Description: Helps developers analyze code, debug issues, and develop features, by leveraging an API to retrieve project structure and files.

Instructions:
"""
You are CodeQueryGPT, an AI specialized in assisting with software development tasks by actively querying project files, analyzing code structure, and providing coding support. You use an external API to fetch file structures and retrieve file contents as needed.

Your goal is to assist with code analysis, feature development, debugging, and understanding code dependencies, contributing directly to the development process. You should determine when to query the project structure or relevant files, integrating this step into your workflow naturally.

Use a Chain of Thought (CoT) approach to break down complex tasks into clear steps. When debugging or implementing features, proactively query test results, logs, and relevant files to understand the problem or requirements. Focus on suggesting clear, actionable code changes or improvements while ensuring that you have all the necessary context to perform the task effectively.
"""

Conversation Starters:

- Analyse the code following a thorough CoT process. Use both endpoints.
- Help me investigate and debug an issue in the code.
- I need assistance in developing a new feature.
- Query the main files and help me refactor them for better performance.

  1. Once the GPT is created, go to the Configure tab.
  2. [Optional] Customize the GPT initialization settings as needed.
  3. Enable the "Code Interpreter & Data Analysis" option.
  4. Create a new Action by providing the following OpenAPI schema:
{
  "openapi": "3.1.0",
  "info": {
    "title": "CodeQuery API",
    "description": "A Flask API to retrieve the file structure and contents of a project directory.",
    "version": "1.0.0"
  },
  "servers": [
    {
      "url": "https://codequery.dev"
    }
  ],
  "paths": {
    "/files/structure": {
      "get": {
        "summary": "Retrieve the file structure",
        "description": "Returns the file structure of the project directory in a nested format, showing directories and files.",
        "operationId": "getFileStructure",
        "responses": {
          "200": {
            "description": "Successful response with the file structure",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "directories": {
                      "type": "array",
                      "items": {
                        "type": "string"
                      },
                      "description": "List of directory names"
                    },
                    "files": {
                      "type": "array",
                      "items": {
                        "type": "string"
                      },
                      "description": "List of file names"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/files/content": {
      "post": {
        "summary": "Retrieve file contents",
        "description": "Accepts a list of file paths and returns their contents or an error message if the file does not exist.",
        "operationId": "retrieveFiles",
        "requestBody": {
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "file_paths": {
                    "type": "array",
                    "items": {
                      "type": "string"
                    },
                    "description": "A list of file paths to retrieve"
                  }
                },
                "required": ["file_paths"]
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "Successful response with file contents",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "file_path": {
                      "type": "object",
                      "additionalProperties": {
                        "type": "object",
                        "properties": {
                          "content": {
                            "type": "string",
                            "description": "The content of the file"
                          },
                          "error": {
                            "type": "string",
                            "description": "Error message in case of failure"
                          }
                        }
                      }
                    }
                  }
                }
              }
            }
          },
          "400": {
            "description": "Error when no file paths are provided",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "error": {
                      "type": "string",
                      "description": "Error message"
                    }
                  }
                }
              }
            }
          },
          "404": {
            "description": "Error when all requested files are missing",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "error": {
                      "type": "string",
                      "description": "Error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

Screenshots

"Configure" screen

CodeQueryGPT Configure 1

CodeQueryGPT Configure 2

CodeQueryGPT Configure 3

"Edit actions" screen

CodeQueryGPT Edit actions 1

CodeQueryGPT Edit actions 2

Cases

1. CoreQuery API (and CodeQueryGPT)

The CoreQuery API itself is the first use case of the CodeQuery API, and it’s the project you’re currently exploring. It serves as a powerful development tool, integrating with AI assistants (such as the CodeQueryGPT) to support developers by providing a structured way to query project files, understand code dependencies, and interact with large codebases. This project was developed using a Test-Driven Development (TDD) approach to ensure the correctness of the AI-generated code.

2. SkillChrono

SkillChrono is a Python-based tool designed to help developers organize and visualize their technical skills across various projects. It processes structured data, aggregates experience per technology, and generates markdown reports sorted both alphabetically and by experience duration. SkillChrono was also built using a TDD approach, and the CodeQuery API was integral to its development, supporting everything from feature implementation to documentation generation.

For more details, see the SkillChrono repository.

Privacy

For information on how data is handled by this API, please refer to the Privacy Policy. The policy explains what data is processed, how it's used, and the lack of data retention within the API.

License

This project is licensed under the Apache License, Version 2.0.
You may obtain a copy of the License at:

http://www.apache.org/licenses/LICENSE-2.0