Functions — github.com/HenkDz/selfhosted-supabase-mcp

hub / github.com/HenkDz/selfhosted-supabase-mcp / functions

Functions54 in github.com/HenkDz/selfhosted-supabase-mcp

⨍ Functions 54 ◇ Types & classes 19

↓ 64 callersFunctioncreateMockClient

(options: MockClientOptions = {})

src/__tests__/helpers/mocks.ts:66

↓ 57 callersFunctioncreateMockContext

(client?: SelfhostedSupabaseClient)

src/__tests__/helpers/mocks.ts:110

↓ 56 callersFunctionexecuteSqlWithFallback

( client: SelfhostedSupabaseClient, sql: string, readOnly: boolean = true )

src/tools/utils.ts:119

↓ 36 callersFunctionhandleSqlResponse

(result: SqlExecutionResult, schema: z.ZodSchema<T>)

src/tools/utils.ts:68

↓ 31 callersMethodcreate

* Factory function to create and asynchronously initialize the client. * Checks for the existence of the helper RPC function.

src/client/index.ts:82

↓ 25 callersFunctioncreateSuccessResponse

(rows: Record<string, unknown>[])

src/__tests__/helpers/mocks.ts:121

↓ 18 callersMethodexecuteSqlWithPg

* Executes SQL directly against the database using the pg library. * Requires DATABASE_URL to be configured. * Useful for simple queries w

src/client/index.ts:246

↓ 17 callersFunctioncreateMocks

()

src/__tests__/server/auth-middleware.test.ts:23

↓ 14 callersMethodisPgAvailable

* Checks if the direct database connection (pg) is configured.

src/client/index.ts:463

↓ 13 callersMethodexecuteTransactionWithPg

* Executes a series of operations within a single database transaction using the pg library. * Requires DATABASE_URL to be configured. * @

src/client/index.ts:314

↓ 13 callersFunctionisSqlErrorResponse

(result: SqlExecutionResult)

src/tools/utils.ts:60

↓ 12 callersFunctioncreateToken

(payload: Record<string, unknown>, options?: jwt.SignOptions)

src/__tests__/server/auth-middleware.test.ts:48

↓ 10 callersFunctioncreateErrorResponse

( message: string, code?: string, details?: string, hint?: string )

src/__tests__/helpers/mocks.ts:128

↓ 8 callersMethodexecuteSqlViaRpc

* Executes SQL using the preferred RPC method.

src/client/index.ts:110

↓ 6 callersFunctionrunExternalCommand

(command: string)

src/tools/utils.ts:89

↓ 3 callersFunctioncreateAuthMiddleware

(jwtSecret: string)

src/server/auth-middleware.ts:50

↓ 3 callersMethodgetSupabaseUrl

()

src/client/index.ts:434

↓ 2 callersMethodensurePgPool

* Ensures the pg connection pool is initialized. * Should be called before accessing this.pgPool.

src/client/index.ts:278

↓ 2 callersMethodgetAllowedOrigins

* Gets the list of allowed origins from configuration.

src/server/http-server.ts:141

↓ 2 callersMethodgetAnonKey

()

src/client/index.ts:438

↓ 2 callersMethodgetDbUrl

* Gets the configured direct database connection URL, if provided.

src/client/index.ts:456

↓ 2 callersMethodgetJwtSecret

* Gets the configured JWT secret, if provided.

src/client/index.ts:449

↓ 2 callersMethodgetServiceRoleKey

()

src/client/index.ts:442

↓ 2 callersMethodisServiceRoleAvailable

* Checks if the service role client is available for privileged operations. * Required for execute_sql RPC since it's restricted to service_role

src/client/index.ts:471

↓ 2 callersMethodstop

()

src/server/http-server.ts:454

↓ 1 callersFunctioncanAccessTool

( userRole: string, toolPrivilegeLevel: ToolPrivilegeLevel )

src/tools/types.ts:49

↓ 1 callersMethodcheckAndCreateRpcFunction

()

src/client/index.ts:346

↓ 1 callersMethodcheckRateLimit

