Your Context Aware AI-powered Assistant to speed up the development of database related features from Optimised Query(SQL for now) to Schema Planning(coming soon) as IDE and AI SaaS Platform.
Features
Context Aware Query Analysis - Fix query during development natively aligned to your product and infra
SchemaNaut-Powerful Schema Planner AI(Coming Soon) - Your Code Expert while working on new feature with complex schema/table relationships
Apply Changes - Directly apply optimizations to your code
Secure Authentication - OAuth integration with Pikabase AI
Export Reports(Coming Soon) - Export optimization reports or schema analysis as Markdow PDF
Installation
From VS Code Marketplace
Open VS Code
Go to Extensions (Ctrl+Shift+X)
Search for "Flinko IDE - Pikabase AI Extension"
Click Install
Setup
1. Authentication Setup
Before using the extension, you need to authenticate with Pikabase AI:
Open Command Palette (Ctrl+Shift+P)
Run command: Flinko: Sign in to Pikabase AI
Follow the OAuth flow in your browser
Return to VS Code after successful authentication
Usage
Analyzing SQL Queries
Open a SQL file (.sql, .ddl, .dml)
Select a SQL query you want to optimize
Right-click and select "Analyze with Pikabase AI"
Or use keyboard shortcut: Ctrl+Shift+s
Or use Command Palette: Flinko: Analyze with Pikabase AI
Using the Chat Panel
The chat panel will automatically open when you analyze a query:
View Results - See original query, optimized version, and explanations
Apply Changes - Click "Apply to Editor" to replace your query