DEV Community: Furkan Akça

Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence

Furkan Akça — Sat, 28 Mar 2026 14:54:52 +0000

Database schemas often become "black boxes" over time. They accumulate technical debt, hidden bottlenecks, and security vulnerabilities that even seasoned developers might miss during a hectic sprint.

I decided to change that.

I’m excited to introduce AI Database Analyzer & Architect, an enterprise-grade tool built with .NET MAUI and Clean Architecture that acts as an autonomous Senior Database Consultant in your pocket.

Why This Isn't Just "Another AI Wrapper"

Unlike simple chat interfaces, this tool is designed with Architectural Intelligence. It doesn't just read your schema; it audits it across 40+ specialized pillars including:

Performance Tuning: Detecting non-SARGable predicates, missing indexes, and trigger-induced deadlocks.

Security & Privacy: Using NER logic to find unmasked PII/PHI data and identifying SQL injection risks in stored procedures.

Scalability: Identifying horizontal scalability bottlenecks and ORM anti-patterns (like the dreaded N+1).

Data Modeling: Detecting normalization violations (3NF) and circular dependencies.

The Tech Stack
Frontend: .NET MAUI (Multi-platform) with a strict Senior-level MVVM pattern.

Hybrid AI: Toggle between Google Gemini for high-scale cloud intelligence and Ollama for local, privacy-first analysis.

Visualization: Interactive, zoomable ER diagrams powered by Mermaid.js.

Reporting: Executive-level PDF exports using QuestPDF.

Deep-Dive Audits

The analyzer goes deep. It checks for Identity Column Capacity (warning you before your INT runs out), Collation Mismatches that kill index performance, and even AI Model Collapse (detecting if your data is being polluted by synthetic LLM noise).

Open Source & Future

This project is built to bridge the gap between raw database metadata and actionable expert insights. Whether you are using SQL Server, PostgreSQL, or MySQL, this tool helps you ensure your data layer is production-ready.

Check out the repo here: https://github.com/furkiak/AIDatabaseAnalyzer

I'd love to hear your thoughts! What's the biggest "hidden" database issue you've ever encountered in production? Let's discuss in the comments!

Tired of Zoom and Meet? I Built a 2D Virtual Office Universe with WebRTC: Meet Locmind

Furkan Akça — Tue, 24 Mar 2026 15:33:01 +0000

Hello Dev.to community!

We all love the flexibility of remote work, but many of us deeply miss one thing: the natural, spontaneous interaction of a real office. Walking up to a colleague's desk to ask a quick question, chatting by the coffee machine, or gathering around a whiteboard for a brainstorming session...

Standard Zoom, Google Meet, or Discord rooms unfortunately fail to capture this feeling of "working together." Endless calendar invites, cold meetings staring at black screens, and the never-ending "Zoom fatigue" are exhausting for all of us.

To bring back this lost "real office" feel for remote teams and make communication fun again, I developed an open-source project: Locmind.

Locmind is a web-based 2D virtual universe where your teammates can interact with their avatars, chat via real-time voice and video, and build collaborative workspaces. Plus, it runs entirely on HTML5 Canvas without needing to install anything!

Live Demo **(Test your own office): https://www.locmind.com/
**GitHub Repo: https://github.com/furkiak/locmind (If you find the project useful, don't forget to drop a star! )

Locmind's Highlighted Features as a "Virtual Office"
While developing Locmind, I focused on translating natural behaviors from a physical office into a digital environment. Here are the features that separate this project from a standard meeting tool:

Proximity Voice Chat: Want to talk to a coworker? Just walk up to them! Voice volume changes dynamically based on the distance between avatars, just like in real life.
Meeting Rooms and Door Mechanics: Need a private conversation with your team? You can create password-protected conference areas and use door mechanics to close the room to the outside.
Collaboration and Meeting Tools: It has everything a real meeting room should have:

A Shared Whiteboard for a real-time synchronized drawing board.

A collaborative Shared Notepad where you can take meeting notes and export them as .txt files.

Low-latency Screen and Camera Sharing (via PeerJS/WebRTC).

Break Areas (Mini-Games & Music): When taking a break, you can watch YouTube videos synchronized with everyone in the room or blow off some steam in a football stadium with physics-based ball mechanics and scoring.
AFK System: Users who are inactive (falling asleep in the office) for 30 minutes are automatically disconnected to maintain server performance.

What's Under the Hood? (Tech Stack)
To run such an interactive environment smoothly on the browser, I used the following technologies:

Frontend: HTML5, CSS3, Vanilla JavaScript, and the Canvas API for smooth movement mechanics.

Backend: Node.js and Express.js.

Real-time Communication (WebSocket): Socket.io for real-time data flow between the client and server.

