sqrl
Verified Safeby DataSQRL
Overview
AI-integrated API server providing real-time data access, mutations, and subscriptions via GraphQL, REST, and Model Context Protocol (MCP) endpoints, powered by stream processing.
Installation
exec java $SQRL_JVM_ARGS -cp /opt/sqrl/app/vertx-server.jar com.datasqrl.graphql.SqrlLauncherEnvironment Variables
- KAFKA_BOOTSTRAP_SERVERS
- KAFKA_GROUP_ID
- POSTGRES_VERSION
- POSTGRES_HOST
- POSTGRES_PORT
- POSTGRES_DATABASE
- POSTGRES_AUTHORITY
- POSTGRES_JDBC_URL
- POSTGRES_USERNAME
- POSTGRES_PASSWORD
- BUILD_UID
- BUILD_GID
- DATA_PATH
- UDF_PATH
- SQRL_DEBUG
- SQRL_JVM_ARGS
- SQRL_JVM_TOOL_OPTS
Security Notes
The system dynamically loads and executes user-defined functions (UDFs) by compiling Java code at runtime using JBang and Flink's code generation. This requires trust in the source code of UDFs to prevent malicious code injection. Default database credentials (e.g., 'postgres:postgres') are used for local services if not overridden by environment variables, which is insecure for production deployments. The HTTP server binds to '0.0.0.0' by default, meaning it listens on all network interfaces, which may require careful firewall configuration.
Similar Servers
nlp2sql
Converts natural language queries to optimized SQL for enterprise-scale databases, supporting multiple AI providers and robust schema management.
mcp-server-generator
Generate Model Context Protocol (MCP) servers from database datasources for integration with AI agents, using a visual canvas interface for tool creation and management.
warp-sql-server-mcp
Enables AI assistants like GitHub Copilot and Warp AI to securely interact with Microsoft SQL Server databases using natural language queries, providing enterprise-grade security, performance monitoring, and data management capabilities.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).