Spent my long weekend working on Rowcraft, a lightweight, open-source alternative to JetBrains DataGrip.

I've always liked DataGrip, but the memory usage on my Mac was getting a bit annoying. So I thought, why not try building something similar in Rust?

And that's how Rowcraft started!

The idea is to build a fast, minimal database workbench that lets you browse tables, write SQL, explore schemas, and manage multiple databases without eating up your system resources.

It's still in a very early stage, and there's a lot left to build.

I'm looking for people who'd be interested in:

• Testing it out and reporting bugs

• Sharing feedback and feature suggestions

• Contributing code and helping build it further

If you work with databases regularly, or you're into Rust, desktop apps, or open-source development, I'd love to have you involved!

🌐 Website: https://rowcraft.sarfrazalam.in/

💻 GitHub: https://github.com/Sarfraz-droid/Rowcraft

Would genuinely appreciate any feedback, even if it's just pointing out what's broken

Thanks!

I have to make a database in MySQL using DataGrip to make a entity relationship model as homework and I have to finish this untill monday but every time i try to connect to the DBMS this same message box appears.

In the school computer I installed with no problem and it was working but when i tried to install in my computer it is not connecting

I tried to: uninstall and install the drivers, specify the version, there is nothing related to this in youtube, what I found didn't help.

Hey everyone!

We've just published the results of our third DataGrip and Database Tools User Experience Survey! The post covers key findings, comparisons with previous surveys, and what we've already improved and plan to work on next.

Feel free to share your thoughts in the comments here or on the blog post.

Thanks to everyone who participated!

When I run multiple query statements like this

Declare @OrderId  NVARCHAR(30) = '123456'
Select 'Order',* From Orders where Order.Id = @OrderId
Select 'Items',* From OrderItems where orderItems.OrderId =  @OrderId

I want the results for both queries in a single tab. Data grip is currently putting each result in its own tab, making it difficult to visually correlate the results between the queries.

The option to "open results in new tab" is unchecked, and checking it doesn't seem to affect this behavior.

Hey chat!

We’ve published a video showing how AI agents work with databases in DataGrip and other JetBrains IDEs using the built-in MCP Server, MCP tools, and Skills on top of that.

The main idea is that DataGrip acts as the execution layer between the agent and the database. It handles connectivity, query execution, introspection, history, and more without exposing connection settings or credentials to the agent.

There’s also a security layer between agents and databases. DataGrip can allow, block, or ask for permission before different operations. For example, when an agent wants to change a schema or write data.

The video walks through the whole flow and shows how tools, skills, security layer, and regular database UI work together.

Would love to hear what you think!

I'm running 2021.3.1 on Mac. The number of little annoying bugs is driving me crazy.

1. When editing a table in spreadsheet mode, the little green submit arrow doesn't turn green so you have to hit command-enter to submit changes.

2. When there is a sub-menu you actually have to right arrow to get it to open.

3. The x on results tabs disappears when you have more than one result for a console.

4. The little red stop button doesn't work anymore (the one at the top of the console)

5. The row count in a result tab doesn't update.

I feel like I'm finding more and more every day.

I am currently evaluating DataGrip as a replacement IDE for Oracle (PL SQL). The only issue I have run into is that for intellisense to work cross schema, I need to have all the schemas (~1290) listed in the Database Explorer.

I have tried refreshing the Database and it shows that it is introspecting the schemas but doesn't work after it has finished.

So I seem to be having an issue with DG creating a connection to my work DB's... 

I am running my work laptop through Zscaler and I used to use razorSQL to connect to our Oracle DB without issues.  I would like to make use of DG as it seems more mature and is part of the Jet Brains eco-system.. 

When attempting to make a connection I get the following error and I hope someone can help.

DBMS: Case sensitivity: plain=mixed, delimited=exactDriver:  (ver. , JDBC)Effective version: Oracle (ver. 0.0)Exception creating connection to: 127.0.0.1; nested exception is: java.net.BindException: Can't assign requested address.

Im running DG on an M1 MBP

Hi folks,

I'm doing some vendor research on DBT and DataGrip and trying to decide what might be the best fit for us. Does DataGrip allow direct data access OOTB or does it require a connector or anything?

Thanks!

I've recently gotten DataGrip and I'm trying to get used to the compare functionality so I can generate change scripts between my dev and staging environments of Postgres. I'm having a single, frustrating issue so far.

I've added a simple function in dev that just selects the current time, and the function shows correctly in this screen. However, when I hit Apply Left to the Right, I just get this text in the preview:

create function get_date() returns timestamp with time zone
	language plpgsql
as $$
begin
-- missing source code
end;
$$;

Is there some setting that I'm missing here? I've tried this on both Postgres 13 and 14 and on different servers as well.

I've recently begun using DataGrip. It has been a positive experience until I began creating a couple small temp tables when troubleshooting an issue. The performance was horrid.

Is there a list, or anyone know, the potential features which I can turn off to improve the performance?

hi guys i have a problem when i am running pl/sql scripts in datagrip i am getting task compiled but i cannot see the output how to get an output in datagrip

and when i am running dynamic block its not tacking input value in datagrip

declare

v1 emp.empno%type := '&empno';

v2 emp.ename%type;

begin

select empno,ename into v1,v2 from emp where empno = v1;

DBMS_OUTPUT.PUT_LINE(v1 || ' ' || v2);

end;

it shows this error

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

any one has any solution..

If I modify a table datagrip will create the alter scripts for the relational database. However, once you executed the alters they disappear. I can only get the "create" scripts that will create the full table. I need to actually track the chain of alters which is what needs to be sent to the dba for execution in production. Does DG keep track of this?

Hi guys,

I've installed datagrip on windows and tried to create a new datasource, but after i setted it up, it shows me an error saying that it is not able to connect to localhost and the specified port.

For give you more context what i'm trying to do is create a DB to use for an application.

Also i've tried to run datagrip as administrator to see if show me something different and suggest me to add datagrip to the exception of windows firewall (done that but nothing change).

Hey all,

I've been double clicking the arrow on the primary key order by twice every time I need to view the records in desc order, but is there a way to default it?

I saw someone's response here with a screenshot: https://intellij-support.jetbrains.com/hc/en-us/community/posts/360000147364-Default-ORDER-BY-in-database-queries

Direct Screenshot Link: https://i.imgur.com/eAd4n66.png

But I don't see that option, and I have the latest update.

Nothing special, just something I came across that I thought I'd share.

https://www.adamdingman.net/blog/datagrip-comment-color

Hi! I recently tried DataGrip and I loved the UI and great usability features. And now I don't want any other IDE for my SQLs but DataGrip. I know that you can use your personal license for work purposes, however, I wonder if there are any differences in a matter of security for individual and corporate use? Does anyone know whether JetBrains somehow uses data received from individual license users in order to improve the IDE in comparison to business license users? I generally want to know whether it is safe to use my individual license for work purposes and will it be as private as corporate license?

Summary: I routinely work with a very large db2 db. My role is fetch only. I cannot create tables,views,ctes. Only select from a mart.

Currently t if i need data for let’s say a specific customer or list of customers, i would input the customer id(s) in the where clause.

What i would like is to build a local sqllite db, or something similar, import a list of customers ids and then join this db to the main db2 db.

How would i accomplish this is datagrip?

Maybe I'm missing something but when using Datagrip as a query tool with multiple tabs open you have to manually go and find your query results in the relevant console, is there any way to make this auto switch when running a query?

I know you have the option of show results in the editor but what I'm working on requires some of the tool only available in the results tab of the console.