P2P Media Transfer: PeerJS (WebRTC) for peer-to-peer video, audio, and screen sharing without overloading the server.

How to Set Up Your Own Server?
It is super easy to spin up your own private Locmind server for your team. Just clone the repo and follow these steps:

Bash
npm init -y
npm install express socket.io
node server.js

Then, go to http://localhost:3000 in your browser and step into your virtual office!

I believe the future of remote work should be more interactive and less exhausting. I am continuing to develop Locmind and am open to any Pull Requests or ideas from the open-source world.

What do you do to keep team communication alive while working remotely? Let’s meet in the comments !

Are You Actually Productive? How I Built a Professional Focus Suite with .NET 9 and Avalonia UI

Furkan Akça — Mon, 23 Mar 2026 10:42:50 +0000

Working remotely is a double-edged sword. On one hand, you have freedom. On the other, the lines between "Deep Work," "Casual Browsing," and "Burnt Out" blur into a gray haze. Most productivity tools are either too colorful and distracting or too simplistic to provide real value.

I built ActiveRest to solve this. It’s a premium, executive-grade productivity suite designed for Windows that doesn't just track time—it analyzes the quality of your work while guarding your ergonomic health.

The Core Philosophy
ActiveRest is designed with a "Carbon & Silver" executive aesthetic. It’s meant to look like a native part of a high-end workstation. No gamification, no "cute" icons—just data-driven performance and health management.

Key Value Propositions:
Intelligent Activity Classification: Uses system telemetry to distinguish between focus sessions and media consumption.

20-20-20 Ergonomic Guardrails: Implements medical-standard eye strain prevention through non-intrusive notifications.

Executive PDF Reporting: Professional-grade documentation of your focus leaks and efficiency metrics.

echnical Deep Dive: Under the Hood
To achieve the performance and professional feel required for a tool like this, I pushed the boundaries of the latest .NET ecosystem.

The Power of .NET 9 & C# 13 Choosing .NET 9 wasn't just about staying current; it was about performance.

Low Memory Footprint: By utilizing the latest GC (Garbage Collection) optimizations, ActiveRest stays under 50MB of RAM while idling in the system tray.

C# 13 Features: I leveraged new features like params collections and improved ref safety to keep the telemetry engine highly efficient.

Custom UI with Avalonia UI (MVVM) I chose Avalonia UI over standard WPF for its modern rendering pipeline and flexible styling.

Frameless Interface: To achieve the "Carbon & Silver" look, I implemented a completely custom, chrome-less window.

Reactive Architecture: Using CommunityToolkit.Mvvm, the UI stays perfectly synced with background telemetry without blocking the main thread.

Precision Telemetry via Win32 P/Invoke Determining "Active" vs. "Rest" requires more than just checking if a window is open. ActiveRest communicates directly with the Windows kernel:

Idle Tracking: I use GetLastInputInfo via P/Invoke to determine the exact millisecond a user goes idle.

Audio Intelligence: By tapping into the Core Audio APIs (WASAPI), the software can detect if a background application (like Spotify or YouTube) is actively playing audio, allowing it to differentiate between a "Silent Break" and "Media Consumption."

High-Fidelity Reporting with QuestPDF Generating professional PDFs in .NET used to be a nightmare of HTML-to-PDF wrappers. ActiveRest uses QuestPDF, a modern, layout-based engine.

Declarative UI for PDF: This allows for complex, paginated executive reports that include charts and efficiency metrics, all rendered at 300 DPI for print-ready quality.

Why This Matters for Remote Workers
When you work remotely, you are your own manager. ActiveRest provides the Executive Report you need to hold yourself accountable. Are you actually hitting 4 hours of Deep Work, or are you losing 40% of your day to "context switching"?

ActiveRest doesn't just tell you that you're tired; it gives you the data to prove why and helps you fix it before the burnout hits.

Try It Out
I’m looking for feedback from fellow developers and remote professionals. How do you balance your deep focus sessions with physical health?

https://github.com/furkiak/ActiveRest

Why I Built a Privacy-First AI Assistant for Visual Studio 2022 (Goodbye Cloud-Only Copilots!)

Furkan Akça — Fri, 20 Mar 2026 17:18:46 +0000

The Problem: Cloud AI is Great, but Privacy is Greater

We all love GitHub Copilot, but let's be honest: in an enterprise environment, Privacy isn't just a buzzword—it's a legal requirement. Sending proprietary codebases to cloud servers is often a strict "no-go" for many companies.

I realized that we needed a bridge between the power of LLMs and the security of a local environment. That’s why I built Local LLM Plugin Modern for Visual Studio 2022.

What is it?

