Get SQL Schema

​

Description

​

Arguments

• No arguments: This tool does not require any arguments.

​

Example Configuration

export const getSQLSchema = {
    type: "function" as const,
    function: {
        name: "get_sql_schema",
        description: "Get the SQL schema of the database",
    },
};

​

Processing and Exclusions

1. Schema Reading: The function reads the schema from the JSON file located at prisma/json-schema/json-schema.json.
2. Excluded Properties: Properties such as id, createdAt, updatedAt, and others are removed from the schema to prevent unnecessary exposure.
3. Excluded Tables: Certain tables, like _prisma_migrations, Invitation, and Session, are excluded entirely from the returned schema.
4. Schema Cleaning: The function iterates over the schema, removing specified properties and tables before returning the final, filtered schema.

​

Response Handling

• Successful Response: If the schema is successfully read and filtered, the function returns an object containing:
  • schema: The cleaned schema with excluded properties and tables removed.
• Error Handling: If the schema file cannot be read or parsed, an error is logged, and an error message is returned.

{
    "schema": {
        "User": {
            "properties": {
                "name": { "type": "string" },
                "age": { "type": "integer" },
                "address": { "type": "string" }
                // Additional properties, excluding specified fields
            }
        },
        "Product": {
            "properties": {
                "name": { "type": "string" },
                "price": { "type": "number" }
                // Additional properties, excluding specified fields
            }
        }
        // Additional tables, excluding specified tables
    }
}