N6k – Let users and agents run untrusted SQL on production databases (github.com)

N6K has launched a new tool that allows users and agents to run untrusted SQL queries on production databases while managing access and permissions. Using the n6k protocol via WebSocket, it serves DuckDB catalogs, which can be run locally without needing an account. This flexibility enables AI agents, like Claude Code, to query databases with client-specific restrictions on visibility and editing capabilities. The integration of OpenID Connect (OIDC) allows for personalized data access, ensuring clients see only their designated rows. This development is significant for the AI/ML community as it combines local and cloud data sources seamlessly, bolstering the accessibility and security of database interactions. The design employs modern features such as memory limits, fine-grained access controls, and robust logging capabilities, making it adaptable for various use cases. By supporting both local installations and cloud integrations, N6K enhances data handling for applications that leverage AI to interact with large datasets, paving the way for more advanced data querying and manipulation strategies in machine learning environments.