It's a powerful, modern, and highly optimized AI assistant extension. It seamlessly integrates local LLMs via Ollama and cloud-based models like OpenAI, Anthropic (Claude), and Google Gemini directly into your coding environment.

Whether you want to run DeepSeek or Llama 3 entirely offline or leverage GPT-4o for heavy reasoning, this extension offers a native-feeling dark theme experience that boosts your productivity without leaving your IDE.

Engineering Highlights (Built for Performance)

Instead of just "making it work," I rebuilt this extension to meet enterprise standards:

Clean Architecture & MVVM: Separated UI, Core logic, and Infrastructure for maximum maintainability.
Dependency Injection: Utilizing Microsoft.Extensions.DependencyInjection to handle provider factories gracefully.
Lightning Fast Text Injection: Utilizes Visual Studio's native UndoContext. This ensures massive code blocks are applied instantly without freezing the editor and allows for a single-step Undo (Ctrl+Z).
Memory Efficiency: Optimized handling of large text blocks using StringBuilder and StringReader to prevent memory leaks.

Features that Boost DX (Developer Experience)

Multi-Provider AI Support: Switch seamlessly between Ollama, OpenAI, Claude, and Gemini.
Partial Selection Injection: Select a specific part of the AI's response to inject only that portion into your code, ignoring unnecessary conversational filler.
Smart Defaults: Automatically configures API URLs and model names based on the selected provider.
Advanced Text Manipulation Tools: Includes built-in tools to remove duplicates, modify and replicate variables, or batch-erase specific words.
Native Dark Theme: A sleek interface that perfectly matches Visual Studio 2022's native dark mode.

Keyboard Shortcuts (Power User Friendly)

The UI is entirely optimized for keyboard-only navigation:

Ctrl + 1: Open the AI Assistant (Global VS Shortcut).
Enter: Send your prompt to the AI.
Shift + Enter: Apply the response directly to your editor and close the window.
Esc: Cancel and close the assistant.

How to Get It?

You don't even need a link. Just open your Visual Studio 2022, go to Extensions -> Manage Extensions, and search for:

"Local LLM Plugin Modern"

Open Source & Contributing

This project is fully open source under the MIT License. I believe the best tools are built by the community, for the community.

Check out the repo here: furkiak/visualStudioLocalLLMPlugin

I'd love to hear your thoughts! Are you moving towards local LLMs for coding, or is cloud AI still your go-to? Let's discuss in the comments!

visualstudio #csharp #ai #productivity #programming

Building an Enterprise-Grade File Organizer with .NET and Avalonia UI

Furkan Akça — Thu, 19 Mar 2026 13:35:38 +0000

The Motivation

We've all been there: the Downloads folder that looks like a digital jungle. I wanted to build something more than just a simple script; I wanted a robust, silent, and enterprise-grade utility that handles file organization professionally.

Enter SmartFoldering.

The Tech Stack

Framework: .NET Core
UI Framework: Avalonia UI (for that premium cross-platform feel)
Architecture: Strict MVVM using CommunityToolkit.Mvvm
Logging: Serilog (File Sinks)
Serialization: System.Text.Json (Async & culture-independent)

Solving Real-World Engineering Challenges

What makes a file organizer "Enterprise-grade"? It's how it handles edge cases.

The "Large File" Problem (Race Conditions)

Detecting a file is easy with FileSystemWatcher. But what if the file is still being downloaded or copied?I implemented an intelligent Retry & Lock Handling mechanism. The engine waits for the file to be fully released by the OS before attempting to move it, preventing crashes and data loss.

Atomic Saves for ReliabilityTo prevent JSON corruption during unexpected power losses, SmartFoldering uses Atomic Saves. User settings are written to a temporary file first, then swapped—ensuring your rules are always safe.
Silent & Performant Background Ops
Running seamlessly in the system tray, the app uses a Single Instance (Mutex) pattern to ensure background resources are never wasted by multiple instances.

Premium UI/UXI chose a distraction-free, premium dark-grayscale design. The goal was to make a tool that feels like a native part of a high-end workstation, not a flashy toy.

Key Features at a Glance

Real-Time Monitoring: Instant routing via FileSystemWatcher.
Smart Rule Engine: Filter by extensions (.pdf, .jpg) or keywords.
Tray-First Design: Minimizes to tray and supports Windows Startup via Registry.
Professional Logging: Full diagnostics logged in AppData.

Open Source & Contributions

I've decided to open-source this project. Whether you want to use it to clean up your workspace or dive into the MVVM architecture, feel free to check out the repo!

GitHub Repository: https://github.com/furkiak/SmartFoldering

I’m curious to hear your thoughts! How do you handle file organization in your daily workflow? Let's discuss in the comments!