* Simple in-memory rate limiter. * Returns rate limit status and info for response headers.

src/server/http-server.ts:84

↓ 1 callersMethodcleanupExpiredRateLimitEntries

* Cleans up expired rate limit entries to prevent unbounded memory growth. * Called periodically by the cleanup interval.

src/server/http-server.ts:66

↓ 1 callersFunctioncreateMcpServer

(userContext?: UserContext)

src/index.ts:266

↓ 1 callersFunctioncreateMockSupabaseClient

(overrides?: Partial<MockSupabaseClient>)

src/__tests__/helpers/mocks.ts:46

↓ 1 callersFunctiondetectWriteQuery

(sql: string)

src/tools/explain_query.ts:92

↓ 1 callersMethodexecuteSqlViaServiceRoleRpc

* Executes SQL using the service role client (privileged). * Required because execute_sql RPC is restricted to service_role only. * SECURI

src/client/index.ts:176

↓ 1 callersMethodgetClientKey

* Get client identifier for rate limiting (IP address).

src/server/http-server.ts:129

↓ 1 callersMethodgetCorsAllowOriginValue

* Gets the appropriate Access-Control-Allow-Origin header value for a request. * Returns the origin if it's in the allowlist, '*' for same-origi

src/server/http-server.ts:190

↓ 1 callersMethodinitialize

* Initializes the client by checking for the required RPC function. * Attempts to create the function if it doesn't exist and a service role key

src/client/index.ts:92

↓ 1 callersFunctionisWithinWorkspace

* Validates that a resolved path is within a workspace boundary. * This is the security check that prevents path traversal attacks. * * @param norm

src/tools/generate_typescript_types.ts:64

↓ 1 callersFunctionmain

()

src/index.ts:83

↓ 1 callersFunctionnormalizeOutputPath

* Normalizes and validates the output path for cross-platform compatibility. * Includes path traversal protection when workspacePath is provided. *

src/tools/generate_typescript_types.ts:78

↓ 1 callersFunctionredactDatabaseUrl

(url: string)

src/tools/utils.ts:20

↓ 1 callersMethodsetCorsHeaders

* Sets CORS headers on the response. * The allowOrigin parameter comes from getCorsAllowOriginValue() which * validates against our allowl

src/server/http-server.ts:339

↓ 1 callersMethodsetupMiddleware

()

src/server/http-server.ts:231

↓ 1 callersMethodsetupRoutes

()

src/server/http-server.ts:352

↓ 1 callersMethodstart

()

src/server/http-server.ts:433

↓ 1 callersFunctiontryAnalyticsLogs

( client: ToolContext['selfhostedClient'], service: LogService, limit: number, context: To

src/tools/get_logs.ts:86

↓ 1 callersFunctiontryPostgresCsvLogs

( client: ToolContext['selfhostedClient'], limit: number, context: ToolContext )

src/tools/get_logs.ts:180

Methodconstructor

* Creates an instance of SelfhostedSupabaseClient. * Note: Call initialize() after creating the instance to check for RPC functions. * @pa

src/client/index.ts:57

Methodconstructor

(options: HttpMcpServerOptions, mcpServerFactory: McpServerFactory)

src/server/http-server.ts:47

FunctioncreateMockExpressReqRes

()

src/__tests__/helpers/mocks.ts:243

FunctiongetDirectory

* Gets the directory portion of a path.

src/tools/generate_typescript_types.ts:51

MethodisOriginAllowed

* Check if origin is allowed by CORS configuration.

src/server/http-server.ts:152

FunctionsanitizeErrorForLogging

(error: unknown)

src/tools/utils.ts:41

FunctionsanitizeSchemaName

* Sanitizes a schema name to prevent command injection. * Only allows alphanumeric characters, underscores, and hyphens. * * @param schema - The sc

src/tools/generate_typescript_types.ts:18

FunctiontoAbsolute

* Resolves a path to an absolute path. * The caller MUST validate the result before using it for file operations. * * SECURITY: Path tr

src/tools/generate_typescript_types.ts:42