Sep 25, 2023
Launch week day 1: AI SQL assistant, permissioning, SAML SSO
Sep 25, 2023
Today we’re kicking off our first launch week.
At Basedash, we’re building the best way to view and manage your data. We’ve come a long way towards delivering on that promise - and we have several major improvements and features to show for it.
We’ll be releasing them each day between today and Thursday, so keep an eye out for announcements.
1. AI query assistant
You can now use an AI-powered SQL assistant to help you write queries. You can find the AI assistant right above the SQL editor when you create a new Query. The assistant understands the structure of whatever database you have connected to Basedash, so simply describe in plain English the data you want to see and the assistant will automatically generate a query for you.
The assistant can also read through broken queries to help you identify what went wrong (like broken syntax or an incorrect column name). Simply click the “ask AI to fix” button next to the error message.
We want teams feel comfortable letting their colleagues write SQL queries. We’ve added two improvements to our permission system to ensure that members of your workspace have exactly as much access as you allow.
First, you can only run SELECT statements in queries - which means you can no longer run queries that delete records or drop tables. (Note that if you want team-members to edit and delete specific records, you can enable that workflow under a View).
Second, we’ve added Creators - a new role for your workspace settings. Creators can create new views and queries, but not manage anything at the workspace-level. That means you can now enable teammates to write create and edit SQL queries without giving them Admin access to the entire workspace - perfect for colleagues who want to try the new AI SQL assistant.
3. SAML SSO
We’ve enabled SAML SSO so you can control authentication and make sure that access for a user is revoked if, say, that person leaves your company.
SAML SSO is currently available on our Enterprise plan. Reach out to email@example.com if you’d like to enable it for your workspace. Once we do, you can set it up by adding and verifying an email domain from your workspace settings and then copying several strings to and from your identity provider.